Centos6.X 安装mysql5.6

admin

一、检查系统是否安装其他版本的MYSQL数据

1. yum list installed | grep mysql
   
2. yum -y remove mysql-libs.x86_64

复制代码

二、安装及配置

1. wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
   
2. rpm -ivh mysql-community-release-el6-5.noarch.rpm
   
3. yum repolist all | grep mysql

复制代码

安装MYSQL数据库

1. yum install mysql-community-server -y

复制代码

设置为开机启动(2、3、4都是on代表开机自动启动)

1. chkconfig --list | grep mysqld
   
2. chkconfig mysqld on

复制代码

三、设置远程root
启动mysql

1. service mysqld start

复制代码

设置root密码及相应配置

1. mysql_secure_installation

复制代码

此命令会执行如下几个操作：
  a)为root用户设置密码
  b)删除匿名账号
  c)取消root用户远程登录
  d)删除test库和对test库的访问权限
  e)刷新授权表使修改生效


登陆root账号

1. mysql -uroot -p

复制代码

建立远程root用户

1. mysql> use mysql;
   
2. mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你设置的密码' WITH GRANT OPTION;
   
3. mysql> flush privileges;

复制代码

四、设置utf-8编码
查看mysql原本编码：

1. mysql> show variables like 'character%';

复制代码

设置编码

1. vi /etc/my.cnf

复制代码

如下(少补)：

1. [mysqld]
   
2. character-set-server=utf8
   
3. collation-server=utf8_general_ci
   
4. sql_mode='NO_ENGINE_SUBSTITUTION'
   
5. 
   
6. [mysql]
   
7. default-character-set = utf8
   
8. 
   
9. [mysql.server]
   
10. default-character-set = utf8
    
11. 
    
12. 
    
13. [mysqld_safe]
    
14. default-character-set = utf8
    
15. 
    
16. 
    
17. [client]
    
18. default-character-set = utf8

复制代码

重启mysql

1. service mysqld restart

复制代码

再次查看编码：

1. # mysql -uroot -p
   
2. mysql> show variables like 'character%';
   
3. +--------------------------+----------------------------+
   
4. | Variable_name | Value |
   
5. +--------------------------+----------------------------+
   
6. | character_set_client | utf8 |
   
7. | character_set_connection | utf8 |
   
8. | character_set_database | utf8 |
   
9. | character_set_filesystem | binary |
   
10. | character_set_results | utf8 |
    
11. | character_set_server | utf8 |
    
12. | character_set_system | utf8 |
    
13. | character_sets_dir | /usr/share/mysql/charsets/ |
    
14. +--------------------------+----------------------------+
    
15. rows in set (0.00 sec)

复制代码