CenOS6.7下mysql8.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-community-common-8.0.22-1.el6.i686.rpm --nodeps --force

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

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

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

vim /etc/my.cnf

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