su root #下载安装用的Yum Repository wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm #安装 rpm -ivh mysql-community-release-el7-5.noarch.rpm #如果Error: Unable to find a match: mysql-community-server yum module disable mysql #安装 yum install mysql-community-server #启动服务 systemctl start mysqld.service #查看服务状态 systemctl status mysqld.service
上面安装和启动了mysql 服务;
下面设置与配置mysql服务:
#查看临时密码 grep "password" /var/log/mysqld.log #进入数据库 mysql -uroot -p #修改密码(强密码) mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWPASSWORD'; #授权远程连接 mysql> grant all privileges on *.* to 'root'@'%' identified by 'NEWPASSWORD' with grant option; #刷新 mysql> flush privileges;
修改字符集;
vi /etc/my.cfg
增加几行:
[client] default-character-set=utf8 [mysqld] character-set-default=utf8 collation-server=utf8_general_ci
重启mysql
service mysqld restart