|
|
# installation : MySQL
|
|
|
|
|
|
|
|
|
[[_TOC_]]
|
|
|
|
|
|
|
|
|
## serveur
|
|
|
|
|
|
# apt-get install mysql-server
|
|
|
root:$PASSWORD
|
|
|
[à sauver dans inubo/commun/Realisation/inubo/inubo.kdb]
|
|
|
|
|
|
# service mysql stop
|
|
|
# mkdir /srv/mysql
|
|
|
# chown mysql:mysql !$
|
|
|
# chmod 700 !$
|
|
|
# echo '/srv/mysql /var/lib/mysql none defaults,bind 0 0' >>/etc/fstab
|
|
|
# mv /var/lib/mysql/* /srv/mysql/
|
|
|
# mount /var/lib/mysql
|
|
|
# service mysql start
|
|
|
# etckeeper commit 'fstab: bind mount /srv/mysql'
|
|
|
|
|
|
|
|
|
## administration par le web
|
|
|
|
|
|
# apt-get install phpmyadmin
|
|
|
phpmyadmin/reconfigure-webserver: apache2
|
|
|
[MySQL root password]
|
|
|
|
|
|
[si pas VM]
|
|
|
# nano /etc/phpmyadmin/apache.conf
|
|
|
[add after
|
|
|
Options FollowSymLinks
|
|
|
DirectoryIndex index.php
|
|
|
]
|
|
|
Order deny,allow
|
|
|
Deny from all
|
|
|
Allow from $CIDR_NOTATION
|
|
|
# service apache2 reload
|
|
|
# etckeeper commit 'phpmyadmin/apache.conf: Allow from $CIDR_NOTATION' |