After creating a mysql user with all privileges, the user cannot create databases in phpMyAdmin and only sees information_schema table
Posted
by
GHarping
on Server Fault
See other posts from Server Fault
or by GHarping
Published on 2012-10-24T10:47:28Z
Indexed on
2012/10/24
11:03 UTC
Read the original article
Hit count: 186
This is a recurring problem for some reason...
Using mysql 5.5, I am simply trying to create a user that can connect to the database remotely, have access to all databases, and create databases.
I have created a user using:
create user 'dev'@'%' identified by 'abcdefg';
then granted all permissions using:
GRANT ALL ON *.* to 'dev'@'192.168.%' IDENTIFIED BY 'abcdefg' WITH GRANT OPTION;
and the result is that the user cannot create databases, and can only see information_schema database for some reason.
Databases
Create database: Documentation
No Privileges
Database Ascending
information_schema
Total: 1
Does anyone know why this might be happening?
© Server Fault or respective owner
