WampServer

Trying to use phpMyAdmin for the first time...got this message. Need help.
---
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.

Error

MySQL
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
---
Thank you

Check Setup Password guide on my personal website

Have fun,

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

I am having the same problem.

I have taken a look at yfastud's user guides but I can not get passed the first 5 steps because I can not access the phpMyAdmin.

I then skipped to step 6 and followed out all the instructions as shown below:

/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*/
$cfg['blowfish_secret'] = '123456';

/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
// $cfg['Servers'][0]. You can disable a server config entry by setting host
// to ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'qwerty'; // MySQL password (only needed


I have changed everything you have asked in your user guides but I STILL get the "#1045 - Access denied for user 'root'@'localhost' (using password: NO) "


PLEASE HELP ME

what the color of your wamp tray icon?

Have fun,

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

It is white like it says it should be


PLEASE HELP

u have qwerty filled in as password...

'root'@'localhost' (using password: NO) "


but it says ur not suppling a password?


explain how this is???

In the userguide it tells you to do a password doesnt it?


I just followed the userguide from step 6

I have taken the password out and removed the blowfish secret password aswell

Im still having the same problem

I have just reinstalled everything so I can start from scratch.



So far I can:

I can access my localhost when clicking on the icon

But I click the phpMyAdmin icon at still get " MySQL
#1045 - Access denied for user 'root'@'localhost' (using password: NO) "



Please help me and walk me through it step by step so I dont mess anything up.

Did you ever have mysql before?

Have fun,

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

Yes I had Mysql 5.0.

I uninstalled it after I installed Wampserver



Edited 1 time(s). Last edit at 04/01/2008 02:10PM by Catling.

well it aint unistalled properly. if u have a password in the box it shoud say USING PASSWORD :YES

even if the paswrd is wrong...

u need to unistall in all

I used the Add/Remove program option in windows to get rid of MySQL 5.0.

What do you suggest I do to get rid of everything?

check to see if u have a folder in c:/ called mysql or in c:/programs files/ called it

also if php is running.... check phpinfo.php page to see where ur mysql is running from

I did have a Mysql folder in C so I have deleted that.


I can't find this phpinfo.php page. Where would that be?

if u go to [localhost] does the default wamp page show up?


there show be a link to phpinfo()

im in phpinfo()

what do i need to look at?

there is a section for mysql


paste it up here

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off


mysqli
MysqlI Support enabled
Client API library version 5.0.45
Client API header version 5.0.45
MYSQLI_SOCKET /tmp/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off

hmmm its 5.045 .l.. .check the version ur wamp is running. is it the same .. click on wamp icon and mysql it will show u version on it