Guest Posted May 6, 2007 Share Posted May 6, 2007 hey all. i cant work out step 2 of the install. importing the database. i did it through my web hosting and have just called it database (couldnt think of anything else at the time??) my account was set up and rgolding is the admin for the site. i know the password is right but when i enter the below info Database Server: localhost Username: rgolding Password: ****** Database Name: database i get this 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 'database' at line 1 can somoene please help? i know its probably a very stupid question but im a newbie so go easy thanks in advance for your help. Rob Link to comment Share on other sites More sharing options...
Jan Zonjee Posted May 6, 2007 Share Posted May 6, 2007 Database Name: databasei get this 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 'database' at line 1 You can't use certain words for columns, tables, or databases. Database is one of those reserved words. Link to comment Share on other sites More sharing options...
Guest Posted May 6, 2007 Share Posted May 6, 2007 You can't use certain words for columns, tables, or databases. Database is one of those reserved words. i knew itd be something simple like that. ive changed the name to rgshop but now i get this error Access denied for user 'rgolding'@'localhost' to database 'rgshop' ive checked and rgolding is definatly the user and the password is right. what am i doing wrong now? Link to comment Share on other sites More sharing options...
Jan Zonjee Posted May 6, 2007 Share Posted May 6, 2007 what am i doing wrong now? Probably the install panel of your hosting provider also adds you as the user of a particular database and insert in the table for users (and rights to certain actions on the database) your username and password but also the particular database you created through the install panel. If you then change the name of the database, that change is not reflected in the table that keeps track of users and passwords (I guess that is what's happening). Probably you can go around it by dropping the database completely, making a new one and install osC again. Link to comment Share on other sites More sharing options...
♥Vger Posted May 6, 2007 Share Posted May 6, 2007 Depending on your operating system it can also be that the database name is wrong e.g. you set up a database called test but its full name is yourdomain_com_-_test This is usually the case if your site is hosted on Red Hat Enterprise Linux servers. Vger Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.