(Notice:以下所有经验也是我根据网上的经验整理的,如有侵权可以联系我删除,Wx:IT_Ezra,QQ 654303408。 有问题讨论也可联系我,QQ同上。)
(ps:以前从未很少接触Linux配置的小白,感觉应该还是比较详细的干货。所有的坑都是亲自踩的,QQ:654303408 欢迎交流)
1.1 检查系统原本装有mysql
⑴ rpm -qa | grep mysql
2.下载mysql的repo源
⑶ yum -y install wget
⑷ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2.1 安装mysql-community-release-el7-5.noarch.rpm包
⑸ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
-
检查是否安装完成。执行⑹ ,进入/etc/yum.repos.d查看是否存在/etc/yum.repos.d/mysql-community.repo,/etc/yum.repos.d/mysql-community-source.repo。(可选)
⑹ cd /etc/yum/repos.d
ls
3.安装mysql
⑺# 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++*
4.重置密码
⑼ 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
5 查询数据库编码格式,确保是 UTF-8,
- #####需要修改编码格式为UTF-8,导入数据库sql的时候,请确保sql文件为utf8编码 , 进 入 m y s q l 命 令 行 后 \color{red}{进入mysql命令行后} 进入mysql命令行后 输入
⒀ show variables like “%char%”;
set names utf8;
####6、开放3306端口号,添加远程链接能力
- #####firewalld 防火墙(centos-7)运行命令,并重启:
⒁firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
-
为root添加远程链接的能力。链接密码为 “******”(内容自拟,不包括双引号,例如"123456"), 在 m y s q l 命 令 行 \color{red}{在mysql命令行} 在mysql命令行 下执行
mysql > ⒂ GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY “******”;
如遇到问题,更多可以参考https://blog.csdn.net/a774630093/article/details/79270080