mysql centOS7 腾讯云数据服务器配置密码查找乱码等配置

最近做了一个小的OJ项目  在 Mysql 配置方面做一下笔记

1.su root 转到root用户

2.wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm  

//获取mysql5.7的源

3.yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

//下载mysq5.7

4.systemctl start mysqld.service

//开启mysqld 服务

systemclt status mysqld.service

5.grep "password" /var/log/mysqld.log

//由于password 在某个版本以后，是随机自动生成的，所以需要查找密码

6.ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

//修改密码  如果出问题  的话 ，尽量设置复杂一些

7.vim /etc/my.cnf

/

[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8

[mysql]
no-auto-rehash
default-character-set=utf8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

将以上代码粘贴上去。

//UTF -8 都懂的

8.

 service mysql restart

//重启mysql服务