Page 1 of 1

MySQL root@localhost password

PostPosted: 23. December 2006 17:00
by 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?

Similar question - mysql root passwd change

PostPosted: 03. January 2007 16:08
by 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.

PostPosted: 03. January 2007 16:24
by 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.

/opt/lampp/lampp security

PostPosted: 05. January 2007 22:14
by 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