Okay, first of all, I don't know how to use MySQL, but I got a guide, which says the following:
create database wikidb;
grant create, select, insert, update, delete, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';
flush privileges;
\q
so I changed it to:
create database wikidb;
grant create, select, insert, update, delete, lock tables on wikidb.* to 'looie'@'mysql5.freepgs.com' identified by 'xxxxxxxx';
flush privileges;
\q
but I get an error:
#1044 - Access denied for user 'looie'@'%' to database 'wikidb'
I only have 1 database, "looiedatabase" which is empty...
Anyone know the problem?
All of those commands are limited to superusers on MySQL.
To create a database, in the options panel, click "Manage Databases", then "Create New Database". You then set the username, password, and database. The privleges are all given to that user, for that database.
If you need a 2nd user/pass combo or differant permissions on your user account, then you need to submit a contact form request for those changes.
Ah, so I should've skipped that step. Got it now, thanks.