Mysql 遠程連接配置實現的兩種方法
大家在公司工作中，經常會遇到mysql數據庫存儲于某個人的電腦上，大家要想連接mysql服務，裝有mysql服務的電腦就必須開啟遠程連接。
第一種：
| root@ubuntu:/usr/local/MySQL# mysql -hlocalhost -uroot -proot;mysql>use mysql;mysql>insert into user ( host, user, password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv)VALUES ('%', //固定IP則替換%'cap',password('cap'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');mysql> FLUSH PRIVILEGES ; |
第二種：
| root@ubuntu:/usr/local/mysql# mysql -hlocalhost -uroot -proot;mysql>GRANT ALL PRIVILEGES ON *.* TO 'test'@'%'IDENTIFIED BY 'test' WITH GRANT OPTION; //固定IP則替換%mysql> FLUSH PRIVILEGES ; |
感謝閱讀，希望能幫助到大家，謝謝大家對本站的支持！
新聞熱點
疑難解答
