在目錄/etc/MySQL下找到my.cnf，用vim編輯，找到my.cnf里面的
#bind-address = 127.0.0.1將其只能本地ip訪問的代碼進(jìn)行注釋
然后用root登陸Mysql數(shù)據(jù)庫
im@58user:~$ mysql -u root -pEnter passWord: Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 6Server version: 5.5.53-0Ubuntu0.14.04.1 (Ubuntu)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>然后在執(zhí)行
mysql> grant all on *.* to root@'%' identified by '123';myslq> flush PRivileges;最后就可以在遠(yuǎn)程用剛才創(chuàng)建的用戶和密碼登陸mysql。
在執(zhí)行對用戶授權(quán)密碼的時候可能會遇到下面的錯誤：
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement解決方法：
先刷新一下權(quán)限表。 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> grant all on cactidb.* to dbuser@’localhost’ identified by ‘123’; Query OK, 0 rows affected (0.00 sec)
新聞熱點(diǎn)
疑難解答
