Re: Can't start MYSQL on Linux
I got it. Thank you very very much for the help. Ling From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Ling Wang [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Can't start MYSQL on Linux Date: Tue, 7 Aug 2001 23:03:41 -0400 (EDT) On Wed, 8 Aug 2001, Ling Wang wrote: I have to login as root user to do mysql_install_db and safe_mysqld . Otherwise I will get permission denied message. You already made those files, and they're owned by root. You can't overwrite them that way. Just do a chown before you start the database. How come when I type service mysqld start, Linux says command not found? I could not find the command chkconfig either. Both are not path of a user's path[1] - they're admin tools, and are for the use of root. Root can also control which services start with tksysv and ntsysv. [1] They're in /sbin, for the curious. -- 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 start MYSQL on Linux
I have to login as root user to do mysql_install_db and safe_mysqld . Otherwise I will get permission denied message. How come when I type service mysqld start, Linux says command not found? I could not find the command chkconfig either. Your idea does not work for me. Thanks anyhow. Ling From: [EMAIL PROTECTED] (Trond Eivind Glomsrød) To: Ling Wang [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Can't start MYSQL on Linux Date: 07 Aug 2001 00:13:51 -0400 Ling Wang [EMAIL PROTECTED] writes: I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . You're not supposed to. To start mysql, as any service, do service mysqld start (which is equivalent to running the initscript like this /etc/init.d/mysqld start). This will automatically initialize the database the first time it runs. To make it start when your system starts, do chkconfig mysqld on What you've done (and too many others, where do they get this idea?) is that you've created the database files as root. Then you start the database, which will run as mysql. This user can obviously not write to root's files. Change the ownership manually, and try again - with service mysqld start. -- 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 start MYSQL on Linux
Yes, that's it. It worked!!! Thank you so much. Can I ask why? Ling From: Gerald Clark [EMAIL PROTECTED] To: Ling Wang [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Can't start MYSQL on Linux Date: Tue, 07 Aug 2001 10:29:21 -0500 chown -R mysql /var/lib/mysql Ling Wang wrote: I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . It always ends immediately. When I look at the /var/log/mysql.log, the message says: mysql started /usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13) mysql ended I tried start safe_mysqld from many directories and without any success. Can anyone please help me out? Thanks. Ling Wang _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 -- Gerald L. Clark [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 start MYSQL on Linux
I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . It always ends immediately. When I look at the /var/log/mysql.log, the message says: mysql started /usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13) mysql ended I tried start safe_mysqld from many directories and without any success. Can anyone please help me out? Thanks. Ling Wang _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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