当前位置：网站首页>Let others connect to their own MySQL database and share the MySQL database

Let others connect to their own MySQL database and share the MySQL database

2022-04-22 03:15:00 【Happy border town】

First connect to... Through a terminal mysql

mysql -u root -p

Select database to use

use mysql;

Modify the required for the connection host For any

// The format is update user set host="%" where user=' user name ';
update user set host="%" where user='root';

Finally, remember to refresh

flush privileges;

Insert picture description here

Create user
The format is : create user’ user name ’@‘ Connected hosts ’ indentified by ‘ password ’;

create user'test1'@'%' identified by '123456';

to grant authorization
Grant operation permission to all tables of a database test1 user

grant all on  Database name .* to 'test1'@'%';
// Refresh 
flush privileges;

Insert picture description here

版权声明
本文为[Happy border town]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204211350243439.html