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 > > supp

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 upgradi

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 dat

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),

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),

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 > >

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 passwor

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"); >

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 > > > th

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 sens

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 empt

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 hours