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/... ») |
(→a faire) |
||
| (2 révisions intermédiaires par le même utilisateur non affichées) | |||
| Ligne 1 : | Ligne 1 : | ||
| − | installer | + | ==installer== |
yum install mysql55 | yum install mysql55 | ||
| + | configuration de my.cnf | ||
| + | vim /opt/rh/mysql55/root/etc/my.cnf | ||
| − | initialiser le password | + | [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 | /etc/init.d/mysql55-mysqld stop | ||
| Ligne 11 : | Ligne 44 : | ||
| − | connecter à | + | ==connecter à== |
/opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock | /opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock | ||
| + | |||
| + | == a faire== | ||
| + | racrourcis | ||
| + | mysql55 /opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock | ||
| + | mysqld55 | ||
| + | mysqldump55 | ||
| + | mysqladmin55 | ||
| + | mysqlshow55 | ||
| + | ... | ||
| + | |||
| + | une contrib | ||
Version actuelle en date du 15 mars 2014 à 16:55
Sommaire
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
a faire
racrourcis
mysql55 /opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock mysqld55 mysqldump55 mysqladmin55 mysqlshow55 ...
une contrib
