本文共 2709 字,大约阅读时间需要 9 分钟。
(Notice:以下所有经验也是我根据网上的经验整理的,如有侵权可以联系我删除,Wx:IT_Ezra,QQ 654303408。 有问题讨论也可联系我,QQ同上。)
(ps:以前从未很少接触Linux配置的小白,感觉应该还是比较详细的干货。所有的坑都是亲自踩的,QQ:654303408 欢迎交流)⑴ rpm -qa | grep mysql
⑵ yum install mysql
⑶ yum -y install wget
⑷ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
⑸ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
⑹ cd /etc/yum/repos.d
ls
⑺# sudo yum install mysql-server
安装完之后可以再次查看mysql ,同⑴
rpm -qa | grep mysql
Error: Package: mysql-community-libs-5.6.35-2.el7.x86_64 (mysql56-community)
Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: mysql-community-server-5.6.35-2.el7.x86_64 (mysql56-community) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: mysql-community-server-5.6.35-2.el7.x86_64 (mysql56-community) Requires: systemd Error: Package: mysql-community-server-5.6.35-2.el7.x86_64 (mysql56-community) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: mysql-community-client-5.6.35-2.el7.x86_64 (mysql56-community) Requires: libc.so.6(GLIBC_2.17)(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest
⑻yum install glibc.i686
yum list libstdc++*
⑼ mysql -u root
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
⑽sudo chown -R openscanner:openscanner /var/lib/mysql
⑾chown root /var/lib/mysql/
⑿service mysqld restart
mysql -u root -p; mysql > use mysql; mysql > update user set password=password(‘123456’) where user=‘root’; mysql > exit;
service mysqld restart
⒀ show variables like “%char%”;
set names utf8; ####6、开放3306端口号,添加远程链接能力
⒁firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
mysql > ⒂ GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY “******”;
如遇到问题,更多可以参考https://blog.csdn.net/a774630093/article/details/79270080