centos 7 安装mysql 并通过navicat访问

最新推荐文章于 2024-08-18 22:10:09 发布

施小楠

最新推荐文章于 2024-08-18 22:10:09 发布

阅读量590

点赞数

文章标签： linux centos7 mysql

完整的安装记录

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访问