News:

Click here for Toll-Free Service for your business starting at $2.00 per month

Main Menu

MediaWiki MySQL problem

Started by looie, May 08, 2007, 11:23:01 PM

Previous topic - Next topic

looie

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?

Ben

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.
--Ben
Ben@freepgs.com

looie

Ah, so I should've skipped that step. Got it now, thanks.