How do I edit the password for MYSQL using mysqladmin?
Posted: 12. March 2004 00:27
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 "config.inc.php" in \xampp\phpmyadmin an edit following
>lines:
>INSTEAD OF ...
>$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 config.inc.php).
Cheers,
Will
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 "config.inc.php" in \xampp\phpmyadmin an edit following
>lines:
>INSTEAD OF ...
>$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 config.inc.php).
Cheers,
Will