Re: [cobalt-users] MySQL host?

["Fathi Said" <fathi@xxxxxx>]

Hey Hans,

> GRANT ALL PRIVILEGES ON database.* TO user@xxxxxxxxxxxxxx IDENTIFIED BY
> 'password' WITH GRANT OPTION;
> But this does not work. I cannot connect to the database with the
domainname
> "userdomain.com". Does anyone know how to configure the database correct?

first do a:

GRANT ALL PRIVILEGES ON database.* TO anyuser@localhost IDENTIFIED BY
'yourpassword' WITH GRANT OPTION; FLUSH PRIVILEGES;

then do a:

GRANT ALL PRIVILEGES ON database.* TO anyuser@"%" IDENTIFIED BY
'yourpassword' WITH GRANT OPTION; FLUSH PRIVILEGES;

then create the user:

mysqladmin -uanyuser -p password yourpassword

(please note that "anyuser" stands for a username, and "yourpassword" stands
for any password. You can chose both variables. Leave the others as they
are).

-f