PhpMyAdmin has no right to create a database, despite logging in as root

Question

I need to log in to MySQL using the root user and create a database. However, when I log in to PhpMyAdmin as root, it tells me that it has “no privileges”, so it cannot create a database.

I did not expect this to happen when I installed phpMyAdmin. Is there any way to fix this? Please help, thanks!

Version Information:

OS: OpenSUSE 12.1

MySQL: mysql Ver 14.14 Distrib 5.5.25, for Linux (x86_64) using readline 6.2

PhpMyAdmin: 3.4.10.2

Answer 1

This seems to be a temporary issue and subsequently fixed. Thanks for attention.

Answer 2

If you are using Chrome. try a different browser. where previous posts on this subject say that phpmyadmin didnot grant root privileges on chrome.

or try this

name: root

password: password

Answer 3

It worked for me

open config.inc.php file in phpmyadmin root, set auth type from cookie to config

$cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; // leave blank if no password 

Answer 4

Look at the user and host column of your permission. If you are using a local host or some other IP address, make a difference.

Answer 5

Use them:

• username: root
• password: (nothing)

Then you will get the desired page (more options than the admin page) with privileges.

Answer 6

Log in using the username and password for system maintenance created during the installation of phpMyAdmin.
It can be found in the debian.cnf file at / ect / mysql, then you will have full access.

 cd /etc/mysql sudo nano debian.cnf Just look - don't change anything! [mysql_upgrade] host = localhost user = debian-sys-maint <----use this user password = s0meRaND0mChar$s <----use this password socket = /var/run/mysqld/mysqld.sock 

Worked for me.

Answer 7

This worked for me (in Chrome):

Log in to phpmyadmin and follow "Home" -> "Privileges" -> "Reload the Privileges" . After that, clear your browser cache and try again.

Regards, Pedro Sauce

Answer 8

My problem was in my XWEB application, which I downloaded. I have a privilege error, but when I opened my config.inc.php and changed

 $cfg['Servers'][$i]['auth_type'] = 'cookie'; 

to

 $cfg['Servers'][$i]['auth_type'] = 'config'; 

This worked, and now I have privileges to create the database.

Answer 9

The ude method worked for me. Just change PW to something simpler after logging in.