Mysql55 : Différence entre versions
De SME Server Wiki
(Page créée avec « installer yum install mysql55 initialiser le password /etc/init.d/mysql55-mysqld stop /opt/rh/mysql55/root/usr/libexec/mysqld --datadir=/opt/rh/mysql55/root/var/lib/... ») |
|||
| Ligne 2 : | Ligne 2 : | ||
yum install mysql55 | yum install mysql55 | ||
| + | |||
| + | configuration de my.cnf | ||
| + | vim /opt/rh/mysql55/root/etc/my.cnf | ||
| + | |||
| + | [mysqld] | ||
| + | datadir=/opt/rh/mysql55/root/var/lib/mysql | ||
| + | socket=/var/lib/mysql/mysql.sock | ||
| + | # Disabling symbolic-links is recommended to prevent assorted security risks | ||
| + | symbolic-links=0 | ||
| + | # Settings user and group are ignored when systemd is used. | ||
| + | # If you need to run mysqld under different user or group, | ||
| + | # customize your systemd unit file for mysqld according to the | ||
| + | # instructions in http://fedoraproject.org/wiki/Systemd | ||
| + | |||
| + | #perso | ||
| + | socket=/var/lib/mysql/mysql55.sock | ||
| + | skip-networking | ||
| + | max_allowed_packet=16M | ||
| + | user=mysql | ||
| + | #port=3307 | ||
| + | |||
| + | |||
| + | [mysqld_safe] | ||
| + | log-error=/var/log/mysql55-mysqld.log | ||
| + | pid-file=/opt/rh/mysql55/root/var/run/mysqld/mysqld.pid | ||
| + | |||
| + | |||
| + | confirguration de sysconfig | ||
| + | vim /opt/rh/mysql55/root/etc/sysconfig/mysqld | ||
| + | |||
| + | socket=/var/lib/mysql/mysql55.sock | ||
| + | |||
| + | |||
Version du 15 mars 2014 à 16:52
installer
yum install mysql55
configuration de my.cnf
vim /opt/rh/mysql55/root/etc/my.cnf
[mysqld] datadir=/opt/rh/mysql55/root/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under different user or group, # customize your systemd unit file for mysqld according to the # instructions in http://fedoraproject.org/wiki/Systemd #perso socket=/var/lib/mysql/mysql55.sock skip-networking max_allowed_packet=16M user=mysql #port=3307 [mysqld_safe] log-error=/var/log/mysql55-mysqld.log pid-file=/opt/rh/mysql55/root/var/run/mysqld/mysqld.pid
confirguration de sysconfig
vim /opt/rh/mysql55/root/etc/sysconfig/mysqld
socket=/var/lib/mysql/mysql55.sock
initialiser le password
/etc/init.d/mysql55-mysqld stop /opt/rh/mysql55/root/usr/libexec/mysqld --datadir=/opt/rh/mysql55/root/var/lib/mysql --bootstrap --user=mysql --skip-grant-tables < /var/service/mysqld/set.password /etc/init.d/mysql55-mysqld start
connecter à
/opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock
