Dear Mr. Green, first I'd like to thank you for your very clear explanations, which helped. 'mysql' is an overdetermined word with all the advantages and disadvantages of that.
While finally getting into the door, I ran into another problem: "pid-file quit without updating." This seems to be a fairly common phenomenon, to judge from offered help on the Web. But the explanations are all over the map, and the help is of dubious value. I've run into this problem several times. One piece of advice was to use ps ax|grep mysql and then kill the processes with the number returned by the query. That worked on one occasion, but on another occasion it didn't. On that occasion, though, if I logged in as superuser and started the server it worked. There doesn't seem to be anything about this problem in the mysql documentation. I not that it seems to be a fairly common kind of error, with no clearly diagnosis or therapy from a source that can speak with much authority. It may be Mac specific and has to do with Startup items that you're not supposed to use anymore and launcher daemons that are not easily understood by poor mortals by me. But OS X is a very popular operating system and MySQL is a very popular database. So I don't quite understand why very basic installation and operating procedures are so complicated. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 8:40 AM, "shawn l.green" <shawn.l.gr...@oracle.com> wrote: > > >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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
