I understand that the passwords are stored in the database in a user table. But when I first log into MySQL from the command line, I have not created a database at that stage, so what database am I actually logging into? All these help pages I've run across talk about logging into MySQL which makes it sound as though your logging in to the MySQL client itself but not actually logging into any specific database with that initial user and password.
One last question please.
I don't think understand the password section of the config.inc file as far as what I read in the phpmyadmin help section on passwords.
When I set my root password, It's my understanding that I had to also set it in the:
Config.inc.php file under the section titled: Authentication type and info.
But what is the function of setting the password in the config.inc.php file? If you've already set it using the command in the shell, what does the password in the config.inc.php really do?
Also, I thought the shell automatically updated the config.inc.php file if you use the security section? It did not for me.
I "did" set my root password, it works because I've tested logging in with the new password, but my config.inc.php section still has nothing between the two quotation marks in the code above: ' '
I know I can change this in notepad, but what is it doing that the shell command is not?
In a page I was reading, the author showed two different syntax commands to use, but never said why you have to use two, or what they are?
- Code: Select all
mysqladmin -u root password “newpassword”
mysqladmin -u root -h host_name password “newpassword”