Re: mysql connect problems

2004-12-11 Thread John DeStefano
On Sat, 11 Dec 2004 09:23:52 +, Peter Risdon [EMAIL PROTECTED] wrote: When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support

Re: mysql connect problems

2004-12-11 Thread Peter Risdon
John DeStefano wrote: [...] When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support authentication protocol requested by server; consider upgrading

Re: mysql connect problems

2004-12-10 Thread John DeStefano
On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon entries (localhost and host name), 2 'mtuser' entries (one on

Re: mysql connect problems

2004-12-10 Thread Jorn Argelo
On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon

Re: mysql connect problems

2004-12-10 Thread Peter Risdon
Jorn Argelo wrote: On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2

Re: mysql connect problems

2004-12-10 Thread John DeStefano
On Fri, 10 Dec 2004 00:15:10 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote [snip] At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u root -p ... I can connect. Which makes sense. Because the

Re: mysql connect problems

2004-12-10 Thread Jorn Argelo
On Fri, 10 Dec 2004 09:54:56 -0500, John DeStefano wrote On Fri, 10 Dec 2004 00:15:10 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote [snip] At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u

Re: mysql connect problems

2004-12-10 Thread John DeStefano
On Fri, 10 Dec 2004 16:09:20 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: You have to make sure that the user has access to login. Unless you are using this database on an important machine, you can always change the root password like this: set password = password(yournewpassword); Like

Re: mysql connect problems

2004-12-10 Thread Jorn Argelo
On Fri, 10 Dec 2004 11:07:17 -0500, John DeStefano wrote On Fri, 10 Dec 2004 16:09:20 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: You have to make sure that the user has access to login. Unless you are using this database on an important machine, you can always change the root password

Re: mysql connect problems

2004-12-10 Thread John DeStefano
On Fri, 10 Dec 2004 21:43:19 +, Peter Risdon [EMAIL PROTECTED] wrote: AFAIK you must type '[EMAIL PROTECTED]' (including the quotes). If that doesn't work, then I don't know it either. Perhaps somebody else on the list has an idea? I have found it's best to connect to the database you

mysql connect problems

2004-12-09 Thread John DeStefano
I wanted to give a try at enhancing my knowledge and improving my Web server/sites by adding blog (Mobile Type) and wiki (MediaWIki) applications. If you've ever tried to install/configure either of these two apps on FreeBSD, perhaps you already know the frustration I've met over the past 24

Re: mysql connect problems

2004-12-09 Thread Jorn Argelo
On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote [snip] At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u root -p ... I can connect. Which makes sense. Because the -p option is for entering a password. And I don't think you'll have an empty