PHPMyAdmin MySQL Permission Issues Solved

Question

Hello,
I am using Mac OSX 10.3.9, Apache/2.0.52 (Unix) PHP/4.3.9 MYSQL 4.0.17.
Everything was fine with phpMyAdmin, then I followed an on-screen recommendation that it was safer to have a password for the root user. So I set a password for root@localhost. And now: phpMyAdmin refuses to connect to MySQL! The message is: phpMyAdmin attempted to connect to the MySQL server, and the server rejected the connection. Please check the values of "host", "username", and "password" in config.inc.php and make sure they match the information provided by the MySQL server administrator. I tried modifying config.php.ini by adding the password, but nothing works. And now MySQL won't start either! In the terminal: "can't connect to MySQL server through socket '/tmp/mysql.sock'.
If someone could tell me:
- how to fix my error
- how to restart MySQL
etc.

Thanks a lot.

Configuration: Mac OS X Firefox 2.0.0.11

Elendil · Accepted Answer

Hello,

I'm on Windows XP with the same problem on phpMyAdmin. After searching all afternoon and testing all the tips I found online, it still didn't work.
Fortunately, I just found the solution ^^
I just needed to clear the cache of Firefox* so that it would read the config.inc.php file again.

To know if you have the same problem as me, you just need to switch to private browsing on Firefox and launch phpMyAdmin. If it works, it means you have a cache problem.

*To clear the cache of Firefox 3.5/3.6:

Tools > Options > Advanced > Network tab > Offline Storage > Clear Now.

kylerpat · Answer

The modification to be made is in the file ..\phpmyadmin\config.inc.php. Depending on your version of phpmyadmin... In any case, the config.inc.php is at the root.

There:

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password'; // MySQL password (only needed
// with 'config' auth_type)

You will notice that if you disable the auth_type in the options, phpmyadmin will ask you for your user's password.

Good luck!!

zaldiar2 · Answer

Thank you very much for the help and encouragement, but unfortunately it's still not working. When I try to connect to phpMyAdmin as root, no password works. I have another username different from root, and when I try to connect with it, it just spins and then shows: ≠1045 - Access denied for user 'root@localhost' (using password: NO).
grrrr.

Alain_42 · Answer

You need to add:   $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'your_root_password';   in the config.inc.php around line 84.

didi65100 · Answer

Salut à tous, merci à Alain_42, tu m'as enlevé une épine du pied, ta manip a fonctionné pour moi, encore merci.

clemdevieilhe · Answer

Hello, a bit late, I tried to enter my activation key by connecting to the server in question and of course it doesn’t work like it does for other users. Is there a solution to this day? I have the 2009 version that was sold to me by FNAC in September! But why is this game still on sale after all these complaints?

kaoha · Answer

Hello everyone,
Despite all your good advice, I am still struggling. I am stuck with the error message "Error - MySQL responded: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)"
After making the suggested changes, here is my config.inc.php:

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root'; // mysqluser
$cfg['Servers'][$i]['password'] = 'password'; // mysqlpassword (only needed//with'config'auth_type)
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

Where is the error? Is it normal "['extension'] = 'mysqli';"? Because in the config.sample.inc.php, it says: "/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';"

Thank you very much for helping me out...

@+

francoise_peace · Answer

No, you need to clear the Offline Cache (Edit > Preferences > Advanced > Network), and also delete all cookies and history (Edit > Preferences > Privacy), finally, everything that clutters Firefox's (or the browser you are using) memory, and it works!

How to clear the cache
http://support.mozilla.com/en/kb/How%20to%20clear%20the%20cache?s=Offline+storage&as=s

Check for other browsers.

hmem17 · Answer

I installed easyphp 5.3.8.0 on Windows Vista and when I launch the phpMyAdmin page I get this message phpMyAdmin - Error The mysqli extension is missing. Please check your PHP configuration.

Please, how should I proceed???? Thank you

Alain_42 · Answer

You have just posted on a topic that is already marked as resolved.  Please rephrase your problem by creating a new one using the "Ask your question" link.

albator · Answer

Good evening, $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; change to $cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;

MichelK · Answer

Four months later, the solution is still working great!! Thank you!  Michel

cdmaximeorangefr · Answer

You just need to not put anything and hit enter each time.

cdmaximeorangefr · Answer

Could you tell me where to find config.php in localhost

whoever tells me will receive a reward!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

PHPMyAdmin MySQL Permission Issues

14 answers

Unrefreshed usb drive on android interface

Erreur de captcha

How to delete quarantine files in defender?

Issue with accents

Https://www.youtube.com/@topblazo

Unable to type the at-sign

Reinstallation of w11 impossible after pc crash...

Download impossible for visual petanque

Connect external dvd player to samsung tablet

Phone not receiving certain sms