Page 1 of 1

How do I edit the password for MYSQL using mysqladmin?

PostPosted: 12. March 2004 00:27
by Will
This is very basic stuff I know but please help!

I want to change the password for MY SQL and php.

I read on the xampp website that I need to do the following:

>In the \xampp\mysql\bin directory enter into the console:
>mysqladmin -u root password secret
>Ok, "secret" should be your secret password.
>Then update the password for PHPMyAdmin.
>Open the "" in \xampp\phpmyadmin an edit following
>$cfg['Servers'][$i]['user'] = 'root';
>$cfg['Servers'][$i]['password'] = '';
>NOW ...
>$cfg['Servers'][$i]['user'] = 'root';
>$cfg['Servers'][$i]['password'] = 'secret';

Please can you explain what I have to do.

If I try and run mysqladmin.exe from \xampp\mysql\bin directory by clicking on it I see a black console screen for a split second then it disappears.

How do I get to edit the password for MYSQL?

I can work out the php bit (edit