mysql客户端(Navicat)远程登录操作再遇问题1142-create command_MySQL
- WBOYOriginal
- 2016-06-01 13:42:411813browse
Navicat
bitsCN.commysql客户端(Navicat)远程登录操作再遇问题1142-create command denied to user×××的解决
给用户添加CREATE,DROP权限。 Mysql命令：[sql]mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON systest.* TO root@'%' identified by 'root'; Query OK, 0 rows affected (0.01 sec)
然后再在navicat中操作，问题解决啦。 摘自 邢明权博客 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：获取表结构中注释信息的语句_MySQLNext article：Linux下MySQL编码的修改_MySQL