Mysql – After creating a thesql user with all privileges, the user cannot create databases in phpMyAdmin and only sees information_schema table

MySQLmysql5.5networking

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?

Best Answer

I think the problem might be that you're using phpmyadmin from an address that doesn't match 192.168.% ? Maybe you're connecting locally and using localhost to connect.

You can verify this by setting different passwords for 'dev'@'%' and 'dev'@'192.168.%' and see which one works through phpmyadmin.

Make sure that the user you're connecting with Combined with the correct host has the needed privileges.

Related Topic