WampServer

just installed wampserver 2 and want to know where to change the root password

If you have never set a password for root, the server does not require a password at all for connecting as root. To setup root password for first time, use command at shell prompt as follows:

mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

mysqladmin -u root -p oldpassword newpass

Enter password:




Change MySQL password for other user

To change a normal user password you need to type (let us assume you would like to change password for test):

mysqladmin -u test -p oldpassword newpass

However, if using mysql consol through wamp tray icon, then the command to change password for root is

mysql> SET PASSWORD FOR ‘root’@'localhost’=PASSWORD(’new_password’);

Have fun,

if using command prompt only, you might not able to use phpmyadmin; check my guide here for idea

[blog.jlbn.net]

Have fun,

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

Thanks a lot

now i am facing a new problem:

when i type in command prompt

mysql> \r

it says

Current database: ****none****

PLZ hepl me vth this ..do ineed to create a DB then please tell me the procedure to do this...

I changed my root@localhost password, but now I get the following when I open phpMyAdmin:

Error
MySQL said:

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

How do I change the configuration to accept my new password?

Dster

Note: when I access mysql via the MySql console, the new password is accepted and I get a mysql> prompt.

Only phpMy Admin fails.

Dster

you should check my guide here for idea

[blog.jlbn.net]

Have fun,

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

Okay, I decided to uninstall WAMP and start over. Unfortunately, after a successful uninstall/reinstall, when I attempt to access phpMyAdmin, I still get the same error:

Error
MySQL said:

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


When I access the mysql console, I get a mysql> prompt without entering a password.

What in the heck has happened to phpMyAdmin, and how do I fix it?

Dster

I fixed the phpMyAdmin problem by deleting my browser's cache. It now works fine.

Dster

mindsec, follow my guide here

[blog.jlbn.net]

Have fun,

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

If after changing the root password you will not be able to access phpmyadmin. To solve this open: /wamp/apps/phpmyadmin3.5.1/config.inc.php

Here you will find: $cfg['Servers'][$i]['password'] = ''; where you can add your new password.




@yfastud - could you get any more advertisements on this guide?

If after changing the root password you will not be able to access phpmyadmin. To solve this open: /wamp/apps/phpmyadmin3.5.1/config.inc.php

Here you will find: $cfg['Servers'][$i]['password'] = ''; where you can add your new password.




@yfastud - could you get any more advertisements on this guide?

do you want him to try?!

shhhh

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