一、mysql安装:
1.删除旧安装(非必须):
(1)查看是否安装:
[root@activemq ~]# rpm -qa|grep mysql
已安装内容如下:
mysql80-community-release-el8-1.noarch
mysql-community-server-8.0.18-1.el7.x86_64
mysql-community-common-8.0.18-1.el7.x86_64
mysql-community-client-8.0.18-1.el7.x86_64
mysql-community-libs-8.0.18-1.el7.x86_64
(2)卸载mysql:
[root@activemq ~]# yum remove mysql mysql-server mysql-libs mysql-common
[root@activemq ~]# rm -rf /var/lib/mysql
[root@activemq ~]# rm -f /etc/my.cnf
2.安装依赖:
(1)安装perl依赖:
[root@activemq ~]# yum install -y perl-Module-Install.noarch
(2)安装net-tools依赖:
[root@activemq ~]# yum -y install net-tools
3.下载rpm离线包:
(1)打开官网,下载rpm离线压缩包,用Xftp 6上传到CentOS7上/root目录下:
地址:https://dev.mysql.com/downloads/mysql/
Red Hat Enterprise Linux / Oracle Linux
RPM Bundle
(mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar)
(2)解压mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar(cd到/root目录):
[root@activemq ~]# tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar
4.安装rpm离线包,按顺序安装(cd到/root目录):
[root@activemq ~]# rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
[root@activemq ~]# rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
[root@activemq ~]# rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm
[root@activemq ~]# rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm
二、mysql启动/关闭/看状态:
1.初始化:
[root@activemq ~]# mysqld --initialize
目录授权:
[root@activemq ~]# chown -R mysql:mysql /var/lib/mysql/
2.启动:
[root@activemq ~]# service mysqld start
3.看状态:
[root@activemq ~]# service mysqld status
4.重启:
[root@activemq ~]# service mysqld restart
5.关闭:
[root@activemq ~]# service mysqld stop
三、连接、修改密码:
1.查看密码:
[root@activemq ~]# cat /var/log/mysqld.log | grep password
2.登录:
[root@activemq ~]# mysql -uroot -p
输入初始密码,回车:
Enter password:
3.修改密码强度要求:
(1)验证策略(值列表,low:0 MEDIUM:1 strong:2):
mysql> set global validate_password.policy=0;
(2)要求最小长度:
mysql> set global validate_password.length=1;
(3)要求数字的最小个数:
mysql> set global validate_password.number_count=0;
(4)要求大小写的最小个数:
mysql> set global validate_password.mixed_case_count=0;
(5)要求特殊字符的最小个数:
mysql> set global validate_password.special_char_count=0;
4.修改密码(已登录,root123456为新密码):
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'root123456';
四、允许远程连接:
1.选择"mysql"数据库:
mysql> use mysql;
2.查看user表中root用户的host(localhost允许本地,%允许远程):
mysql> select host, user, authentication_string, plugin from user;
3.允许root用户远程访问:
(1)更新root用户的host为%:
mysql> update user set host='%' where user='root';
(2)刷新权限:
mysql> flush privileges;
五、使用Navicat连接远程的MySql数据库:
1.下载并安装Navicat:
Navicat | 下载 Navicat for MySQL 14 天免费 Windows、macOS 和 Linux 的试用版
2.使用Navicat连接远程的MySql数据库:
(1)打开Navicat软件,点击"连接"按钮,在下拉列表中选择"MySQL...":
(2)新建连接,填入远程MySql的主机IP、MySql端口、MySql登录用户+密码,确定:
(3)连接成功后如图所示: