Mysql安装
(1)安装MySQL官方的 Yum Repository:
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
(2)安装MySQL服务器: yum -y install mysql-community-server
(3)启动MySQL: systemctl start mysqld.service
(4)查看MySQL运行状态: systemctl status mysqld.service
(5)在日志文件中找出密码: grep "password" /var/log/mysqld.log
(6)进入数据库: mysql -uroot -p
(7)修改用户密码:
修改密码要求:
1.密码至少要包含的小写字母个数和大写字母个数:
set global validate_password_mixed_case_count=0;
2.密码至少要包含的特殊字符个数:
set global validate_password_special_char_count=0;
3、密码要求等级:
set global validate_password_policy=LOW
4.密码长度要求:
set global validate_password_length=6;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
(8)开启mysql的远程访问:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
(9)刷新权限:flush privileges;
(10)更改mysql的语言:
进入/etc/my.cnf文件,进入如下四行代码:vi /etc/my.cnf
[client]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
(11)重新启动mysql:service mysqld restart
(注意:由于每个人安装的环境可能不一样,此文章也许只可借鉴)