当前位置: 移动技术网 > IT编程>数据库>Mysql > Centos上安装MySQL

Centos上安装MySQL

2019年10月15日  | 移动技术网IT编程  | 我要评论
1、去官网查找最新(你需要的)安装包版本
# https://dev.mysql.com/downloads/repo/yum/

2、下载mysql安装包

# wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3、安装mysq源

# yum -y install mysql80-community-release-el7-3.noarch.rpm

4、查看安装结果

# yum repolist enabled | grep mysql.*
mysql-connectors-community/x86_64       mysql connectors community           128
mysql-tools-community/x86_64            mysql tools community                100
mysql80-community/x86_64                mysql 8.0 community server           145

5、安装mysql服务

# yum install mysql-community-server -y

6、启动mysql

# service mysqld start
# netstat -lntp | grep 3306            //查看3306端口是否起了
# systemctl status mysqld.service      //查看mysql的运行状态

7、查看mysql日志,筛选出临时密码

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

8、用临时密码登录到mysql

# mysql -uroot -p

9、更改root密码,密码要大小写加字符(密码有复杂性要求)

mysql> alter user 'root'@'localhost' identified by 'newpasswd';

10、修改 /etc/my.cnf 或 /etc/mysql/my.cnf,文件加入 utf-8编码

# vim /etc/my.cnf                  //把下面代码粘进去就好
[client]
default-character-set = utf8
[mysqld]
default-storage-engine = innodb
character-set-server = utf8
collation-server = utf8_general_ci
 
# service mysqld restart          //重启数据库即可
 

 

如对本文有疑问, 点击进行留言回复!!

相关文章:

验证码:
移动技术网