MediaWiki / MySQL

apps

#1

I am trying to install MediaWiki, but I can not logon to MySQL as “root”. Is there a way around this? Can I install my own copy of MySQL and run that?


#2

You don’t need to login to MySQL as root. Create the database from the web panel, and use this for the program.


#3

The installation script has statements like:

GRANT ALL ON {$wgDBname}.*
TO {$wgDBadminuser}@’%’ IDENTIFIED BY ‘{$wgDBadminpassword}’;

GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname}.*
TO {$wgDBuser}@’%’ IDENTIFIED BY ‘{$wgDBpassword}’;

These commands apparently require being logged on as root, and don’t work from the add user interface.


#4

Right… you can manage the permissions to the db user from the web panel. I think the default permissions should work, but if you have to edit them, you can (click on “edit” for the appropriate database username).


#5

http://wiki.schubart.net/How_to_Install_MediaWiki_at_DreamHost


#6

That’s a nice tutorial.


#7

Thank you Michael Schubart very much. You’re a smarter person than I.