MySQL安装-原生态安装

MySQL安装-原生态安装

1、下载MySQL安装

http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/

2、配置MySQL扩展源

rpm -ivh http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql57-community-release-el7-10.noarch.rpm

3、yum安装mysql

yum install mysql-community-server -y

4、启动Mysql，并加入开机自启

4.1 启动Mysql

systemctl start mysqld

4.2 查询Mysql，启动状态

systemctl status mysqld

4.3 关闭Mysql

systemctl stop mysqld

4.4 设置开机自启动Mysql

systemctl enable mysqld
# systemctl diabled mysqld

5、使用Mysql初始密码登录数据库

[root@iZuf6fficzegug97wcge01Z mysql]# grep "password" /var/log/mysqld.log
2021-09-09T13:43:04.266720Z 1 [Note] A temporary password is generated for root@localhost: FJ>!&fRBs26n

[root@iZuf6fficzegug97wcge01Z mysql]# grep "password" /var/log/mysqld.log

或一步到位：

[root@iZuf6fficzegug97wcge01Z mysql]# mysql -uroot -p$(awk '/temporary password/{print $NF}' /var/log/mysqld.log)

6、修改数据库密码

数据库默认密码规则必须携带大小写字母、特殊符号，字符长度大于8，否则会报错。

因此设定较为简单的密码时需要首先修改set global validate_password_policy和_length参数值。

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-o0bsLX5W-1631197387566)(C:\Users\长颈鹿\Pictures\MySQL\原生态安装\原生态安装1.png)]

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

7、修改密码

mysql> set password for root@localhost = password('new password');
Query OK, 0 rows affected, 1 warning (0.00 sec)

或

mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

修改密码以后记得退出

mysql > exit

8、登录测试

[root@http-server ~]# mysql -uroot -ppassword

9、可视化工具的登录授权(如果授权不成功，请查看防火墙)

完成上述操作，还不能用可视化的客户端进行连接，需要进行授权：

授权的命令格式：mysql > grant all on . to root@’%’ identified by ‘password’;

比如：

mysql > grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;

然后在刷新，才可以生效；如下：

mysql > flush privileges;

操作完毕，接下来可以使用navicat或者sqlylog进行远程连接