MYSQL and my domain name

[titanium]

Hi Guys, I hope someone can give me a suggestion here. I’m trying to get MRBS running (as well as more groupware) and I’m rtunning into a little issue when trying to assign user privilages to my db user when assigning it to the domain name ie the following bit.

“mysql> grant all on mrbs.* to [email protected]
identified by ‘mrbs-password'”

I get this error when I try it

‘ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘-too.co.nz identified by “abc123″‘ at line 1’

Now i know its related to the hypen in my domain name (goof-ball.co.nz, this is not the correct domain but you understand), so how can I get round this?, i really want to get this going.

[Dan Dickinson]

As I recall, the MySQL manual indicates that the username and host should both be escaped in single quotes. Try:

grant all on mrbs.* to ‘mrbs_usr’@’playground.plumblossom.org’
identified by ‘mrbs-password’

[titanium]

Thanks for the suggestion. It didnt work but it was worth a try. I got it going with another domain I have.

Another question for someone. How do you import the tables? I tried doing it following the INSTALL instructions but it didnt work, and this document doesnt really say how to do it.

[Author]

Posts