MySQL Error occurred on installation

[Guest Cyberious]

I tried installing using the online installer, and got a MySQL error - access denied to database.

I tried manually installing it and found that one of the database tables doesn't exist and received an error when trying to add the content to the database, so I had to alter one of the lines to get it installed:

INSERT INTO latest_CubeCart_admin_users' .... >

instead of INSERT INTO 'CubeCart_admin_users'

because it looked like it was an error in the db.sql file...

But my real problem is that I can't access the site... I've installed / uploaded everything, and for some reason, can't access - I have the DB user name and password correct, but still is throwing an error back at me..

Anyone else have this problem?

------ EDIT -------

FIGURED IT OUT

The db.sql creates a db called `latest_CubeCart_admin_users`

I changed it by removing the `latest_

and everything worked out....

[Guest Cyberious]

Ok, actually, not everything is working...

seems the db.sql file has some tables created with `latest_

as the prefix.. When I got an error trying to log into the Admin, I saw that it was trying to access a table without this prefix, and after removing that, was able to log in....

so the sql tables are a bit messed up...

[Guest]

yeah, my first time installing v3, and i already came to a problem. wonderful!

So how do we fix this?

[Guest Cyberious]

I opened up db.sql and removed all the references to latest_

so everywhere there was a reference creating a table that started with that prefix, I just removed that prefix and it worked.

I attached mine for you to use if you want...

good luck! if you need any more help let me know and I'll see if I can help.

ALSO: Don't forget, if you want to use a prefix, and you're installing manually (I couldn't get the web installer to work) you'll have to add the prefix to all the lines in your db.sql file

db.sql