同时在windows和mac os上安装了mysql,Windows版没有任何问题, 可mac版本总不能建立新的用户和数据库,系统提示:Access denied; you need (at least one of) the CREATE USER priviledge(s) for this operation
Access denied for user ''@'Localhost' to database 'mydb'
google了很久还是解决不了, 求帮助!
...全文
1977打赏收藏
mysql 安装问题
同时在windows和mac os上安装了mysql,Windows版没有任何问题, 可mac版本总不能建立新的用户和数据库,系统提示:Access denied; you need (at least one of) the CREATE USER priviledge(s) for this operation Access denied for user ''@'Localhost' to database 'mydb' google了很久还是解决不了, 求帮助!
貌似我好像没有任何权限,数据库只有以下这两个:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.01 sec)
查看权限:
mysql> show grants;
+--------------------------------------+
| Grants for @localhost |
+--------------------------------------+
| GRANT USAGE ON *.* TO ''@'localhost' |
+--------------------------------------+
继续救助!