Hi,
I wanted to access more than one MySQL databases to follow http://www.mediawiki.org/wiki/Manual:Wiki_family
One DB is called wikiDB1 and the according user is called wikiDB1user.
According to http://dev.mysql.com/doc/refman/5.0/en/adding-users.html I tried
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON wikiDB1.* TO 'wikiDB1user'@'localhost' IDENTIFIED BY 'passwd'; FLUSH PRIVILEGES;
but even
$ mysql -u wikiDB1user -p wikiDB1
fails on command line so it is clear that I get
(Can't contact the database server: Access denied for user 'wikiFG31user'@'localhost' (using password: YES) (localhost))
on the Wiki page.
Sorry for asking MySQL specific questions here, but this seems the quickest way for me as a bloody MySQL beginner to ask for help.
Thanks
Andreas.
If you typed that exactly, your password should be "passwd", not wikiDB1...
Alex
On 5/11/07, Andreas Tille tillea@rki.de wrote:
Hi,
I wanted to access more than one MySQL databases to follow http://www.mediawiki.org/wiki/Manual:Wiki_family
One DB is called wikiDB1 and the according user is called wikiDB1user.
According to http://dev.mysql.com/doc/refman/5.0/en/adding-users.html I tried
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON wikiDB1.* TO 'wikiDB1user'@'localhost' IDENTIFIED BY 'passwd'; FLUSH PRIVILEGES;
but even
$ mysql -u wikiDB1user -p wikiDB1
fails on command line so it is clear that I get
(Can't contact the database server: Access denied for user 'wikiFG31user'@'localhost' (using password: YES) (localhost))
on the Wiki page.
Sorry for asking MySQL specific questions here, but this seems the quickest way for me as a bloody MySQL beginner to ask for help.
Thanks
Andreas.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 11/05/07, Alex Powell alexp@exscien.com wrote:
If you typed that exactly, your password should be "passwd", not wikiDB1...
I love the MySQL command line client.
`$ mysql -u wikiDB1user -p wikiDB1`
This reads as
* start the MySQL command line client * my username is wikiDB1user * prompt me for my password * select wikiDB1
The -p switch confuses a lot of people. To specify the password on the command line, you do something like `-ppassword`, i.e. no space. If the switch is specified as-is, without anything immediately following it, then it causes the client to prompt for the password.
Rob Church
On Fri, 11 May 2007, Rob Church wrote:
On 11/05/07, Alex Powell alexp@exscien.com wrote:
If you typed that exactly, your password should be "passwd", not wikiDB1...
I love the MySQL command line client.
`$ mysql -u wikiDB1user -p wikiDB1`
This reads as
- start the MySQL command line client
- my username is wikiDB1user
- prompt me for my password
- select wikiDB1
The -p switch confuses a lot of people. To specify the password on the command line, you do something like `-ppassword`, i.e. no space. If the switch is specified as-is, without anything immediately following it, then it causes the client to prompt for the password.
... which is exactly what I intended. If you specify only -p (with a blank following) you were asked about the password with a prompt which is perfectly what I think is reasonable to post to a mailing list. SO the problem is NOT that I mixed up password and database name. The line above sais:
Please connect the user wikiDB1user to database wikiDB1 and prompt for a password.
So this is not the source of the problem and moreover MediaWiki would not have trouble to log in because the Password is obtained from the config file without strange syntax.
Kind regards
Andreas.
On 11/05/07, Andreas Tille tillea@rki.de wrote:
... which is exactly what I intended. If you specify only -p
I know it's exactly what you intended. I was clarifying for the other, confused respondents on this thread.
So this is not the source of the problem and moreover MediaWiki would not have trouble to log in because the Password is obtained from the config file without strange syntax.
Is the password correct?
Are you using a MySQL 4.0.x server and a MySQL 4.1.x or 5.x client, which might introduce problems due to the change in password hashing/encryption/etc. between these versions? (http://dev.mysql.com/doc/refman/5.0/en/old-client.html)
See also http://dev.mysql.com/doc/refman/5.0/en/password-too-long.html, although this is a much rarer situation.
If MediaWiki can't connect to the database, and your credentials don't appear to work on the command line either, then you don't have a MediaWiki problem, you have a MySQL problem.
Rob Church
Some hosts require that you specify the database hostname when connecting, rather than just using localhost. Perhaps this is the case here?
On 5/11/07, Rob Church robchur@gmail.com wrote:
On 11/05/07, Andreas Tille tillea@rki.de wrote:
... which is exactly what I intended. If you specify only -p
I know it's exactly what you intended. I was clarifying for the other, confused respondents on this thread.
So this is not the source of the problem and moreover MediaWiki would not have trouble to log in because the Password is obtained from the config file without strange syntax.
Is the password correct?
Are you using a MySQL 4.0.x server and a MySQL 4.1.x or 5.x client, which might introduce problems due to the change in password hashing/encryption/etc. between these versions? (http://dev.mysql.com/doc/refman/5.0/en/old-client.html)
See also http://dev.mysql.com/doc/refman/5.0/en/password-too-long.html, although this is a much rarer situation.
If MediaWiki can't connect to the database, and your credentials don't appear to work on the command line either, then you don't have a MediaWiki problem, you have a MySQL problem.
Rob Church
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 12/05/07, Emufarmers Sangly emufarmers@gmail.com wrote:
Some hosts require that you specify the database hostname when connecting, rather than just using localhost. Perhaps this is the case here?
Well, "just using 'localhost'" is still providing a host name; it's just indicating that the host is the current one, rather than a remote host. So the issue wouldn't be omission of a host name, it would be providing the wrong one.
Good suggestion, however.
Rob Church
Macs can be odd about localhost.
On May 11, 2007, at 10:49 PM, Rob Church wrote:
On 12/05/07, Emufarmers Sangly emufarmers@gmail.com wrote:
Some hosts require that you specify the database hostname when connecting, rather than just using localhost. Perhaps this is the case here?
Well, "just using 'localhost'" is still providing a host name; it's just indicating that the host is the current one, rather than a remote host. So the issue wouldn't be omission of a host name, it would be providing the wrong one.
Good suggestion, however.
Rob Church
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054
On Sat, 12 May 2007, Jim Hu wrote:
Macs can be odd about localhost.
The system used is a SLES9 and no Mac. I'm not confident with SLES problems because I used Debian exclusively for years. So if there are any known pitfalls here it might help es well.
Kind regards
Andreas.
On Fri, 11 May 2007, Rob Church wrote:
If MediaWiki can't connect to the database, and your credentials don't appear to work on the command line either, then you don't have a MediaWiki problem, you have a MySQL problem.
I think so - that's why I marked the subject of the thread [OT] - I just assumed that on this list are many MySQL experts hanging around and I do not need to query a MySQL list.
BTW, I have several experiences with PostgreSQL. Is it advisable to move the database to PostgreSQL or should I expect other problems in this case.
Kind regards
Andreas.
mediawiki-l@lists.wikimedia.org