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: 查看mysql是否自启动,并且设置开启自启动
chkconfig --list | grep mysqld
chkconfig mysqld on
Step7: mysql安全设置
mysql_secure_installation
Step8: 由于mysql刚刚安装完的时候,mysql的root用户的密码默认是空的,所以我们需要及时用mysql的root用户登录(第一次回车键,不用输入密码),并修改密码
mysql -u root
use mysql;
update user set password=PASSWORD("这里输入root用户密码") where User='root';
Step9: 授权(自动创建)一个mysql的非root的liming用户,能访问localhost上的test数据库,密码是xxxx,最后刷新权限
grant all privileges on test.* to liming@localhost identified by 'xxxx';
flush privileges;
Step10: 创建一个utf8的表(如果你有需要的话)之后退出
CREATE DATABASE `database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
exit;