大家在公司工作中，经常会遇到mysql数据库存储于某个人的电脑上，大家要想连接mysql服务，装有mysql服务的电脑就必须开启远程连接。
第一种：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
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 ; |
第二种：
|
1
2
3
4
5
6
7
|
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 ; |
感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！
原文链接：http://blog.csdn.net/dweizhao/article/details/74852809
