1、安装依赖库
yum -y update
2、添加MySQL YUM仓库
wget rpm -Uvh mysql-community-release-el5-5.noarch.rpm
3、添加/etc/yum.repos.d/mysql-community.repo
vim /etc/yum.repos.d/mysql-community.repo
centos5.x添加内容
# Enable to use MySQL 5.6[mysql56-community] name=MySQL 5.6 Community Server baseurl=//repo.mysql.com/yum/mysql-5.6-community/el/5/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
centos6.x
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
4、用yum安装MySQL
yum install mysql-community-server
5、清除旧数据库文件
mv /var/lib/mysql /var/lib/mysql-bak
6、启动MySQL
service mysqld start
7、YUM安装MySQL目录说明
/var/log/mysqld.log #MySQL日志目录/var/lib/mysql #MySQL数据文件目录/usr/share/mysql/ #MySQL配置文件目录/usr/bin/ #MySQL启动脚本目录
8、设置用户
CREATE user test_user;USE mysql;UPDATE user SET password=PASSWORD("TEST_PASSWORD") WHERE user='test_user';GRANT ALL ON *.* TO 'test_user'@'%';FLUSH PRIVILEGES;
9、设置默认字符编码
①、添加my.cnf(若存在此文件,请忽略此步骤)
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
②、查询数据库编码
show variables like 'character_set_%';
③、修改/etc/my.cnf
添加内容:
character_set_server=utf8
转载于:https://blog.51cto.com/utrace/1662302