Re: password problem
- Date: Fri, 31 Jul 2015 15:30:32 +0200
- From: Reindl Harald <h.reindl@xxxxxxxxxxxxx>
- Subject: 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 optionjesus 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 optionI 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 rootOn 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
Description: OpenPGP digital signature