linux centos7安装mysql——字符配置，访问配置

太过爱你忘了你带给我的痛 2022-06-02 04:08 184阅读 0赞

# linux centos7安装mysql——字符配置，访问配置 #

本文主要介绍如何在centos7下安装mysql。

主要参考：

http://blog.51cto.com/professor/1783769

1、下载rpm源

[https://dev.mysql.com/downloads/file/?id=470281][https_dev.mysql.com_downloads_file_id_470281]

2、下载完成后执行命令

rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

yum list mysql\*

yum install mysql-community-server

![Center][]

3、修改数据库编码格式

vim /etc/my.cnf

添加如下内容

\[mysqld\]

character-set-server=utf8

collation-server=utf8\_general\_ci

\[client\]

default-character-set=utf8

4、启动mysql服务systemctl start mysqld

(启动如果出错如何处理：)

rm -rf /var/lib/mysql
    mysqld --initialize --explicit_defaults_for_timestamp
    
    systemctl start mysqld.service
    查看一下状态
    systemctl status mysqld.service
    
    这样需要注意
    /var/lib/mysql的访问权限要给 mysql这个用户，否则会有问题

5、初始化mysql 先修改原始密码

![Center 1][]

6、登录mysql

![Center 2][]

7、修改密码

8、查看编码格式

![Center 3][]

9、授权其他机器能够通过root访问

grant all privileges on \*.\* to 'root'@'%' identified by '123456' with grant option;

grant all privileges on \*.\* to 'root'@'localhost' identified by '123456' with grant option;

flush privileges;

10、使用工具连接，看能否成功

[https_dev.mysql.com_downloads_file_id_470281]: https://dev.mysql.com/downloads/file/?id=470281
[Center]: /images/20220602/e1cf6a25a52548a9b020ab45968a54df.png
[Center 1]: /images/20220602/7b49693e61da439cb7e0027de35e8061.png
[Center 2]: /images/20220602/260a3d8750da47d58c8754b467299675.png
[Center 3]: /images/20220602/7526001f7f944d51ac663f743b06f1ce.png