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