CentOS7下安装MySql

安装

• 设置数据源：
• wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
• 安装mysql-community-release-el7-5.noarch.rpm包：
• rpm -ivh mysql-community-release-el7-5.noarch.rpm
• 安装：
• yum install mysql-server
• 如果错误中包含：

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)，原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysql的拥有者改为当前用户：
• chown -R openscanner:openscanner /var/lib/mysql
• 如果报chown: 无效的用户: "openscanner:openscanner"错误，更换命令，并用 ll 查看目录权限列表
• chown root /var/lib/mysql/
• 然后，重启服务：
• service mysqld restart
• 接下来登录重置密码：
• mysql -u root -p
• mysql > use mysql;
  mysql > update user set password=password(‘ok’) where user=‘root’;
  mysql > exit;
• 重启服务
• service mysqld restart
• 增加远程服务：
• 
• 完毕