linux-centos7环境搭建-mysql安装

 

1、下载mysql源安装包，安装mysql源，并检查是否成功

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm
yum repolist enabled | grep "mysql.*-community.*"

2、选择安装版本，需要下载版本设置enabled=1

vim /etc/yum.repos.d/mysql-community.repo

3、安装mysql，并启动

yum install mysql-community-server
systemctl start mysqld

4、开机启动设置

systemctl enable mysqld
systemctl daemon-reload

5、配置mysql（root密码设置）

mysql_secure_installation

6、 连接mysql，查看mysql的编码并修改

mysql -uroot -p

mysql>show variables like '%character%';

   database和server编码应该设置为utf-8，具体设置：

 

7、设置允许远程登录

• 将my-default.cnf 拷贝到 /etc/my.cnf  ：cp /usr/share/doc/mysql-community-server-5.6.31/my-default.cnf  /etc/my.cnf
• 编辑/etc/my.cnf在[client](如果没有就自己加)下增加default-character-set = utf8
• 编辑/usr/my.cnf在[mysqld]下增加character_set_server =  utf8
• 重启MySql服务systemctl restart  mysql.service
• 重新连接mysql：mysql -uroot –p

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码';

8、开发端口3306

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