透過命令列登入管理MySQL伺服器(提示輸入密碼時直接回車):
第一步,登陸mysql
[root@localhostbin]#/usr/local/webserver/mysql/bin/mysql-uroot-p-S/tmp/mysql.sock
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis1
Serverversion:5.5.3-m3-logSourcedistribution
Type"help;"or"\h"forhelp.Type"\c"toclearthecurrentinputstatement.
第二步,使用msyql資料庫mysqlusemysql
Readingtableinformationforcompletionoftableandcolumnnames
Youcanturnoffthisfeaturetogetaquickerstartupwith-A
Databasechanged
第三步,修改root密碼
mysqlupdateusersetpassword=password(root)whereuser="root";
QueryOK,4rowsaffected(0.00sec)
Rowsmatched:4Changed:4Warnings:0
第四步,重啟mysql或是重新整理MySQL的系統許可權相關表
透過命令列登入管理MySQL伺服器(提示輸入密碼時直接回車):
第一步,登陸mysql
[root@localhostbin]#/usr/local/webserver/mysql/bin/mysql-uroot-p-S/tmp/mysql.sock
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis1
Serverversion:5.5.3-m3-logSourcedistribution
Type"help;"or"\h"forhelp.Type"\c"toclearthecurrentinputstatement.
第二步,使用msyql資料庫mysqlusemysql
Readingtableinformationforcompletionoftableandcolumnnames
Youcanturnoffthisfeaturetogetaquickerstartupwith-A
Databasechanged
第三步,修改root密碼
mysqlupdateusersetpassword=password(root)whereuser="root";
QueryOK,4rowsaffected(0.00sec)
Rowsmatched:4Changed:4Warnings:0
第四步,重啟mysql或是重新整理MySQL的系統許可權相關表