centos7安装mysql
1.下载mysql5.7包
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
2. 安装
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
3. 安装mysql服务
yum install mysql-server
4.修改配置文件
vi /etc/my.cnf
添加两句
character_set_server=utf8
init_connect='SET NAMES utf8'
(
`character_set_server=utf8:设置默认字符集UTF-8`
`init_connect='SET NAMES utf8':设置默认字符集UTF-8`
)
5. 启动mysql
systemctl start mysqld
mysql -uroot -p
密码:会有一个临时随机密码
获取安装时的临时密码(在第一次登录时就是用这个密码):
grep 'temporary password' /var/log/mysqld.log