centOS安装MySQL数据库
1.下载MySQL源文件
#wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
2.Yum安装:
#yum install -y mysql57-community-release-el7-7.noarch.rpm
3.安装MySQL:
#yum install -y mysql-community-server
4.启动MySQL
#systemctl start mysqld
MySQL5.7加强了root用户的安全性,因此在第一次安装后会初始化一个随机密码,以下为查看初始随机密码的方式
#grep 'temporary password' /var/log/mysqld.log
#mysql -u root -p
然后使用上面的密码登录
修改密码,set PASSWORD=PASSWORD('12345678')
会提示:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
修改validate_password_policy参数的值
mysql> set global validate_password_policy=0;
mysql>set global validate_password_length=1;
mysql>set PASSWORD=PASSWORD('password');
#@create database confluence default character set utf8 collate utf8_bin;