在CentOS上重新手动安装mysql(5.7.19)

cd /usr/local

rm -rf mysql
tar -xzvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.19-linux-glibc2.12-x86_64 mysql

cd mysql

mkdir data

cd ..

chown -R mysql mysql/
chgrp -R mysql mysql/

cd mysql/bin

./mysqld –initialize –user=mysql –basedir=/usr/local/mysql/–datadir=/usr/local/mysql/data/
./mysqld –initialize –user=mysql –basedir=/usr/local/mysql/ –datadir=/usr/local/mysql/data/ –lc_messages_dir=/usr/local/mysql/share –lc_messages=en_US

配置my.cnf
vim /etc/my.cnf

[client]
port=3306
socket = /tmp/mysql.sock

[mysqld]
port =3306
socket = /tmp/mysql.sock
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/

将mysqld服务加入开机自启动项
{mysql}/ support-files/
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig –add mysql

– 查看是否添加成功
chkconfig –list mysql

启动服务
service mysql start

./mysql -uroot -p”/LjD(/05)IM,”

mysql> set password=password(“Abcd12345678”);

grant all privileges on . to’root’ @’%’ identified by ‘root’;
alter user ‘root’@’%’ identified by ‘Abcd12345678’;
flush privileges;