quick mysql question (using hostnames)
When setting up mysql, I can do this:
# mysqladmin -u root password '******'
But when I try to use a hostname in there, I get this:
# mysqladmin -u root -h example.host password '*****' mysqladmin: connect to server at 'example.host' failed error: 'Host 'example.host' is not allowed to connect to this MySQL server'
How might I get around this?
# mysqladmin -u root -h "example.host" password 'new-password'
If you do not specify the -h option, then the password is set globally for the root account.
It appears that mysql isn't running. The database server needs to be running in order to update a database.
The thing is that the database server is running when I issue this command.