MySQL是一个开放源码的小型关联式数据库管理系统,开发者为瑞典MySQL AB公司。MySQL被广泛地应用在Internet上的中小型网站中。由于其体积小、速度快、总体拥有成本低,尤其是开放源码这一特点,许多中小型网站为了降低网站总体拥有成本而选择了MySQL作为网站数据库。
这篇文章主要为大家详细介绍了CentOS Yum编译安装MySQL 5.6,具有一定的参考价值,感兴趣的小伙伴们可以参考一下
1.检查系统是否安装其他版本的MYSQL数据
- #yum list installed | grep mysql
- #yum -y remove mysql-libs.x86_64
2.安装及配置
- # 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
设置为开机启动(2、3、4都是on代表开机自动启动)
- # chkconfig --list | grep mysqld
- # chkconfig mysqld on
3.设置远程root
启动mysql
- #service mysqld start
设置root密码
- #mysql_secure_installation
登陆root账号
- #mysql - uroot - p
建立远程root用户
- mysql > GRANT ALL PRIVILEGES ON * . * TO 'root'@'%'IDENTIFIED BY '你设置的密码'WITH GRANT OPTION;
- mysql > flush privileges;
4.设置utf-8编码
查看mysql原本编码:
- mysql > show variables like 'character%';
设置编码
- #vi / etc / my.cnf
如下(少补):
- [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
- #service mysqld restart
再次查看编码:
- # 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命令
- export PATH=$PATH:/usr/local/mysql//bin<br>source /etc/profile
来源: http://www.phperz.com/article/17/0911/345236.html