Web lists-archives.com

Re: password problem

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

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

Martin Mueller

Professor emeritus of English and Classics
Northwestern University

On 7/31/15 3:36 AM, "Reindl Harald" <h.reindl@xxxxxxxxxxxxx> 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/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
>> the directories /usr/local/mysql as well as /usr/local/mysql* and a lot
>> other library and etc files. So there is no trace of the old system on
>> 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.reindl@xxxxxxxxxxxxx> 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
>>>> 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
>>>> 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