Web lists-archives.com

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
follows:


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.

skip-grant-tables

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).

mysql


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
another machine.

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
doors.


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 ...

--
Shawn Green
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/ for details.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql