WampServer

I installed WAMP but ia have problem to use mysql what is mysql password ??? how i can change it .. ??

mysql password? maybe you are refering to mysql root user's password? u can set this in the mysql console and executing the command(as taken from the mysql manual):

c:\> mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;

سلام كسي اينجا فارسي ياد نداره ؟؟؟؟؟؟؟؟
that guide is not true at WAMP I must use the icon program ...

Awesome!

You saved me!

sirquits wrote:

> mysql password? maybe you are refering to mysql root user's
> password? u can set this in the mysql console and executing the
> command(as taken from the mysql manual):
>
> c:\> mysql -u root
> mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
> -> WHERE User='root';
> mysql> FLUSH PRIVILEGES;

Awesome!

You saved me!

but how do we get our username i only got password by this code?

jp wrote:

> but how do we get our username i only got password by this
> code?
>

Well, the point here is to change the password for the root, who is the administrator. Then using PhpMyAdmin interface you can go to Privileges and create more users there. There sure must be a way to do it through the command line but why bother?

Another thing, when you've changed the password for root you should open config.inc.php in PhpMyAdmin folder and change $cfg['Servers'][$i]['password'] value to your new password - $cfg['Servers'][$i]['password'] = 'YourNewPasswordHere';

That one is located on line 73.

If you don't have a config.inc.php that means you just unpacked PhpMyAdmin. In this case locate config.default.php in the PhpMyAdmin folder make a copy of it in the same folder and rename the copy to config.inc.php then edit it as mentioned.

As I understand the command line feature to change password works very well in case you forgot your password or if one of the users forgot theirs. In that case Administrator has the ability to reset it to new one.
I hope that helps

That **** does not work!

Exelente, si funciona.
Muchisimas gracias

Thanks

Hey Futureman, which **** does not work! Check my old post here

[forum.wampserver.com]