Re: password problem
On 7/31/2015 8:40 AM, Martin Mueller wrote:
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).
Everything that executes on a Linux/Unix/Mac machine executes in the
context of some kind of user account (the system login). By default,
mysqld (the database server daemon) is installed to run under the host
machine user account 'mysql'. It can be changed if you want to change it
but that is the default. That is why 'mysql' was listed in the "for
example" section of that instruction.
But if I do this with the command 'mysql -u mysql I get the answer
No. That is how you log into mysqld to open a MySQL client session. The
instruction was to login to your operating system as the user that
mysqld operates as. These are fundamentally different accounts at two
very different levels.
Access denied for user 'mysql'@'localhost' (using password: NO)
I can do this as super user or normal, and I can try passwords from
earlier installations, but none of them work. So I am stopped dead in my
tracks, am I not?
That is because you didn't add this line to the [mysqld] section of your
configuration file before you started mysqld.
If you had, you would not have needed to use any passwords at all. This
command (on the system prompt) would be all you need to connect to your
now completely-unlocked database server (see the third section of
generic instructions that work on any platform).
As for the datadir, the command "update db locate mysql" works on the Mac
and gives me info about a whole set of files in
/usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and
I deleted a previous installation because I had moved the data I needed to
I'm not a very experienced programmer and have trouble wrestling with the
command line. But I think I did my due diligence and didn't find any open
The door is there, you just just need to be able to see it as a door.
Just a little more experience working on the command line will help.
... remainder snipped ...
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql