Mysql初始化root密碼和允許遠(yuǎn)程訪問(wèn)
mysql默認(rèn)root用戶沒(méi)有密碼，輸入mysql –u root 進(jìn)入mysql
1、初始化root密碼
進(jìn)入mysql數(shù)據(jù)庫(kù)
1mysql>update?user?set?password=PASSWORD(‘123456’)where?User='root';
2、允許mysql遠(yuǎn)程訪問(wèn),可以使用以下三種方式:
a、改表。
1
2
3
4mysql
-u root –pmysql>use
mysql;mysql>update?user?set?host
= '%'?where?user?='root';mysql>select?host,user?from?user;
b、授權(quán)。
例如，你想root使用123456從任何主機(jī)連接到mysql服務(wù)器。
1mysql>GRANT?ALL?PRIVILEGES?ON?*.*TO?'root'@'%'?IDENTIFIEDBY?'123456'?WITH?GRANT?OPTION;
如果你想允許用戶jack從ip為10.10.50.127的主機(jī)連接到mysql服務(wù)器，并使用654321作為密碼
1
2mysql>GRANT?ALL?PRIVILEGES?ON?*.*TO?'jack'@’10.10.50.127’
IDENTIFIED BY?'654321'?WITH?GRANT?OPTION;mysql>FLUSH
RIVILEGES
c:在安裝mysql的機(jī)器上運(yùn)行：
1
2
3
4
5
6
7
8//進(jìn)入MySQL服務(wù)器d:mysqlbin>mysql
-h localhost -u root//賦予任何主機(jī)訪問(wèn)數(shù)據(jù)的權(quán)限mysql>GRANT?ALL?PRIVILEGES?ON?*.*TO?'root'@'%'?WITH?GRANT?OPTION//使修改生效mysql>FLUSHPRIVILEGES//退出MySQL服務(wù)器mysql>EXIT
下載文檔
