centos6安装mysql

港控/mmm° 2022-04-24 11:12 202阅读 0赞

1、安装mysql的yum源
    a、 wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

b.安装用来配置mysql的yum源的rpm包

rpm -Uvh mysql57-community-release-el6-9.noarch.rpm

安装成功后在/etc/yum.repos.d/下会多出几个mysql的yum源的配置，如下：

![aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxMjM4Mjc1OTctMTUyMjg4OTAwMS5wbmc][]

## 2.安装mysql ##

yum install mysql-community-server

## 3.开启mysql服务 ##

service mysqld start

![aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxNDE4MDEwMzUtNzE5ODA5MjY2LnBuZw][]

mysql安装成功后创建的超级用户`'root'@'localhost'的密码会被存储在``/var/log/mysqld.log，可以使用如下命令查看密码`

grep 'temporary password' /var/log/mysqld.log

![aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxNDE5MDE2NDQtMTc4MDc5NDc4LnBuZw][]

输入 mysql -u root -p   密码   (这里的密码和p连着写) 进入  （有时候密码含有特殊字符如>，那么输入\\>转义一下）

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

这里如果出现mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)错误：

vi /etc/my.cnf

加入：

skip-grant-tables

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1Y2t5enNpb24_size_16_color_FFFFFF_t_70][]

重启mysql服务：`service mysqld restart`

密码修改

mysql> update mysql.user set authentication\_string=password('MyNewPass4!') where user='root' and host='localhost';  
Query OK, 1 row affected, 1 warning (0.00 sec)  
Rows matched: 1  Changed: 1  Warnings: 1  
   
mysql>   
mysql> flush privileges;  
Query OK, 0 rows affected (0.01 sec)

完成后，去掉刚添加的参数，

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1Y2t5enNpb24_size_16_color_FFFFFF_t_70 1][]

重启mysql。

5、远程连接设置

把在所有数据库的所有表的所有权限赋值给位于所有IP地址的root用户。

mysql> grant all privileges on \*.\* to root@'%'identified by '输入自己的连接密码';

如果提示需要重新初始化密码，使用![20190809172908729.png][]

6、设置防火墙或者直接关闭

设置iptables开放3306端口

vi /etc/sysconfig/iptables

![aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxNDIxMzE2MjktNzA2NzA5ODUyLnBuZw][]

参考：

1、[https://www.cnblogs.com/jimboi/p/6405560.html][https_www.cnblogs.com_jimboi_p_6405560.html]

2、[https://blog.csdn.net/luckyzsion/article/details/73733616][https_blog.csdn.net_luckyzsion_article_details_73733616]

3、[https://blog.csdn.net/tpc4289/article/details/79711034][https_blog.csdn.net_tpc4289_article_details_79711034]

[aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxMjM4Mjc1OTctMTUyMjg4OTAwMS5wbmc]: /images/20220216/2b8a375469844c8c91479cc2fe6fbba5.png
[aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxNDE4MDEwMzUtNzE5ODA5MjY2LnBuZw]: /images/20220216/6f48bf330998448dbd9b2813fcc39318.png
[aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxNDE5MDE2NDQtMTc4MDc5NDc4LnBuZw]: /images/20220216/f03adeffa700400397c18832b9b6aa57.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1Y2t5enNpb24_size_16_color_FFFFFF_t_70]: /images/20220216/0682dd67686d4b3ab2037b2c882a9f74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1Y2t5enNpb24_size_16_color_FFFFFF_t_70 1]: /images/20220216/889946affe13488e88e390bd8568d664.png
[20190809172908729.png]: /images/20220216/95c87e792d504cff8971909c59e71ddc.png
[aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvODYxNDM4LzIwMTcwMi84NjE0MzgtMjAxNzAyMTYxNDIxMzE2MjktNzA2NzA5ODUyLnBuZw]: /images/20220216/49e5e2ba7d654331bcc671e9d5af9b60.png
[https_www.cnblogs.com_jimboi_p_6405560.html]: https://www.cnblogs.com/jimboi/p/6405560.html
[https_blog.csdn.net_luckyzsion_article_details_73733616]: https://blog.csdn.net/luckyzsion/article/details/73733616
[https_blog.csdn.net_tpc4289_article_details_79711034]: https://blog.csdn.net/tpc4289/article/details/79711034