Centos6.5 Mysql安装

Step1: 检测系统是否自带安装mysql

# yum list installed | grep mysql

Step2: 删除系统自带的mysql及其依赖

# yum -y remove mysql-libs.x86_64

Step3: 给CentOS添加rpm源，并且选择较新的源

# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

# yum localinstall mysql-community-release-el6-5.noarch.rpm

# yum repolist all | grep mysql

# yum-config-manager --disable mysql55-community

# yum-config-manager --disable mysql56-community

# yum-config-manager --enable mysql57-community-dmr

# yum repolist enabled | grep mysql

Step4: 安装mysql服务器

# yum install mysql-community-server

Step5:启动mysql

# service mysqld start

Step6:搜索临时密码以便登录

# cat /var/log/mysqld.log | grep 'temporary password'

Step7:登录

# mysql -u root -p

Step8:设置允许弱密码

# set global validate_password_policy=0;

Step9:修改密码

# set password = password('123456');

Step10:新版修改mysql密码

# update mysql.user set authentication_string=password('123456') where user='root';

Step11:允许任何IP以root身份远程登录

# grant all privileges on *.* to 'root'@'%' identified by '123456';

Step12:使授权立即生效

# flush privileges;

Step13:设置开机自动启动

# chkconfig --list | grep mysqld

# chkconfig mysqld on

Step14:设置默认编码

# vim /etc/my.cnf

末尾加上： character_set_server=utf8

保存，重启mysql: service mysqld restart

登录mysql查看修改情况：show variables like 'character%';