Re: Can't get MySQL running on RH7.0 at all.
The only think I did was copy 'my-medium.cnf' to 'my.cnf' and ran mysql_install_db (successfully) and then ran mysqld as instructed which didn't run successfuly and reported the errors below. I didn't change anything in my.cnf, I didn't touch anything at all... Is there a way that I can start fresh without reinstalling the OS? - Original Message - From: Dana Powers [EMAIL PROTECTED] To: Mark Johnson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 1:04 AM Subject: Re: Can't get MySQL running on RH7.0 at all. The error logs seem to indicate that the pid file you've specified is not writable and that the system database tables are not installed properly. 1. make sure that you ran mysql_install_db. If you did, make sure that you didnt change the my.cnf datadir setting without moving your system files or re running mysql_install_db. 2. ( #1 usually takes care of this, but ) make sure the pid file is writable ( find path in error log message or ./mysqld --help or /etc/my.cnf if you've overrided default ) dpk - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:42 PM Subject: Can't get MySQL running on RH7.0 at all. I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't get MySQL running on RH7.0 at all.
Mark Johnson [EMAIL PROTECTED] writes: I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. chown -R mysql.mysql /var/lib/mysql; chmod a+rX /var/lib/mysql An errata was issued when RHL 7 was release, and more has been released since for various issues. Mysql should be started like any other service: service mysqld start (which is equivalent to /etc/init.d/mysqld start. To make it start on every boot, do chkconfig mysqld on or run ntsysv/tksysv and enable it there. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't get MySQL running on RH7.0 at all.
I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't get MySQL running on RH7.0 at all.
The error logs seem to indicate that the pid file you've specified is not writable and that the system database tables are not installed properly. 1. make sure that you ran mysql_install_db. If you did, make sure that you didnt change the my.cnf datadir setting without moving your system files or re running mysql_install_db. 2. ( #1 usually takes care of this, but ) make sure the pid file is writable ( find path in error log message or ./mysqld --help or /etc/my.cnf if you've overrided default ) dpk - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:42 PM Subject: Can't get MySQL running on RH7.0 at all. I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php