centos6.10 yum安装mysql 5.6

叁歲伎倆 2022-03-02 02:45 353阅读 0赞

# [centos6.10 yum安装mysql 5.6 ][centos6.10 yum_mysql 5.6] #

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

#yum list installed | grep mysql
    #yum -y remove 文件名

二、安装及配置

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

安装MYSQL数据库

# yum install mysql-community-server -y

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2Zlbmc1NjE2_size_16_color_FFFFFF_t_70][]

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

# chkconfig --list | grep mysqld
    # chkconfig mysqld on

![20190319154146125.PNG][]

三、设置远程root
    启动mysql

# service mysqld start

设置root密码

# mysql_secure_installation

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2Zlbmc1NjE2_size_16_color_FFFFFF_t_70 1][]

登陆root账号

# mysql -uroot -p

建立远程root用户

mysql> select user,host,password from mysql.user;

create user 'root'@'%' identified by 'root';

mysql> set password for root=password('root');

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

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

mysql> show variables like 'character%';

设置编码

# vi /etc/my.cnf

如下(少补)：

\[mysql\]

default\_character\_set = utf8

[mysqld]
    character-set-server=utf8 
    collation-server=utf8_general_ci 
    performance_schema_max_table_instances=400 
    table_definition_cache=400 
    table_open_cache=256
    # 修改
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

重启mysql

# service mysqld restart

再次查看编码：

[centos6.10 yum_mysql 5.6]: https://www.cnblogs.com/007sx/p/7083143.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2Zlbmc1NjE2_size_16_color_FFFFFF_t_70]: /images/20220302/2a55be4f2ba94b3eb7db664c29bdf871.png
[20190319154146125.PNG]: /images/20220302/4fccd137fc3642118adce31970f34227.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2Zlbmc1NjE2_size_16_color_FFFFFF_t_70 1]: /images/20220302/8b179d202d294490a25a8b5e93555d09.png