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'(a)'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@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)
Accuracy, n.:
The vice of being right