搬瓦工中文网
本文实例为大家分享了centos yum安装mysql 5.6的具体代码，供大家参考，具体内容如下
1.检查系统是否安装其他版本的MYSQL数据
?
| 1 2 | #yum list installed | grep mysql #yum -y remove mysql-libs.x86_64 |
2.安装及配置
?
| 1 2 3 | # 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数据库
?
| 1 | # yum install mysql-community-server -y |
设置为开机启动(2、3、4都是on代表开机自动启动)
?
| 1 2 | # chkconfig --list | grep mysqld # chkconfig mysqld on |
3.设置远程root
启动mysql
?
| 1 | # service mysqld start |
设置root密码
?
| 1 | # mysql_secure_installation |
登陆root账号
?
| 1 | # mysql -uroot -p |
建立远程root用户
?
| 1 2 | mysql> GRANT ALL PRIVILEGES ON *.* TO 'root' @ '%' IDENTIFIED BY '你设置的密码' WITH GRANT OPTION; mysql> flush privileges; |
4.设置utf-8编码
查看mysql原本编码：
?
| 1 | mysql> show variables like 'character%' ; |
设置编码
?
| 1 | # vi /etc/my.cnf |
如下(少补)：
?
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | [mysqld] character- set -server=utf8 collation-server=utf8_general_ci [mysql] default-character- set = utf8 [mysql.server] default-character- set = utf8 [mysqld_safe] default-character- set = utf8 [client] default-character- set = utf8 |
重启mysql
?
| 1 | # service mysqld restart |
再次查看编码：
?
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | # mysql -uroot -p mysql> 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) |
5.加入环境变量，编辑 /etc/profile，这样可以在任何地方用mysql命令
?
| 1 | export PATH=$PATH: /usr/local/mysql//bin <br> source /etc/profile |
