Hi Daniel, Sounds like there are a few records missing out of the mysql tables. Did you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----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 <snip> mysql> USE mysql; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' </snip> I have to log in to using mysql -u mysql and it drops me into the mysql command line. It seems as though the user "mysql" has absolutely no privileges to do any thing and I cant log in as root. So I have no idea what I did wrong but this is the third time I installed MySQL41 and I don't think reinstalling would do any thing different. Thanks go out to every one for trying to help me, but like I said I have no idea as to whats wrong. On 5/29/06, David Griffiths <[EMAIL PROTECTED]> wrote: > > 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.0.0.1', 'mysql', password(mysql)); > > and > > "INSERT INTO USER (host, user, password) > values ('localhost', 'mysql', password(mysql)); > > Don't forget to do a "flush privileges;" afterwards (again, no quotes); > > The mysql schema is thoroughly (but dryly) documented @ > http://dev.mysql.com > > David > > Daniel McQuay wrote: > > 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 Maruszeczka <[EMAIL PROTECTED]> wrote: > >> > >> 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 to > > connect > >> > to the server using root; mysql -u root I get an error; > >> > <snip> > >> > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > >> > password: NO) > >> > </snip> > >> > so reading that it appears that I need a password so i try; mysql -u > >> > root -p it prompts me for my root pass and when I put it in it does > >> > that same thing above but with (using password: YES). > >> > > >> > I went to the the MySQL web site and read 2.10.3 Securing the > > Initial > >> > MySQL Accounts and tried following along with that but with no luck. > >> > When checking google for help I read a lot about the initial > >> > installation. Something about /usr/local/bin/mysql_install_db will > >> > install a privilege table. > >> > > >> > I installed mysql using this guide here > >> > http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing > >> > seemed to go well but like I said I keep getting this error. Is > > there > >> > something else I should do? Any help on this would be MUCH > >> > appreciated. > >> > > >> > >> > >> Hi, > >> > >> Wasn't clear to me in reading your post that you did this so here > >> goes: > >> > >> Did you actually set a root password for mysql using a GRANT > >> statement after logging in with the default BLANK password? > >> > >> mysql -u root -p [then just hit enter] > >> > >> HTH, > >> G > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > > > > > -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org 814.825.0847 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
