WAMP phpMyAdmin won't open

Question

I just recently installed WampServer Version 2.5 on my Windows 7 64bit machine. When I attempt to open phpmyadmin I get this message in browser:

enter image description here

I checked in my config.inc.php file and everything seems alright. Here are contents:

 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Can anyone shed some light on this issue?? Many thanks, also I should point out the WAMP icon is orange which makes me think that perhaps a particular service might not be running.

Check if the port 3306 is used by another service or process — jcvegan, May 24 '14 at 15:02
Did you do all the grants for root? See if this helps you, http://stackoverflow.com/questions/11223235/mysql-root-access-from-all-hosts — johnny, May 24 '14 at 15:02
I just installed WAMP and tried to run it. Other than that I havent tweaked anything in the core folder. — Javacadabra, May 24 '14 at 15:04
You may find your answer here http://stackoverflow.com/questions/5993894/unable-to-access-phpmyadmin-after-a-password-is-set-to-the-database?rq=1 — Java Enthusiast, Jun 01 '14 at 18:17

Astro · Answer 1 · 2014-05-24T15:57:17.410

0

Restart all service in wamp or do this

Open command prompt > mysql dir of wamp like this c:\wamp\bin\mysql\mysql-version\bin\ Then we create a new password
Enter command mysqladmin -u root password NEWPASSWORD
Restart all services using wamp status icon

Hope this helps

Edit to add privileges mysql> GRANT ALL PRIVILEGES ON . TO root@localhost IDENTIFIED BY ' your current password ' WITH GRANT

edited May 24 '14 at 15:57

answered May 24 '14 at 15:07

Astro

13
1
1
4

I did as you suggested and got this message: `Access denier for user root@localhost (using password: NO)` – Javacadabra May 24 '14 at 15:11
I just installed the most uptodate version – Javacadabra May 24 '14 at 15:40
Check if that user has all privileges – Astro May 24 '14 at 15:48

Tiep Phan · Answer 2 · 2014-05-26T14:23:07.463

You can watch to solve your problem
http://www.youtube.com/watch?v=BgcW4h6ZAro&t=7m21s
p/s: this is Vietnamese video :)
in config.inc.php you edit folowing code:

* First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//uncomment this
$cfg['Servers'][$i]['auth_type'] = 'cookie';
//comment this
//$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

then exit wampserver, reopen wampserver, open PHPMyadmin, you'll show login form :)

score 0 · Answer 3 · answered May 26 '14 at 14:52

Please change auth_type .Use http then browse.when browse then wants user id and pass give right user id and pass:

 /* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
**$cfg['Servers'][$i]['auth_type'] = 'http';**
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

if not set admin password for mysql then see $ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use the following command:

$ mysqladmin -u root -p'oldpassword' password newpass

For example, If the old password is abc, you can set the new password to 123456, enter:

$ mysqladmin -u root -p'abc' password '123456'

WAMP phpMyAdmin won't open

3 Answers3