Centos下安装Mysql

1、该命令查看已经安装过的组件。 

rpm -qa | grep -i mysql

2、1命令查看，如果安装过，则执行下面命令卸载，如果没有安装，则忽略该命令

sudo yum -y remove mysql80-community-release-el7-1.noarch(上个命令看到的组件名)

3、下载并安装MySQL官方的 Yum Repository

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

4、安装：

yum -y install mysql57-community-release-el7-10.noarch.rpm

5、安装mysql服务器：

yum -y install mysql-community-server

6、查看mysql状态

systemctl status mysqld.service

7、开启服务

systemctl status mysqld.service

8、查看mysql密码

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

9、登陆mysql,密码第五步可以看到

mysql -uroot -p

10、更改密码(ps:必须更改密码，否则mysql用不了，并且如果密码过于简单会报错。)

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

11、设置外部远程客户端连接

  11.1、将host字段的值改为%就表示在任何客户端机器上能以root用户登录到mysql服务器，建议在开发时设为%。   

use mysql;
update user set host = ’%’ where user = ’root’;

11.2、将权限改为ALL PRIVILEGES

use mysql;
grant all privileges  on *.* to root@'%' identified by "your password";
flush privileges;

13,因为安装了Yum Repository，以后每次yum操作都会自动更新，需要把这个卸载掉

yum -y remove mysql57-community-release-el7-10.noarch

14、查看mysql编码

mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

可以看到：character_set_server和 均为拉丁文

更改编码：

 vim /etc/my.cnf

在[mysqld]结束位置添加如下配置：

character_set_server=utf8

重启mysql服务

systemctl stop mysqld.service
systemctl start mysqld.service

重新登录mysql确认编码是否已经更改成功

mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| 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)

大功告成，本地实用工具测试连接mysql。

 

ps:如果连接不成功，可以通过   netstat -an|grep 3306 查看端口是否开启

开启情况如下：

[root@VM_0_10_centos ~]# netstat -an|grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN