1.下載并安裝MySQL
命令:wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
? ? ? ? ?? yum localinstall mysql80-community-release-el7-1.noarch.rpm
2.安裝mysql
命令:?yum install mysql-community-server
3.啟動(dòng)
命令:systemctl start mysqld
4.查看啟動(dòng)狀態(tài)
命令:systemctl status mysqld
5.修改密碼
1)查看原始密碼:
命令:grep 'temporary password' /var/log/mysqld.log
2)登錄本地mysql
命令:mysql -uroot -p
輸入原密碼贤斜;
3)修改密碼
命令:ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
注意新密碼要復(fù)雜一點(diǎn),不然會(huì)報(bào)錯(cuò)弱左;
6.添加遠(yuǎn)程登錄用戶
1)查看當(dāng)前用戶的權(quán)限
命令:use mysql;
? ?????????select host, user from user;
2)授權(quán)root可以遠(yuǎn)程訪問
命令:GRANT ALL ON *.* TO 'root'@'%';
如果報(bào)錯(cuò)用下面的命令
命令:update user set host='%' where user ='root';