CenOS6.7下mysql 8.0.22 安装配置方法图文教程

put e:/mysql-8.0.22-1.el6.i686.rpm-bundle.tar

rpm -qa | grep mysql

rpm -e --nodeps 查到的内容

find / -name mysqld

rm -rf 查出来的文件

mkdir /usr/local/mysql

tar -xvf mysql-8.0.22-1.el6.i686.rpm-bundle.tar -C /usr/local/mysql

rpm -ivh mysql-munity-mon-8.0.22-1.el6.i686.rpm --nodeps --force

rpm -ivh mysql-munity-libs-8.0.22-1.el6.i686.rpm --nodeps --force

rpm -ivh mysql-munity-client-8.0.22-1.el6.i686.rpm --nodeps --force

rpm -ivh mysql-munity-server-8.0.22-1.el6.i686.rpm --nodeps --force

vim /etc/my.f

lower_case_table_names=1

mysqld --initialize

chown -R mysql:mysql /var/lib/mysql

service mysqld status

service mysqld start

chmod -R 777 /var/lib/mysql

cat /var/log/mysqld.log

cat /var/log/mysqld.log | grep password

mysql -u root -p

ALERT user 'root'@'localhost' identified with mysql_native_password by '123456';

create user 'root'@'%' identified with mysql_native_password by '123456';

grant all privileges on . to 'root'@'%' with grant option;

flush privileges;

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

/etc/rc.d/init.d/iptables save