改变mysql数据库用户的权限
mysql> grant all on *.* to test@'%';
Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) 查看用户的权限: mysql> show grants for test@'%'; +--------------------------------------------------------------------------------------------------------------+ | Grants for test@% | +--------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY PASSWORD '*2862D369024841A05C809285BEA487080138BDF2' | +--------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
联系方式QQ:326528263 EMAIL:clnking@163.com 网名:bass 分享技术 突破难点 创新思维