I first tried to run the server directly from /usr/libexec/mysqld. I got the following errors. When I tried the mysql.server shell script I got errors telling me there was no macppc03.pid
Code: Select all
їmacppc03:/] pbearpro% /usr/libexec/mysqld
020910 23:08:53 /usr/libexec/mysqld: Can't create/write to file '/var/macppc03.pid' (Errcode: 13)
020910 23:08:53 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
020910 23:08:53 /usr/libexec/mysqld: Error on delete of '/var/macppc03.pid' (Errcode: 2)Code: Select all
їmacppc03:/] pbearpro% sudo touch macppc03.pid
їmacppc03:/] pbearpro% sudo /usr/libexec/mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
020910 23:09:54 Aborting
020910 23:09:54 /usr/libexec/mysqld: Shutdown CompleteCode: Select all
їmacppc03:/usr/share/mysql] pbearpro# ./mysql.server start
їmacppc03:/usr/share/mysql] pbearpro# touch: /var/mysql/macppc03.err: No such file or directory
chown: /var/mysql/macppc03.err: No such file or directory
Starting mysqld daemon with databases from /var/mysql
/usr/bin/safe_mysqld: /var/mysql/macppc03.err: No such file or directory
/usr/bin/safe_mysqld: /var/mysql/macppc03.err: No such file or directory
tee: /var/mysql/macppc03.err: No such file or directory
020911 00:08:25 mysqld ended
tee: /var/mysql/macppc03.err: No such file or directoryCode: Select all
їmacppc03:/usr/share/mysql] pbearpro# mkdir /var/mysql
їmacppc03:/usr/share/mysql] pbearpro# touch /var/mysql/macppc03.err
їmacppc03:/usr/share/mysql] pbearpro# ./mysql.server start
їmacppc03:/usr/share/mysql] pbearpro# Starting mysqld daemon with databases from /var/mysql
020911 00:09:32 mysqld endedCode: Select all
їmacppc03:/usr/share/mysql] pbearpro# more /var/mysql/macppc03.err
020911 00:09:32 mysqld started
020911 0:09:32 /usr/libexec/mysqld: Can't create/write to file '/var/mysql/macppc03.pid' (Errcode: 13)
020911 0:09:32 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
020911 0:09:32 /usr/libexec/mysqld: Error on delete of '/var/mysql/macppc03.pid' (Errcode: 2)
020911 00:09:32 mysqld endedCode: Select all
їmacppc03:/usr/share/mysql] pbearpro# chown mysql /var/mysql
їmacppc03:/usr/share/mysql] pbearpro# ./mysql.server start
їmacppc03:/usr/share/mysql] pbearpro# Starting mysqld daemon with databases from /var/mysql
020911 00:16:03 mysqld ended
20911 00:16:03 mysqld started
020911 0:16:03 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
020911 00:16:03 mysqld endedAny help you could give me is greatly appreciated.
Regards,
Paul