[rt-users] SQL syntax error when creating database

Raymond Norton admin at lctn.org
Fri Sep 9 11:28:29 EDT 2011


I am getting the following error when attempting to create the database:



sudo /usr/sbin/rt-setup-database --action init --dba root 
--prompt-for-dba-password
In order to create or update your RT database, this script needs to 
connect to your  mysql instance on localhost as root
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
Working with:
Type:   mysql
Host:   localhost
Name:
User:   rtuser
DBA:    root
Now creating a mysql database  for RT.
Couldn't finish 'create' step.

ERROR: 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 '' at line 1




More information about the rt-users mailing list