→在dos命令状态界面开启MySQL数据库远程访问权限 |
||
| 作者:qi0 | 回复/访问: 3/4182 | 发文时间:2022/9/28 0:18:58 |
| qi0 作者 2022/9/28 0:18:58 | 在dos命令状态界面开启MySQL数据库远程访问权限 1,在命令行状态下运行mysql并用root账号登陆,运行如下指令: mysql -h localhost -u root -p ![]() 2.查看数据库,查看是否允许远程访问 show databases; ![]() 切换到mysql数据库 use mysql; show tables; ![]() use mysql; select host,user,password from user; 3.开启外部访问权限 (1)grant all privileges on *.* to ‘username’@‘%’ identified by ‘password’ with grant option; ![]() flush privileges; ![]() |
| Alorbed 1楼 2023/4/27 16:52:03 | Only administer pharmaceutical grade products under the guidance of an experienced medical doctor <a href=http://sildenafil.buzz>will viagra make you last longer</a> |
| jenousa 2楼 2023/5/28 21:12:49 | google CIPN chemotherapy induced peripheral neuropathy <a href=https://cial.sbs>cheap generic cialis</a> |
| JosephBet 3楼 2025/12/26 14:36:39 | 出色的 旅行者门户网站, 加油 保持节奏。衷心感谢! <a href=https://iqvel.com/zh-Hans/a/E586B0E5B29B/E793A6E789B9E7BAB3E586B0E5B79DE59BBDE5AEB6E585ACE59BAD>冰川湖</a> 我常常想, 那么放松地度假。谢谢启发。 |