安装MySQL

8 安装MySQL
cd ~
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm rpm -ivh mysql57-community-release-el7-9.noarch.rpm cd /etc/yum.repos.d/
yum install mysql-server
#启动
systemctl enable mysqld
systemctl start mysqld
  1. vi /etc/my.cnf
  2. 在 [mysqld]最后加上 skip-grant-tables(手敲)
  3. service mysqld restart
  4. mysql -uroot -p 回车
  5. >use mysql;
  6. update user set authentication_string=password(‘密码’) where user=’root’;
  7. 修改回原来配置, 再次登陆后,再改一次密码
  8. mysql -uroot -p我的密码
alter user user() identified by ‘密码’;
开放局域网访问:
use mysql;
update user set host =’%’ where user = ‘root’;
flush privileges;
select host,user from user;
#mysql 开只读账号
GRANT ALL PRIVILEGES ON *.* TO “root”@”localhost” IDENTIFIED BY “密码” WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO “root”@”192.168.0.204” IDENTIFIED BY “密码” WITH GRANT OPTION;
flush privileges;
GRANT Select ON 数据库名.* TO reader@”%” IDENTIFIED BY “只读密码”;    –只有select 权限
添加远程ip访问权限
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’10.10.10.10’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;
flush privileges;