Try this: 01) Stop MySQL: /etc/rc.d/init.d/mysqld stop 02) Startup MySQL, bypassing GRANT tables: safe_mysqld --skip-grant-tables 03) Assign MySQL "root" password again mysqladmin -u root password 'new_password' 04) Stop MySQL 05) Start MySQL ... start using it normally NOTE: procedure outlined on pg. 111, Managing & Using MySQL (2nd ed), O'Reilly ----- Original Message ----- From: "Tim Wilson" <wilson at visi.com> To: "TCLUG" <tclug-list at mn-linux.org> Sent: Tuesday, July 06, 2004 5:28 PM Subject: Re: [TCLUG] Can't connect to mysql on localhost > On 7/6/04 5:08 PM, "Daniel Taylor" <random at argle.org> wrote: > > > Try "mysql -u root -h localhost -p", the command you entered will try > > to use the unix domain socket rather than the net socket. > > Daniel, > > Thanks for the suggestion. I got: > > beethoven:/home/wilson# mysql -u root -h localhost -p > Enter password: > ERROR 1045: Access denied for user: 'root at localhost' (Using password: YES) > > > Of course, if it is for purely local use that would be preferable anyway. > > So if I used unix domain sockets, can I turn of the networking in my.cnf? > > -Tim > > -- > Tim Wilson > Twin Cities, Minnesota, USA > Educational technology guy, Linux and OS X fan, Grad. student, Daddy > mailto: wilson at visi.com aim: tis270 public key: 0x8C0F8813 > > > _______________________________________________ > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > Help beta test TCLUG's potential new home: http://plone.mn-linux.org > Got pictures for TCLUG? Beta test http://plone.mn-linux.org/gallery > tclug-list at mn-linux.org > https://mailman.real-time.com/mailman/listinfo/tclug-list _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota Help beta test TCLUG's potential new home: http://plone.mn-linux.org Got pictures for TCLUG? Beta test http://plone.mn-linux.org/gallery tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list