你可以看下用户是否存在,如果没有存在。重新刷新一下权限,如果还是报错。
使用drop user,然后再重新执行创建语句。
MySQL创建用户出错,且无法删除的解决办法
不能这样简单的插入数据库创建用户,因为'ssl_cipher'字段不能为空,必需指定数值,应该使用GRANT命令创建用户,格式:
13.5.1.3. GRANT和REVOKE语法
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON [object_type] {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher' [AND]]
[ISSUER 'issuer' [AND]]
[SUBJECT 'subject']]
[WITH with_option [with_option] ...]
object_type =
TABLE
| FUNCTION
| PROCEDURE
with_option =
GRANT OPTION
| MAX_QUERIES_PER_HOUR count
| MAX_UPDATES_PER_HOUR count
| MAX_CONNECTIONS_PER_HOUR count
| MAX_USER_CONNECTIONS count
REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON [object_type] {tbl_name | * | *.* | db_name.*}
FROM user [, user] ...
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...
GRANT和REVOKE语句允许系统管理员创建MySQL用户 账户,授予权限和撤销权限。
linux中mysql创建不了用户没权限怎么解决你先执行下 ps -ef|grep mysqld 看看mysqld进程是否存在,如果不存在,那么就是mysql服务没有起来
如果mysqld进程在了,你就看看/var/lib/mysql/mysql.sock是否存在
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)