WampServer

hi frenz i have just installed wamp server 2.0i all wprked fine except phpmyadmin it gives the folloeing error message when i clicked on "phpmyadmin link given on wamp server homepage

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

how can i solve to run phpmyadmin

plz help

Aman

Did you try an add a password to mysql?



if so.. open c:/wamp/apps/phpmyadmin/config.inc

add your password to the row

$cfg[server][password]='';




if you didnt try add a password

then is the wamp icon half yellow and white?

this means you have another copy of mysql running on the pc

Remove it

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

thanks Steven for your valuable comments

i have solved the problem by editing "config.inc.php" file .i added password ROOT against username ROOT.
this solved the problem.

i had the same problem but when i added a password i got another error


MySQL sa:

#2000 - mysqlnd cannot connect to MySQL 4.1+ using old authentication

how do i fix this ?

Please stay in your opened topic to avoid double answers... Thanks you.

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

which version of wamp server and post your config files content

the newest version!


<?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';
$cfg['Servers'][$i]['password'] = 'ascent';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

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

?>

I also had this problem. I did try to add a password. I changed it in the config file and it still won't connect.
I also am using the newest version of wamp

<?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';
$cfg['Servers'][$i]['password'] = 'wampserver4';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

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

?>


Is there somewhere else it needs to be changed as well? Thanks for any help.

yes in mysql first....


add me to msn if your stuck now

stevenmartin99@hotmail.com

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Sorry, I don't have MSN. I don't get online much. My computer fried and this is someone else's so I don't have much time with it, otherwise I might be able to figure it out. Can you tell me where in MYSql it needs to be changed since I've already changed it in phpadmin config.inc? Thanks again

CHENAGE IT BACK IN config


open phpmyadmin in browser


privledges> user " root localhost" press the hand


down a bit> password - add one


then add it to the config file

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hi there, I have the same problem. I added a password in the config file, but still I can't connect. Do I make changes in MySQL, please help?

u make them before u change it in config.


open phpmyadmin and add a password

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides