Mysql55 : Différence entre versions

Version actuelle en date du 15 mars 2014 à 16:55

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