CentOS 7 MySQL数据库安装

CentOS 7 MySQL数据库安装

CentOS 7 版本将MySQL数据库软件从默认的程序列表中移除，用mariadb代替了

卸载 mariadb

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.41-2.el7_0.x86_64

安装MySQL

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server

安装完成后重启

service mysqld restart

初次安装MySQL，root账户没有密码

mysql -u root
set password for 'root'@'localhost' =password('123456');

配置编码

vi /etc/my.cnf
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8

配置远程连接

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