Web lists-archives.com

Re: password problem






Am 31.07.2015 um 14:40 schrieb Martin Mueller:
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?

what do you not understand in:

>> Resetting the Root Password: Generic Instructions
>> Stop the MySQL server if necessary, then restart it with the
>> --skip-grant-tables option

jesus christ, put "skip-grant-tables" in your "my.cnf", make sure the server is not reachable from outside and just type "myysql -u root" and don't forget remove "skip-grant-tables" after you defined a password you are knowing and restarting the server again

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.

well, you have a bad mix

* missing knowledge
* a blackbox with a installer
* refusing to read more than the begin of docs

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

Attachment: signature.asc
Description: OpenPGP digital signature