centos 7 安装mysql 并通过navicat访问

不念不忘少年蓝@ 2021-12-24 11:13 315阅读 0赞

### [完整的安装记录][Link 1] ###

### **1.下载yum源** ###

[admin@localhost ~]$ sudo wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'

### 2.安装yum源 ###

[admin@localhost ~]$ sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

### 3.查看有哪些版本的mysql ###

[admin@localhost ~]$ yum repolist all | grep mysql

### 4.安装mysql ###

[admin@localhost ~]$ sudo yum install -y mysql-community-server

### 5.查看MySQL状态  ###

[admin@localhost ~]$ systemctl status mysqld

### 6.查看root默认密码 ###

[admin@localhost ~]$ grep 'temporary password' /var/log/mysqld.log
    2019-06-25T09:06:56.081634Z 1 [Note] A temporary password is generated for root@localhost: nhtEBa?&r9ME

### 7.登录mysql ###

(登录数据库：这里-p之后不用输入密码，回车后再输入。改过密码之后登录则是直接在-p后加密码了。)

[admin@localhost ~]$ mysql -uroot -p
    Enter password:

### 8.修改密码 ###

(因为 mysql 设置了密码安全检查插件，你的密码必须包含大小写英文，数字，字符且不小于8位，需注意，以英文分号结束。否则会报下面的错。

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements //不通过密码安全插件检查)

mysql> SET PASSWORD = PASSWORD('Admin123!');

### 9.设置远程可以登录 ###

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Admin123!' WITH GRANT OPTION;

mysql> flush privileges;

### 10.修改mysql配置 ###

（先退出mysql-----------------------------

mysql> quit

）

[admin@localhost ~]$ sudo vim /etc/my.cnf

进入编辑(

sql支持group by语句  
`sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION`

)

character-set-server=utf8
    default-time_zone = '+8:00'
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

### 11.最后重启数据库，使配置生效 ###

[admin@localhost ~]$ systemctl restart mysqld

### 12.设置开机启动 ###

[admin@localhost ~]$ systemctl enable mysqld

### 13.最重要的一步就是3306的端口，通过防火墙放开 ###

[admin@localhost ~]$ sudo systemctl stop firewalld.service
    [sudo] admin 的密码：
    [admin@localhost ~]$ sudo systemctl start firewalld.service
    [admin@localhost ~]$ sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent;
    success
    [admin@localhost ~]$ firewall-cmd --reload

navicat访问

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI5Mjc4NjIz_size_16_color_FFFFFF_t_70][]

[Link 1]: https://blog.csdn.net/qq_29278623/article/details/93638394
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI5Mjc4NjIz_size_16_color_FFFFFF_t_70]: /images/20211224/c2922b9539a14e5fb0886b47dda0fb3d.png