MySQL root@localhost password

[theillien]

I'm trying to set the password for 'root'@'localhost'. I execute the query successfully but when I try to go back to the phpMyAdmin homepage I get "Cannot connect: invalid setting"

The only way to fix it is to log into MySQL via the command line and remove the password.

Why is this happening? Why can't I set the password? When I am able to open the homepage it says User: root@localhost. If I'm accessing the page as root@localhost, shouldn't it be asking me for my password or something?

[csinclair]

I as well was wondering where the English documentation was for security settings after install, how do I change mysql's root user password, and disable the blank password user accounts as well.
I'm using Slackware 11.0 and aside from those major security concerns, all went well with the install.

[theillien]

If I recall correctly, simply running /opt/lampp/lampp security will put you throught the lockdown script. However, there are only a few steps such as requiring a username/password just to access the folder/site, an FTP password, and I think one other. But it wasn't a MySQL password, that's for certain.

[csinclair]

Yes,
You are right, running /opt/lampp/lampp security while xampp is running is required, I did it the first time while xampp was not running and it didn't work properly.

Thanks,
Craig