## 1.安裝mariadb ~~~bash yum -y install mariadb mariadb-server systemctl start mariadb //啟動mariadb systemctl enable maridb // 設置開機自啟動 ~~~ ## 2.登錄mariadb 以root用戶執行下列命令 ``` mysqladmin -u root -p ``` 提示Enter password，沒有密碼直接回車 ## 3.創建用戶 創建用戶 ``` insert?into?mysql.user(Host,User,Password)?values("localhost","admin",password("admin")); ``` 刷新系統權限表 ``` flush?privileges; ``` ## 4.修改指定用戶密碼 ``` update?mysql.user?set?password=password('mypassword')?where?User="root"?and?Host="localhost"; flush?privileges; ```