Mysql5.7
1# cd /etc/yum.repos.d/ 2 3# 新增编辑一个yum源 4# vim mysql.repo
内容:
1[mysql57-community] 2name=MySQL 5.7 Community Server 3## baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/ 4baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/ 5enabled=1 6gpgcheck=0 7gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 8 9 10# 安装 11yum install -y mysql-community-common mysql-community-libs mysql-community-client mysql-community-server mysql-community-devel 12 13# 启动/停止Mysql (和service mysqld start 效果一样) 14# /bin/systemctl start mysqld.service 15 16# /bin/systemctl stop mysqld.service
启动后:
1# 查看首次启动的随机密码 2# grep 'temporary password' /var/log/mysqld.log 3 4#进入mysql 5# mysql -uroot -pxxx 6 7# 修改密码(5.7版本以上必须要有大小写特殊字符) 8# ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678@Abc'; 9 10# 授权远程登录Mysql 11# GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678@Abc' WITH GRANT OPTION; 12
Mysql8.0
mysql8.0安装有点ZZ,研究一下先
1create user cc@'%' identified by '12345678@Abc'; 2 3GRANT ALL ON *.* TO 'cc'@'%' WITH GRANT OPTION; 4 5ALTER USER 'root'@'%' IDENTIFIED BY '12345678@Abc'; 6 7GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678@Abc' WITH GRANT OPTION;