WampServer

When I go to MYSQLConsole it says enter password. I don't enter anything, just hit ENTER key and am in. However, I get the error whenever I open phpMyAdmin.

I have checked the config.inc.php and the user='root' and the password = ''.

WHAT IS WRONG HERE???????

Check Setup Password guide on my website

Have fun,

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

haha thats a new one. ur console will sign in but ur phpmyadmin wont evene those it has the same settings,

unless ur console is using % as user

and you set a password for root

unlikey tho

wat colour is ur wamp icon all white or some yellow?
just paste 10 lines before and 10 lines after of ur config.inc file before i show u another way of doing it

There is yellow in my icon.

yfastud - I followed your guide and it is of no help.

This problem happened after I installed the mySQL Query Browser GUI tools. I since uninstalled them. I'm a noob so is there a way to reset my password to 'blank' so I know it is nothing?

stevenmartin99 - what do you mean paste 10 lines before and after? 10 blank lines? Whats the point of that?

no paste your config.inc.php file up here. if ur icon is yellow then the msql service is not working.


paste up a few lines before and after where it says username and password in it


and also post up ur

msql.log file located at c:/wamp/log



Edited 1 time(s). Last edit at 02/21/2008 08:37PM by stevenmartin99.

here is from the config.inc.php file:

/**
* 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'] = '';

/**
* 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'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed in left frame
// It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname

HERE IS EVERYTHING THAT WAS IN THE LOG FILE:

080221 13:25:22 InnoDB: Started; log sequence number 0 77953
080221 13:25:23 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 13:37:25 [Note] wampmysqld: Normal shutdown

080221 13:37:25 InnoDB: Starting shutdown...
080221 13:37:28 InnoDB: Shutdown completed; log sequence number 0 77963
080221 13:37:28 [Note] wampmysqld: Shutdown complete

080221 13:37:37 InnoDB: Started; log sequence number 0 77963
080221 13:37:37 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 13:39:07 [Note] wampmysqld: Normal shutdown

080221 13:39:08 InnoDB: Starting shutdown...
080221 13:39:13 InnoDB: Shutdown completed; log sequence number 0 77973
080221 13:39:13 [Note] wampmysqld: Shutdown complete

080221 13:39:20 InnoDB: Started; log sequence number 0 77973
080221 13:39:21 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 13:42:44 [Note] wampmysqld: Normal shutdown

080221 13:42:46 [Warning] wampmysqld: Forcing close of thread 1 user: 'root'

080221 13:42:46 InnoDB: Starting shutdown...
080221 13:42:50 InnoDB: Shutdown completed; log sequence number 0 77983
080221 13:42:50 [Note] wampmysqld: Shutdown complete

080221 13:43:04 InnoDB: Started; log sequence number 0 77983
080221 13:43:04 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 13:44:40 [Note] wampmysqld: Normal shutdown

080221 13:44:40 InnoDB: Starting shutdown...
080221 13:44:43 InnoDB: Shutdown completed; log sequence number 0 77983
080221 13:44:43 [Note] wampmysqld: Shutdown complete

080221 13:44:53 InnoDB: Started; log sequence number 0 77983
080221 13:44:53 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 14:04:43 [Note] wampmysqld: Normal shutdown

080221 14:04:45 [Warning] wampmysqld: Forcing close of thread 2 user: 'root'

080221 14:04:45 InnoDB: Starting shutdown...
080221 14:04:49 InnoDB: Shutdown completed; log sequence number 0 77983
080221 14:04:49 [Note] wampmysqld: Shutdown complete

080221 14:04:55 InnoDB: Started; log sequence number 0 77983
080221 14:04:55 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 14:06:17 [Note] wampmysqld: Normal shutdown

080221 14:06:17 InnoDB: Starting shutdown...
080221 14:06:23 InnoDB: Shutdown completed; log sequence number 0 77983
080221 14:06:23 [Note] wampmysqld: Shutdown complete

080221 14:07:20 InnoDB: Started; log sequence number 0 77983
080221 14:07:20 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 14:07:51 [Note] wampmysqld: Normal shutdown

080221 14:07:51 InnoDB: Starting shutdown...
080221 14:07:58 InnoDB: Shutdown completed; log sequence number 0 77983
080221 14:07:58 [Note] wampmysqld: Shutdown complete

080221 14:10:38 InnoDB: Started; log sequence number 0 77983
080221 14:10:39 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080221 14:25:05 [Note] wampmysqld: Normal shutdown

080221 14:25:07 [Warning] wampmysqld: Forcing close of thread 1 user: 'root'

080221 14:25:07 InnoDB: Starting shutdown...
080221 14:25:13 InnoDB: Shutdown completed; log sequence number 0 77983
080221 14:25:13 [Note] wampmysqld: Shutdown complete

080221 14:37:04 InnoDB: Started; log sequence number 0 77983
080221 14:37:04 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

Also, my icon is all white now... I can go to mysqlconsole and hit enter and i'm in... i go to phpmyadmin and get the access denied error still.

Thanks for the assistance.

well it looks like mysql is running. so thats strange how it is yellow.. and apache has to be running if u got a php page to run,,



so try delete root from the user. and try it as no user...

so it is white

chanhe ur config.inc file with no password r user

I chagned it so there is no user now... removed root from user='root'....

Icon is white... however I go to start phpmyadmin and still get the error. WTF! ????

clear ur web browser cache!!!!!!!!

did u do it at all yet?!

then if u get an error repost it

well since I removed 'root' and it is now blank in the config.inc.php I clear the browser cache and get this error:

MySQL said:

#1045 - Access denied for user 'ODBC'@'localhost' (using password: NO)



Now it says ODBC instead of root.....


this sux!

thats fine
now fill back in root and ur in


clear the cache again if it says odbc



Edited 1 time(s). Last edit at 02/21/2008 09:01PM by stevenmartin99.

yes now I am in... thanks!