I
I
Islam Ibakaev2017-07-10 17:46:44
PHP
Islam Ibakaev, 2017-07-10 17:46:44

How to solve "No Privileges" when creating database in phpMyAdmin?

Installed lamp server on linux mint (32-bit). Installed phpMyAdmin, logged in, wanted to create a database, but I can't. Says there are no privileges.
43d423e7b32c474aaa055058c2bb9ffb.png
Help, PHP gurus, how to resolve this situation.
UPDATED:
SHOW GRANTS FOR CURRENT_USER;
issues

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION
GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION

Answer the question

In order to leave comments, you need to log in

1 answer(s)
4
4X_Pro, 2017-07-10
@devellopah

In Ubuntu, mysql is installed by default with a plugin that binds the MySQL root user to the system root user. Therefore, you need to do sudo mysql from the terminal, and then create another user with ALL PRIVILEGES.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question