#centos8 安装mysql
yum install -y mysql-server mysql mysql-develservice mysqld start
#添加远程访问权限
mysql -u root -p
mysql> use mysql;
mysql> update user set host = '%' where user = 'root' and host='localhost';
mysql> update user set host = '%' where user = 'root';
mysql> GRANT ALL ON *.* TO 'root'@'%';
mysql> flush privileges;
#设置本地root登录密码
mysql_secure_installation;
#设置远程root登录密码
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
#如果提示.sock找不到可能是mysql未启动
service mysqld start
#centos7.5安装mysql
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
#如果报错: -bash: wget: 未找到命令安装插件
yum -y install wget
3.安装 mysql-community-release-el7-5.noarch.rpm包
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
4.安装MySQL
sudo yum install mysql-server
设置远程访问密码
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "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/
重启MySQL服务
service mysqld restart
