centos7 在线安装MySQL

1、更新软件

yum update

 

 2、下载和添加仓库

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update

 

 3、安装MySql

yum install mysql-server

 

4、启动MySQL

systemctl start mysqld

 

 5、配置MySql

运行如下脚本文件(然受一直y就行，最后一步会让你输入root密码)

mysql_secure_installation

 

 6、修改字符集编码

vim  /etc/my.cnf

========设置如下  在mysqld 和client下分别添加如下配置 client没有自己写======================
 

[mysqld]
character_set_server =  utf8
[client]
default-character-set = utf8

 

7、重启MySQL服务

systemctl restart  mysql.service

 

8.连接MySQL 

mysql -uroot -proot

 

9.查看编码

show variables like '%character%';

修改好以后是这样的

 

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

 

10.设置允许远程登陆 

 设置权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';

应用设置

FLUSH PRIVILEGES;

 重启mysql服务(应该不重启也行，保险起见还是重启吧)

systemctl restart  mysql.service

 

 11.开放端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload