myqsl dummy needs help

[Gene Heskett]

On Monday 16 February 2009, Robert L Cochran wrote:
>All the heavier-weight database engines have their own user accounts, so
>they can grant or restrict permissions to various databases and tables
>based on who the user is. MySQL does this. Even though mysql has a root
>user that user is totally separate from the OS root account. You can
>also have a mysql user account named mickey even though your host box
>does not have such a user. So think only in terms of the defined MySQL
>users.
>
>You need to reset the MySQL root user password.
>
>There may be no password to start with. I wonder what happens if you
>just press enter when prompted for the password. If there is no
>password, then you can set one using mysqladmin. When you first start
>the mysqld server using 'service start mysqld' the syntax of the command
>is explained to you right on the terminal window.
>
>One more point. If you want to assign a password to a user on a specific
>host machine, such as 'mickey'@'mickeymouse.m1.org' then I believe that
>at the time someone attempts to log in with that username the actual
>machine name must resolve correctly on dns to 'mickeymouse.m1.org' or
>the user 'mickey' must have a password defined for the localhost machine
>('mickey'@'localhost').
>
>To do reset the root password correctly, you can find copious details on
>the MySQL knowledgebase. Go to www.mysql.com and search off their
>knowledgebase. There is a method described for changing the password for
>the root user, but it is fairly complicated. I've used it successfully
>once or twice before when I made a mess of my own mysql root password.

I have now done that procedure twice, setting a different passwd the last time 
in case mysql has a password length limit less that the size of my root pw.

It didn't help, I'm still getting exactly the same error.  How can I nuke it 
all & start from a truly scratch install?

>Another great resource is to read Paul DuBois book "MySQL". It is really
>the bible of all things MySQL. If you intend to use MySQL seriously then
>this book is mandatory purchasing and reading.

That book, if B&N has it, is 60 miles away.

>Bob Cochran
>
>Gene Heskett wrote:
>> 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 at coyote etc]# mysql -u root mysql -p
>>>> Enter password:
>>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>>>> password: YES)
>>>> [root at 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 at coyote etc]# passwd mysql
>> Changing password for user mysql.
>> New UNIX password:
>> Retype new UNIX password:
>> passwd: all authentication tokens updated successfully.
>> [root at coyote etc]# mysql -u mysql -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using
>> password: YES)
>> [root at 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)
Accuracy, n.:
	The vice of being right