WampServer

Hi, Im trying to use the mysql console, but every time i open it, i am asked for a password, presumably this is the root password, but I can't figure out what that password is. Whatever I try, the console just exit's straight away.

Does anybody know where this is changed?

Help.

Dave.



<img src="[82.47.15.246]; alt="car" width="99" height="80" />

try going to the phpmyadmin folder and edit the config.inc file located at
wamp\phpmyadmin\config.inc.

now be carefull with this file since it is your mysql console config file. Find password and once you have located it in the config file look and see if it has a set password. if not you might try to place one in there.

dont know if that is much help but give it a shot.

EW

when the passwod is asked, just type on 'enter'.



Romain

Like Romain said, just hit the enter key.

I had that problem and was going nuts trying to figure it out. I actually found the answer by mistake. I had opened the console and went to enter my password, but hit the enter key by mistake and it opened up.

Go figure.

> try going to the phpmyadmin folder and edit the config.inc file located at
> wamp\phpmyadmin\config.inc.

> now be carefull with this file since it is your mysql console config file.
> Find password and once you have located it in the config file look and
> see if it has a set password. if not you might try to place one in there.

> dont know if that is much help but give it a shot.

> EW

----------------------------

your phpmyadmin config file only configures phpmyadmin, not mysql. it has nothing to do with any kind of configuration of mysql. it just configures the phpmyadmin script to work with with your mysql server. also there is no such thing as a mysql console config file.

Well......

I tried just hitting the enter key, and that just closes the console straight away.

So I tried editing the phpmyadmin config file. I did this..... and entered no password....

So presumably I should be able to just press enter and enter the console, no luck...

$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)

Any more ideas? or should I just start using phpmyadmin?

Dave.



<img src="[82.47.15.246]; alt="car" width="99" height="80" />

read my previous post. your phpmyadmin config file has absolutely nothing to do with any kind of configuration of mysql. it just is the config file to setup phpmyadmin to work on your server, nothing more, nothing less.