On Monday 16 February 2009, Brian Millett wrote: >On Mon, 2009-02-16 at 10:03 -0500, Gene Heskett wrote: >> On Monday 16 February 2009, Steve Searle wrote: >> >Around 02:33pm on Monday, February 16, 2009 (UK time), Gene Heskett scrawled: >> >> 3.# mysql -u root mysql >> > >> >3.# mysql -u root mysql -p >> > ^^ >> > >> >The -p will cause you to be prompted for root's password. What you have >> >tried does not supply the password. >> > >> >Steve >> >> Unforch Steve, same error: >> >> [root@coyote etc]# mysql -u root mysql -p >> Enter password: >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >> password: YES) >> [root@coyote etc]# mysql -u root mysql -p >> Enter password: >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >> password: YES) >> >> in each case I entered my root pw at the prompt. > >That will be the mysql root user, not the system root user. IF that was >setup installing mythtv, then you need to check the scripts used in the >package that installed mysql. Humm, mythtv was built from the tarball. mysql was from the F8 rpms. I'll check the mythtv Makefile. No joy there, and /etc/my.cnf says the user=mysql Do I need to add another user, such as mythtv and assign that user a password? Or assign mysql a password? I did the latter as mysql existed in the passwd file, but the same error results: [root@coyote etc]# passwd mysql Changing password for user mysql. New UNIX password: Retype new UNIX password: passwd: all authentication tokens updated successfully. [root@coyote etc]# mysql -u mysql -p Enter password: ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: YES) [root@coyote etc]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Does anyone know the default msql passwd so I can set it back? Still bumfuzzled. Thanks. -- Cheers, Gene "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author) I need another lawyer like I need another hole in my head. -- Fratianno -- fedora-list mailing list fedora-list@xxxxxxxxxx To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
