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). But if I do this with the command 'mysql -u mysql I get the answer 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? 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. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 3:36 AM, "Reindl Harald" <h.rei...@thelounge.net> wrote: >first: don't reply off-list, a answer on a mailing-list is no invitation >for private support! > >Am 31.07.2015 um 02:34 schrieb Martin Mueller: >> I read that section but was stopped in my tracks by >> >> "Log on to your system as the Unix user that the MySQL server runs as >> (for example, mysql)" >> >> Because I have no password for ANY thing. > >read the f**ng >https://dev.mysql.com/doc/refman5.0/en/resetting-permissions.html ><https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html> - >unbelievebale that users these days need anything ready chewed and are >too lazy to click on a link and read more than 5 lines > >Resetting the Root Password: Generic Instructions >Stop the MySQL server if necessary, then restart it with the >--skip-grant-tables option > >> I used the uninstall routine recommended by Rob Allen, in which you >>remove >> the directories /usr/local/mysql as well as /usr/local/mysql* and a lot >>of >> other library and etc files. So there is no trace of the old system on >>my >> machine. How come a routine installation of mysql then locks up the >> application. > >the datadir is *not* removed by any sane installer, dunno where it lives >on Apple machines since i banned them 5 years ago for good reasons > >on a non-OSX i would just type "updatedb; locate mysql" als root > >> On 7/30/15, 19:22, "Reindl Harald" <h.rei...@thelounge.net> wrote: >>> >>> Am 31.07.2015 um 01:41 schrieb Martin Mueller: >>>> I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I >>>> cannot >>>> run the mysql command because it challenges me for a password. But I >>>>did >>>> not set any password, either for the root, for mysql, or for myself >>>>as a >>>> user. >>>> >>>> So the installation has somehow installed passwords about which I know >>>> nothing or there is some error in the installation process. >>>> >>>> There is a lot on the Web about resetting a forgotten password. But >>>>the >>>> assumption is always that you can get at the program via some other >>>> password. But in this case every door is shut. >>>> >>>> Does anybody recognize this problem? I've uninstalled and re-installed >>>> the >>>> program, but the results are always the same >>> >>> * install and uninstall *never* removes the datadir >>> * users and permissions are in the DB "mysql" >>> * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
