CentOS7 64位安装MySql

1. 先检查系统是否装有mysql

rpm -qa | grep mysql

1.  下载mysql的repo源

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

 报错: -bash: wget: 未找到命令

 安装插件  yum -y install wget

1. 安装mysql-community-release-el7-5.noarch.rpm包

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

1. 安装MySQL

sudo yum install mysql-server

1. 重置MySQL密码

mysql -u root

报错：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

原因：原因是/var/lib/mysql的访问权限问题。

chown root /var/lib/mysql/

1. 重启MySQL服务

service mysqld restart

1. 接着登陆设置密码

mysql -u root

use mysql;

update user set password=password('123456') where user='root';

exit;

 

接着继续重启MySQL服务

service mysqld restart

1. 接着设置Root账户远程连接密码

 mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";　

 

重启服务器 service mysqld restart

 

1. 使用外网工具连接MySQL

关闭防火墙

systemctl stop firewalld.service