quick mysql question (using hostnames)

It appears that mysql isn't running. The database server needs to be running in order to update a database.

… or the "mysql" database has to be updated giving the user "root" access from the host "example.host". Either do this with "GRANT" after you logged in the mysql client or use "mysqladmin":

# 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.

@jax:

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.

Sorry, read the first post wrong (I seem to do that frequently). If you take a look at the users table in the mysql database, you can specify different permissions to each user based on what host they logged in from. By default, root only has access to login from localhost. So, in order to specify anything else with -h, you first need to grant that access. Either manually insert a row into the table and flush the privileges, or refer to the mysql documentation to learn about GRANT.

http://dev.mysql.com/doc/mysql/en/Secure_GRANT.html

has any of you read my reply above? :roll: