Mysql password


#1

[quote]The entry we care about is the second one: asterisk1.local for root user access.

If your password field is blank, you’ve got a serious security problem. What this entry means in layman’s terms is anyone on the Internet can connect to your MySQL databases as root with no password.

Click on the pencil beside the second record (asterisk1.local - root).
When the record displays, click on the function pulldown in the password row and choose PASSWORD.
Then make up a password that’s secure and enter it in the password value field. Click Go to save your update.
Now click the Browse tab again and be sure an encrypted password is shown for both root user entries in the table. We don’t care about the blank password for the blank user because you’ll note that all the database privileges are set to N for this account.

You are not yet complete…. myphpadmin will no longer work. To repair this simply go to /var/www/html/maint/phpMyAdmin and edit the file config.default.php.

Look for :

$cfgServers>‘Servers’$ipassword>‘password’ = ‘passw0rd’; // MySQL password (only needed

Change this to match what was done above, reboot and all is right in the world again… [/quote]

I’ve tried to follow the instructions above for a@h but this doesn’t jive with what phpmyadmin shows. asterisk1.local is not the second entry and it does not have a username or a password. I think it means to make sure localhost - root has a password correct? …and then to change it in config.default.php.