MYSQL开启远程访问权限的方法

1

2

3

4


# 按esc后，输入 :set number 即可显示行号


#按 i 可编辑


#找到bind-address =127.0.0.1注释


# 编辑完成后按 esc，然后输入 :wq ,即可保存退出

1

2


mysql -uroot -p


#输入数据库root账号的密码

1

2


# 展示mysql库中的所有表，user表在最后一个


show tables;

1


select
host,
user
from
user
;

1


update
user
set
host=
"%"
where
user
=
"root"
;

1

2


mysql -h 数据库远程地址 -uroot -p


# 输入远程数据库的root密码

1


mysql -uroot -p# root 密码

1


use mysql;

1


select
host,
user
from
user
;

1


update
user
set
host=
"%"
where
user
=
"root"
;

1


select
host,
name
from
user
;

1


mysql -h 数据库地址 -uroot -p# 密码

1

2

3

4

5

6

7

8

9

10


mysql> use mysql;


Database changed


mysql> select host,user,password from user;


+--------------+------+-------------------------------------------+


| host     | user | password                 |


+--------------+------+-------------------------------------------+


| localhost  | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |


| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |


+--------------+------+-------------------------------------------+


2 rows in set (0.00 sec)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17


mysql> use mysql;


Database changed


mysql> grant all privileges on *.* to root@'%' identified by "password";


Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;


Query OK, 0 rows affected (0.00 sec)


mysql> select host,user,password from user;


+--------------+------+-------------------------------------------+


| host     | user | password                 |


+--------------+------+-------------------------------------------+


| localhost  | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |


| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |


| %      | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |


+--------------+------+-------------------------------------------+


3 rows in set (0.00 sec)

1

2

3


use mysql;


update
user
set
host =
'%'
where
user
=
'root'
;