systemctl start mariadb # 開啟服務(wù)
systemctl enable mariadb # 設(shè)置為開機自啟動服務(wù)

mysql_secure_installation

Enter current password for root (enter for none): # 輸入數(shù)據(jù)庫超級管理員root的密碼(注意不是系統(tǒng)root的密碼)，第一次進入還沒有設(shè)置密碼則直接回車

Set root password? [Y/n] # 設(shè)置密碼，y

New password: # 新密碼
Re-enter new password: # 再次輸入密碼

Remove anonymous users? [Y/n] # 移除匿名用戶， y

Disallow root login remotely? [Y/n] # 拒絕root遠程登錄，n，不管y/n，都會拒絕root遠程登錄

Remove test database and access to it? [Y/n] # 刪除test數(shù)據(jù)庫，y：刪除。n：不刪除，數(shù)據(jù)庫中會有一個test數(shù)據(jù)庫，一般不需要

Reload privilege tables now? [Y/n] # 重新加載權(quán)限表，y?；蛘咧貑⒎?wù)也許

mysql -u root -p

grant all on *.* to user03@'%' identified by '123456' with grant option

flush privileges;