I've been installing mySQL on my installion of OSX every since I've had 10.1 on installed. I've just recently tried to upgrade it on my upgraded panther OS, but haven't had any luck getting the service started. I know that panther does come with installed but I wanted to installed the newest verions, so i donwloaded the pkg file from mysql.com. I've followed the instructions on entropy.ch for upgrading the mysql install, and after a few errors, i've finally gotten to one that I can't seem to resolve. I try starting the service like this:
shell > mysqld_safe --user=mysql
the result is that the service never starts, and the .err file in my data/ folder is:
"Fatal Error: Can't open privilege tables: Table 'mysql.host' doesn't exist"
I've run the the mysql_fix_privilege_tables, thinking that this would fix it, but that only seems to work when the service is running? Can anyone help me out here?
Just for some added information, the mysql account that initially was installed, was modified my Apple during an upgrade, setting both the Shell and HomeDir to /dev/null I've updated these attributes, but still to no avail.
I also noticed that in /usr/local/bin there are some mysql binaries, including a mysqld, are these where apple installs its version of mysql? I can't seem to start it up from here either though.
shell > mysqld_safe --user=mysql
the result is that the service never starts, and the .err file in my data/ folder is:
"Fatal Error: Can't open privilege tables: Table 'mysql.host' doesn't exist"
I've run the the mysql_fix_privilege_tables, thinking that this would fix it, but that only seems to work when the service is running? Can anyone help me out here?
Just for some added information, the mysql account that initially was installed, was modified my Apple during an upgrade, setting both the Shell and HomeDir to /dev/null I've updated these attributes, but still to no avail.
I also noticed that in /usr/local/bin there are some mysql binaries, including a mysqld, are these where apple installs its version of mysql? I can't seem to start it up from here either though.