On 09/04/06, Joseph Brick jbrick@gmail.com wrote:
I'm on the MediaWiki setup web form - for the life of me I can't get this to talk to the MySQL database I created.(Keep getting "connection failed" error next to the SQL server host field (containing "localhost')
Check that mysqld is running. ;)
To me the most unclear part is the difference between the DB user/pwd and the Superuser account/pwd.
Essentially, when it's running, MediaWiki needs to know the username and password of a MySQL user with SELECT, INSERT, UPDATE and DELETE permissions on the named wiki database. This is the "database user".
If that user happens to have full permissions on the database (allowing it to also create and alter tables, etc.) then that's all that's needed; MediaWiki can use that account to set up the schema.
If not, then what's needed are the details of a superuser account, such as root, which *does* have these permissions. This account is used to create the database (if needed), create the database user (if needed), and set up the schema. These details aren't retained once the installation is complete.
Rob Church