MacOS X Server & MySQL - Root Account problems [urgent]
I'm in front of an XServe G5 right now, and I've got the following problem on OS X Server 10.3.9 using the default factory (Apple) install of MySQL.
The problem with it, is it was running MySQL apps (it runs an intranet website, no connection to the outside world), as root with no password. That is, root in MySQL had no password configured.
Aside from the "eep" this causes anyway, the MySQL seems to have assigned itself one when I tried to make a backup earlier, in preparation to move it to 10.4 server.
So now, none of the intranet can be accessed, as the database has become inaccessible - and I need to either (a) rid myself of the password to make the backup, or (b) reset the password.
I've found procedures for recovering the root password but the commands will not work on the XServe - specifically --skip-grant-tables - while logged in as the root on OS X, it keeps saying "permission denied" when I try to kill the mysql processes. [edit - fixed this, can kill the process ok, but the skip is still ignored]
Any ideas how I can sort this, or what I can do? Where is the MySQL database stored - and can I access the flat files and pull out the information - if necessary..?
I've been through this (http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html), but still nothing.
It seems to ignore the --init-file when loading mysqld_safe....
Edited 1 time(s). Last edit at 05/15/2007 08:37AM by Andy Shepherd.
Subject
Views
Written By
Posted
MacOS X Server & MySQL - Root Account problems [urgent]
4449
May 15, 2007 08:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.