How do I edit the password for MYSQL using mysqladmin?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How do I edit the password for MYSQL using mysqladmin?

Postby Will » 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
Will
 
Posts: 1
Joined: 12. March 2004 00:18

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 200 guests