I find the new wiki install config screen englessly confusing. Here are some of my questions:
1. For the "Database Config" section, am I providing a NEW username and password, or suppling a pre-existing one?
2. Does the "Database Config" username and password have to be the same as the "Site Config" username and password? Why are "wikidb" and "wiiuser" prefilled? I ask because using these has never worked for installs to my local box.
3. When installing to a webserver, not on my local box, how do I know what to enter in the "Database Host" field?
4. What is the superuser account? How do I know if I need to create one? Am I providing a NEW username and password for a superuser, or suppling pre-existing information for a currently existing superuser? Why is "root" prefilled? I ask because using root has never worked for installs to my local box.
These instructions just don't help me - I don't know why some things work and others don't - possibly because I don't know what I'm doing at all and can't find a tutorial on this information anywhere.
Steve VanSlyck wrote:
I find the new wiki install config screen englessly confusing. Here are some of my questions:
- For the "Database Config" section, am I providing a NEW username and
password, or suppling a pre-existing one?
If you fill in the superuser section with valid credentials you may provide either, if you do not then you must provide a per-existing ones.
- Does the "Database Config" username and password have to be the same
as the "Site Config" username and password? Why are "wikidb" and "wiiuser" prefilled? I ask because using these has never worked for installs to my local box.
wikidb and wikiuser are prefilled just to give the user an idea of what is expected, they do not have to be the same as the site config username and password. If you fill in the superuser section with valid credentials the database and database user do not have to be precreated, otherwise they must be (see the MySQL manually for details on how to do this, or consult your web host if you use one).
- When installing to a webserver, not on my local box, how do I know
what to enter in the "Database Host" field?
Your webserver provider or the person who configured it will know these details and be able to tell you; it is usually localhost.
- What is the superuser account? How do I know if I need to create one?
Am I providing a NEW username and password for a superuser, or suppling pre-existing information for a currently existing superuser? Why is "root" prefilled? I ask because using root has never worked for installs to my local box.
The superuser account is a MySQL user with sufficient privileges to create a database and database user. If you are installing on a different server that you do not own generally you will not have this info so can leave that section blank, on a home box you may specify these if you want the database and database user to be automatically created (you can precreate them if you wish) and it will most probably use the root account created when you installed MySQL (consult the MySQL manually for more details).
These instructions just don't help me - I don't know why some things work and others don't - possibly because I don't know what I'm doing at all and can't find a tutorial on this information anywhere.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MinuteElectron.
Who exactly is the "dbuser"? Is it some live human user? Or is it an internal name and password that the wiki uses to connect to and interact with the database?
I don't understand what you mean by "If you fill in the superuser section with valid credentials, the database and database user do not have to be precreated,...." How can they be 'valid' if they're not already pre-existing??
MinuteElectron wrote:
wikidb and wikiuser are prefilled just to give the user an idea of what is expected, they do not have to be the same as the site config username and password. If you fill in the superuser section with valid credentials the database and database user do not have to be precreated, otherwise they must be (see the MySQL manually for details on how to do this, or consult your web host if you use one).
Steve VanSlyck wrote :
Who exactly is the "dbuser"? Is it some live human user? Or is it an internal name and password that the wiki uses to connect to and interact with the database?
It's a mysql database user (so it's "an internal name and password that the wiki uses to connect to and interact with the database".)
db user is NOT a wiki user, nor a user of your local host. it's a mysql user.
On the other hand, Site config username is the name of the first user of your wiki (normally it's prefilled as WikiSysop) (NB : he will be bureaucrat and sysop of the wiki)
I don't understand what you mean by "If you fill in the superuser section with valid credentials, the database and database user do not have to be precreated,...." How can they be 'valid' if they're not already pre-existing??
the superuser is the superuser of your mysql install (he is named "root" on many default mysql install. I don't know about your local install since you said that "root" wasn't working but you should have a user with who you connect to your mysql database, don't you ?).
Of course this superuser must be pre-existing, it has been created at the time you installed mysql
When you fill the superuser fields with valid credentials (for that superuser), it will be able to create a mysql database (default value : wikidb) and a database user (default : wikiuser) that will be used by your wiki.
Note that these superuser information will not be used by the wiki after that and they won't be stored anywhere, they are used only at installation time to create mysql database and user for the wiki.
Also note that if you're installing on some hosting service, you probably do not have access to the database as "root", therefore you must use a pre-existing database in the "Database name:" field and a pre-existing user in the "DB username:" field (see your host provider for these information)
This is really helpful - thanks!!!
Alexis Moinet wrote:
Steve VanSlyck wrote :
Who exactly is the "dbuser"? Is it some live human user? Or is it an internal name and password that the wiki uses to connect to and interact with the database?
It's a mysql database user (so it's "an internal name and password that the wiki uses to connect to and interact with the database.")
db user is NOT a wiki user, nor a user of your local host. it's a mysql user.
On the other hand, Site config username is the name of the first user of your wiki (normally it's prefilled as WikiSysop) (NB : he will be bureaucrat and sysop of the wiki)
I don't understand what you mean by "If you fill in the superuser section with valid credentials, the database and database user do not have to be precreated,...." How can they be 'valid' if they're not already pre-existing??
the superuser is the superuser of your mysql install (he is named "root" on many default mysql install. I don't know about your local install since you said that "root" wasn't working but you should have a user with who you connect to your mysql database, don't you ?).
Of course this superuser must be pre-existing, it has been created at the time you installed mysql
When you fill the superuser fields with valid credentials (for that superuser), it will be able to create a mysql database (default value : wikidb) and a database user (default : wikiuser) that will be used by your wiki.
Note that these superuser information will not be used by the wiki after that and they won't be stored anywhere, they are used only at installation time to create mysql database and user for the wiki.
Also note that if you're installing on some hosting service, you probably do not have access to the database as "root", therefore you must use a pre-existing database in the "Database name:" field and a pre-existing user in the "DB username:" field (see your host provider for these information)
mediawiki-l@lists.wikimedia.org