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

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

+11
source share
9 answers

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

0
source

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

+18
source

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 
+3
source

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.

+1
source

Use them:

  • username: root
  • password: (nothing)

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

+1
source

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.

+1
source

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

0
source

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.

0
source

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

0
source

All Articles