Mysql服务安装手顺

古城微笑少年丶 2023-06-30 06:51 5阅读 0赞

## ①概要说明 ##

设备:Liunx CentOS环境  
说明: liunx环境下进行mysql服务安装

## ②下载并安装官方的 yum repository ##

执行下载: wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70]

## ③安装下载过来的文件 ##

执行下载: rpm -ivh mysql57-community-release-el7-11.noarch.rpm  
![在这里插入图片描述][20200115155640625.png]

## ④正式安装mysql ##

执行下载: yum install mysql-community-server  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 2]  
安装成功!

## ⑤操作命令 ##

启动命令: service mysqld start  
停止命令: service mysqld stop  
重启命令: service mysqld restart

## ⑥登录到mysql ##

执行下载: mysql -u root –p  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 3]  
注意: 第一次登录时，密码是没有，需要进输入库里面去添加密码。  
如果登录不进去，可以跳过校验，方法如下:  
1->编辑 /etc/my.cnf ，在\[mysqld\] 部分最后添加一行  
skip-grant-tables  
2->保存后重启mysql  
service mysqld restart  
3->登录mysql  
mysql -u root –p  
4->设置密码  
UPDATE mysql.user SET authentication\_string=PASSWORD(‘密码’) where USER=‘root’;  
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘密码’;  
SET PASSWORD FOR root=PASSWORD(‘密码’);  
5->刷新设置立即生效  
flush privileges;  
6->退出  
exit

## ⑦再次进入时可以根据自己设置的密码登录 ##

## ⑧设置root权限的远程访问 ##

grant all privileges on *.* to root@"%" identified by "密码";
    flush privileges;

## ⑨Navicat正常登录 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200115155620249.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3,size_16,color_FFFFFF,t_70
[20200115155640625.png]: https://img-blog.csdnimg.cn/20200115155640625.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200115155844881.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200115155909792.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200115160026591.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200115160253849.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200115160339463.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5NzY1NzI3,size_16,color_FFFFFF,t_70