linux安裝mysql
- 去rmp網(wǎng)站找到相應(yīng)的版本，復(fù)制鏈接
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/
- linux上進(jìn)行下載
rpm -ivh http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql57-community-release-el7-7.noarch.rpm
3.linux上進(jìn)行安裝
yum install mysql-community-server -y
- 啟動mysql
systemctl start mysqld
5.查看mysql是否啟動
systemctl status mysqld
6.查看mysql密碼
grep "password" /var/log/mysqld.log
7.登錄mysql
mysql -uroot -p
8.設(shè)置優(yōu)先級策略(登錄狀態(tài))
set global validate_password_policy=0;
9.設(shè)置mysql密碼（登錄狀態(tài)）
set password for root@localhost = password('root123456');
10.navicat遠(yuǎn)程連接需要授權(quán)（登錄狀態(tài)）
grant all on *.* to root@'%' identified by 'root123456';
11.刷新權(quán)限（登錄狀態(tài)）
flush privileges;
