Wednesday 27 February 2008 10:37:18 am

Hey!

Thanks for your answer. No, I didn't try it. Honestly, I don't know much about databases. I hoped I could install eZPublish without having to work my way through a book on mySQL.

Anyway, I tried after your suggestion, but I still don't succeed.

I try to ruyn your command as an SQL-query on phpMyAdmin, but I get an syntax error. I tried checking the command in the MySQL documentation, but as far as I can see, the syntax ought to be OK.

Again, I don't have this on a computer I can access freely. It's all on a host I pay for, so I can't tweak things.

Would you mind helping me furhter? I list the error-message from phpMyAdmin, everything is the same, apart from the password:

SQL query: 

GRANT CREATE , DROP , ALTER , INDEX , DELETE , INSERT , SELECT ,
UPDATE , CREATE TEMPORARY TABLES , LOCK TABLES ON mplusplus - nl . *
TO 'mplusplus_nl'@'mysql6.hostingdiscounter.nl'
IDENTIFIED BY '########';

MySQL said: Documentation
#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 '-nl.*
   TO 'mplusplus_nl'@'mysql6.hostingdiscounter.nl'
   I

This suggest to me that the name of the database is illegal, but that sure can't be right?

Thanks in advance for help,

Maarten

Wednesday 27 February 2008 1:35:26 pm

Thanks for clearing that out to me... That MySQL book might come one day,... I like more to learn by doing.

Is it correct that I enter these commands as an SQL query? That's what I'm trying to do and where I'm getting these error-messages.

I wonder if the cause could be the NAME of the database: it's supposed to be mplusplus-nl but the 'syntax error'-message point the name out as the cause. When I remove the dash "-", it doesn't throw this syntax-error message anymore. (Although it ofcourse DOES complain that the database doesn't exist)

Further, I found this on the internet, suggesting that the "-" is a illigal name in a table,...

<i>
Identifier characters - can be any alphanumeric character (as long as it’s in the default character set) plus ‘_’ and ‘$’. They can also start with any legal character (legal to be included in the identifier), even a digit. Identifiers can be quoted within ‘`’ (backtick or `), which allows the use of any character except the backtick .
</i>
http://www.idig.za.net/mysql-naming-rules/2006/11/17/

If this is the problem indeed, how come Ez came so far as actually creating tables in the database...?

Eh, * confused *,... :(

Thanks so far for your help, both!

Maarten