Re: i'm at a complete loss?

ent --- -- *From:* Daniel McQuay [mailto:[EMAIL PROTECTED] *Sent:* Tuesday, 30 May 2006 10:39 AM *To:* Logan, David (SST - Adelaide) *Cc:* David Griffiths; mysql@lists.mysql.com *Subject:* Re: i'm at

RE: i'm at a complete loss?

cQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 10:39 AM To: Logan, David (SST - Adelaide) Cc: David Griffiths; mysql@lists.mysql.com Subject: Re: i'm at a complete loss? Nah, that's not the case my friend. I made sure that when I installed mysql that the old one was completely

Re: i'm at a complete loss?

ide SA 5001 Australia invent --- -Original Message- From: Daniel McQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 10:20 AM Cc: David Griffiths; mysql@lists.mysql

RE: i'm at a complete loss?

: i'm at a complete loss? Yeah when I ran it the first time I get this message: boxster# /usr/local/bin/mysql_install_db --user=mysql Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your syst

Re: i'm at a complete loss?

Australia > invent > ------- > > -----Original Message- > From: Daniel McQuay [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 30 May 2006 9:53 AM > To: David Griffiths > Cc: mysql@lists.mysql

Re: i'm at a complete loss?

Adelaide SA 5001 Australia invent --- -Original Message- From: Daniel McQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 9:53 AM To: David Griffiths Cc: mysql@lists.mysql.com

RE: i'm at a complete loss?

--- -Original Message- From: Daniel McQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 9:53 AM To: David Griffiths Cc: mysql@lists.mysql.com Subject: Re: i'm at a complete loss? When I log in using mysql which by the way is the only user that I can log into with I get mysql

Re: i'm at a complete loss?

When I log in using mysql which by the way is the only user that I can log into with I get mysql> USE mysql; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' I have to log in to using mysql -u mysql and it drops me into the mysql command line. It seems as though the

Re: i'm at a complete loss?

Log into the server, and type, "use mysql;" without the quotes. Look at the "user" table - that defines what user can connect to the database, the ip addresses they can use, and the password they must provide. For example, you could enter, "INSERT INTO USER (host, user, password) values ('127

Re: i'm at a complete loss?

Thanks Greg, I did try that here is what happened. boxster# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) boxster# So I really just don't know what to do from here. I'm up for any ideas if any one has 'em. On 5/29/06, Greg Ma

Re: i'm at a complete loss?

On Sun, 28 May 2006 20:17:53 -0400 "Daniel McQuay" <[EMAIL PROTECTED]> wrote: > Hello list, > > I just installed MySQL on my FreeBSD box here at home and am having a > few problems with privileges. I can connect to mysql using; mysql -u > mysql and there is no password needed. However, when I try

i'm at a complete loss?

Hello list, I just installed MySQL on my FreeBSD box here at home and am having a few problems with privileges. I can connect to mysql using; mysql -u mysql and there is no password needed. However, when I try to connect to the server using root; mysql -u root I get an error; ERROR 1045 (28000):