linux安装mysql步骤

linux数据库安装步骤
yum -y install wget

1. 下载MySql
   wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2. 安装MySql
   yum localinstall mysql57-community-release-el7-11.noarch.rpm

3. 查看是否安装成功
   yum repolist enabled | grep “mysql.-community.”
   安装成功会显示

4. 安装mysql
   yum install mysql-community-server（如果不行先执行 yum module disable mysql在重新执行一下）

5. 启动mysql
   systemctl start mysqld

6. 设置开机自启
   systemctl enable mysqld

7. 查看默认密码
   grep ‘temporary password’ /var/log/mysqld.log

8. 连接数据库
   mysql -u root -p

9. 修改密码格式
   set global validate_password_policy=LOW;
   set global validate_password_length=4;
   10 修改密码
   alter user ‘root’ @‘localhost’ identified by ‘root’;
   11.设置权限
   GRANT ALL PRIVILEGES ON . TO root@‘localhost’ IDENTIFIED BY ‘1234!@#$’ WITH GRANT OPTION;
   Ps:这里设置的权限密码要不得少于8位 要含有数字，字符，大小写字母

10. 刷新权限
    FLUSH PRIVILEGES;

11. 远程连接设置
    GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;

记得关闭防火墙

以上操做完以后打开 Navicat Premium