記錄下安裝及設(shè)置
1.安裝mysql的yum源 5.7
yum install http://repo.mysql.com/mysql57-community-release-el7.rpm
2.安裝mysql
yum install mysql-server -y
3.查看mysql的root密碼并登陸堕花,mysql使用yum安裝之后砂豌,會(huì)生成隨機(jī)密碼存放到日志里面,所以我們要到日志里面找mysql的root密碼
grep 'root@localhost' /var/log/mysqld.log
4.?systemctl start mysqld?#啟動(dòng)mysql數(shù)據(jù)庫(kù)
5.mysql -uroot -p?#登錄mysql數(shù)據(jù)庫(kù)
6.show databases;
7.alter user 'root'@'localhost' identified by 'Hxsaj@126.com';??#修改mysql數(shù)據(jù)庫(kù)root密碼
8.update mysql.user set host = '%' where user = 'root';;?#設(shè)置mysql的root賬戶可遠(yuǎn)程登錄到
9.flush privileges;?#讓所有操作都永久化
10.exit?#退出數(shù)據(jù)庫(kù)