Re: Can't start mysql
Hello. Have you add mysql_enable=YES and others to /etc/rc.conf? See the contents of /usr/local/etc/rc.d/mysql-server.sh Tim DeBoer [EMAIL PROTECTED] wrote: Hi everyone, I just installed mysql50-server, -client, and -scripts from Freebsd ports. Everything seemed to go well, no errors that I noticed anyway. So, after installing I tried to start the mysql server. /usr/local/etc/rc.d/mysql-server.sh start Nothing happens. No error messages, no starting, nothing. If I do a ps ax I see no processes for anything connected to mysql. I see no errors in any of my system logs either. So, I made deinstall on all three, and reinstalled them. Same results. The only thing I can think of is a permissions problem, but I'm not sure where to look. /usr/local/bin/mysql is chowned root:wheel, is that correct? Is there a log my startup errors should be dumping to? Is there somewhere else I should be checking permissions? Is there anything the problem might be, that I can check? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysql 5.0.15
Saffa Kemokai wrote: I am unable to start mysql after several trials and fixes. I compiled a mysql 5.0.15 source for FreeBSD 5.3. It doesn't seem to have placed the files in their proper locations. Below is what I keep getting and I don't know now how to get it working. What do I need to do about this mysql.host table? How do I create it? 051110 20:59:33 InnoDB: Started; log sequence number 0 43655 051110 20:59:34 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 051110 20:59:34 mysqld ended Are you installing from a tarball? If so, you should seriously consider using the FBSD ports system instead since it will make longer term management much easier. # cd /usr/ports/databases/mysql-server50 # make install clean G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can't start mysql 5.0.15
You don't appear to have completed the installation process. The processes are described here http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Saffa Kemokai [mailto:[EMAIL PROTECTED] Sent: Friday, 11 November 2005 12:56 PM To: mysql@lists.mysql.com Subject: Can't start mysql 5.0.15 I am unable to start mysql after several trials and fixes. I compiled a mysql 5.0.15 source for FreeBSD 5.3. It doesn't seem to have placed the files in their proper locations. Below is what I keep getting and I don't know now how to get it working. What do I need to do about this mysql.host table? How do I create it? 051110 20:59:33 InnoDB: Started; log sequence number 0 43655 051110 20:59:34 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 051110 20:59:34 mysqld ended Thanks, Saffa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Start MySql
Hello. It could be a bug, because you're using rather deprecated software (Win98) and a very old MySQL 4.0.14. A Z [EMAIL PROTECTED] wrote: MySQL 4.0.14 Win98 platform. what could cause the following error by typing mysqld --console. regards 050525 16:50:13 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 1 1545457619 InnoDB: Doing recovery: scanned up to log sequence number 1 1545457619 050525 16:50:13 InnoDB: Flushing modified pages from the buffer pool... 050525 16:50:13 InnoDB: Started C:\TEAM\SQL\BIN\MYSQLD.EXE: ready for connections. Version: '4.0.14-max-debug' socket: '' port: 3306 050525 16:50:14 InnoDB: Assertion failure in thread 4293331611 in file ../innob ase/include\page0page.ic line 482 InnoDB: Failing assertion: offs UNIV_PAGE_SIZE InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to mysql@lists.mysql.com InnoDB: Thread 4293334199 stopped in file C:\build\build\mysql-4.0.14b\innobase\ ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysql server automatically
Michael Stassen [EMAIL PROTECTED] wrote: O Well, clearly LD_LIBRARY_PATH isn't set at startup. That's one of the reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not recommended. With a proper setup, you should never need LD_LIBRARY_PATH in Solaris. In any version of Solaris, you can build with -R /usr/local/lib to create executables which know to look in /usr/local/lib to find libraries at run time. Yes and also do ldd /usr/local/lib/libstdc++.so.5 to check if everything else is found there. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can't start mysql server automatically
Also you can also use the crle command to build a permanent set of library paths similar to ldconfig in Linux and other unices. There should be a man page for it on your system. You can simply add /usr/local/lib to there in the correct order and this resolves having to use LD_LIBRARY_PATH. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Monday, 23 August 2004 10:26 PM To: [EMAIL PROTECTED] Subject: Re: Can't start mysql server automatically Michael Stassen [EMAIL PROTECTED] wrote: O Well, clearly LD_LIBRARY_PATH isn't set at startup. That's one of the reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not recommended. With a proper setup, you should never need LD_LIBRARY_PATH in Solaris. In any version of Solaris, you can build with -R /usr/local/lib to create executables which know to look in /usr/local/lib to find libraries at run time. Yes and also do ldd /usr/local/lib/libstdc++.so.5 to check if everything else is found there. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysql server automatically
Well, clearly LD_LIBRARY_PATH isn't set at startup. That's one of the reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not recommended. With a proper setup, you should never need LD_LIBRARY_PATH in Solaris. In any version of Solaris, you can build with -R /usr/local/lib to create executables which know to look in /usr/local/lib to find libraries at run time. Starting with Solaris 8, you can use crle to add /usr/local/lib to the dynamic linker's path. Michael McAfee wrote: I configured MySQL to start automatically on a Sun Ultra10 running Solaris 9 as per the installation instructions installing the following scripts/links: - /etc/init.d/mysql - /etc/rc3.d/S99mysql - /etc/rc0.d/K01mysql The MySQL daemon however failed to start at system startup. The .err log file contained the following... 040814 21:27:55 mysqld started ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.5: open failed: No such file or directory 040814 21:27:56 mysqld ended libstdc++.so.5 does exist (located in '/usr/local/lib') and is set in LD_LIBRARY_PATH. I can however start/stop/interact successfully with MySQL from the command line!?! I don't know how to correct this libstdc++.so.5 error...it exists. GR:-( Any help greatly appreciated. Thanks Graeme -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL
Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: Bob Demers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL I've clearly done something worng but, novice that I am, I'm at a dead end to figuring out just where I've gone astray. I've scoured the help files and faqs locally and online but can't seem to find anything I recognize as relevant. Perhaps someone can point me in the right direction. Have installed (actually twice) MySQL-PHP-Apache from CD included with Sams Teach Yourself PHP, MySQL and Apache in 24 Hours on Windows 98. Machine: Compaq Presario 5610, 192MBram Problem:#1 When I attempt to start Apache I get The system cannot find the file specified What file would that be? Service Status is dev4_423 (whatever that means). Problem #2: When clicking on MySQL stoplight icon in startup I get the MySql admin window AND a blank DOS window (MySqld)the cursor slows to a useless crawl and properties shows only an entry in Cmd Line = c:\windows\system\conagent.exe. Cursor doesn't return to normal speed until I close the MSDOS window, which also closes MySQL. Haven't got far enough along to do anything about configuring PHP. Bob Demers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL
Might also help if he would specify the O/S ... - Original Message - From: Martin Gainty [EMAIL PROTECTED] To: Bob Demers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 01, 2003 1:12 PM Subject: Re: Can't start MySQL Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: Bob Demers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL I've clearly done something worng but, novice that I am, I'm at a dead end to figuring out just where I've gone astray. I've scoured the help files and faqs locally and online but can't seem to find anything I recognize as relevant. Perhaps someone can point me in the right direction. Have installed (actually twice) MySQL-PHP-Apache from CD included with Sams Teach Yourself PHP, MySQL and Apache in 24 Hours on Windows 98. Machine: Compaq Presario 5610, 192MBram Problem:#1 When I attempt to start Apache I get The system cannot find the file specified What file would that be? Service Status is dev4_423 (whatever that means). Problem #2: When clicking on MySQL stoplight icon in startup I get the MySql admin window AND a blank DOS window (MySqld)the cursor slows to a useless crawl and properties shows only an entry in Cmd Line = c:\windows\system\conagent.exe. Cursor doesn't return to normal speed until I close the MSDOS window, which also closes MySQL. Haven't got far enough along to do anything about configuring PHP. Bob Demers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL
He is on Win32, probably Win98 Regards, Jakob Might also help if he would specify the O/S ... - Original Message - From: Martin Gainty [EMAIL PROTECTED] To: Bob Demers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 01, 2003 1:12 PM Subject: Re: Can't start MySQL Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: Bob Demers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL I've clearly done something worng but, novice that I am, I'm at a dead end to figuring out just where I've gone astray. I've scoured the help files and faqs locally and online but can't seem to find anything I recognize as relevant. Perhaps someone can point me in the right direction. Have installed (actually twice) MySQL-PHP-Apache from CD included with Sams Teach Yourself PHP, MySQL and Apache in 24 Hours on Windows 98. Machine: Compaq Presario 5610, 192MBram Problem:#1 When I attempt to start Apache I get The system cannot find the file specified What file would that be? Service Status is dev4_423 (whatever that means). Problem #2: When clicking on MySQL stoplight icon in startup I get the MySql admin window AND a blank DOS window (MySqld)the cursor slows to a useless crawl and properties shows only an entry in Cmd Line = c:\windows\system\conagent.exe. Cursor doesn't return to normal speed until I close the MSDOS window, which also closes MySQL. Haven't got far enough along to do anything about configuring PHP. Bob Demers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can't start MySQL
Herewith is the ERROR LOG FROM \apache group\apache2\logs per Marty's suggestion. Special note: The domain name and server name default to that of my ISP. Can't understand why that would be since the installation is entirely local. ERROR LOG [Mon Sep 01 11:47:26 2003] [notice] Parent: Created child process -127250659 [Mon Sep 01 11:47:27 2003] [notice] Child -127250659: Child process is running [Mon Sep 01 11:47:27 2003] [notice] Child -127250659: Acquired the start mutex. [Mon Sep 01 11:47:27 2003] [notice] Child -127250659: Starting 250 worker threads. [Mon Sep 01 11:49:34 2003] [notice] Parent: Created child process -131072595 [Mon Sep 01 11:49:35 2003] [notice] Child -131072595: Child process is running [Mon Sep 01 11:49:35 2003] [notice] Child -131072595: Acquired the start mutex. [Mon Sep 01 11:49:35 2003] [notice] Child -131072595: Starting 250 worker threads. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Monday, September 01, 2003 2:13 PM To: Bob Demers; Subject: Re: Can't start MySQL Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: Bob Demers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL I've clearly done something wrong but, novice that I am, I'm at a dead end to figuring out just where I've gone astray. I've scoured the help files and faqs locally and online but can't seem to find anything I recognize as relevant. Perhaps someone can point me in the right direction. Have installed (actually twice) MySQL-PHP-Apache from CD included with Sams Teach Yourself PHP, MySQL and Apache in 24 Hours on Windows 98. Machine: Compaq Presario 5610, 192MBram Problem:#1 When I attempt to start Apache I get The system cannot find the file specified What file would that be? Service Status is dev4_423 (whatever that means). Problem #2: When clicking on MySQL stoplight icon in startup I get the MySql admin window AND a blank DOS window (MySqld-opt)which doesn't respond to the keyboardthe cursor slows to a useless crawl and properties shows only an entry in Cmd Line = c:\windows\system\conagent.exe. Cursor doesn't return to normal speed until I close the MSDOS window, which also closes MySQL. Haven't got far enough along to do anything about configuring PHP. Bob Demers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Todd and Guys, Your advice helped me too. I think either Apple screwed up when set up /tmp directory to be writeable by root only or since MySQL package has bug or shall be installed ONLY as root user. - Nicos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Nicos, Actually, MySQL should be installed by an administrator, but it should be executed by root, which would permit the writing to the tmp dir. Meaning everytime you kick off MySQL server, you'll need to do so as root. This is usually how I dow it: cd /usr/local/mysql sudo echo sudo ./bin/mysqld_safe --user=mysql [Note: You'll need to do this on an account with administrator access. When you type sudo echo, you'll need to type your OS X user password.] My boy Marc has a slam'in site for MySQL on OS X http://www.entropy.ch. Since MySQL nor Apple have a startup script for MySQL (to kick off the DB at boot), I use the one he's generated - see his site for more details. Regards, Adam On Thursday, August 7, 2003, at 10:54 PM, Nicos Kekchidis wrote: Todd and Guys, Your advice helped me too. I think either Apple screwed up when set up /tmp directory to be writeable by root only or since MySQL package has bug or shall be installed ONLY as root user. - Nicos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
If you did not shutdown the server prior to the upgrade, you could have left mysqld running, even after its socket was removed. Use ps to see if mysqld is still running, and kill it if necessary. Todd O'Bryan wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Check your permissions in /usr/local/mysql, I think the package leaves some incorrectly set. The exact problem is usually logged in /usr/local/mysql/data/hostname.err this file is invaluable Cheers! --s On Wednesday, July 2, 2003, at 09:24 AM, Todd O'Bryan wrote: OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't start mysql
David Kruszewski [EMAIL PROTECTED] wrote: Description: 1: running safe_mysqld it just stops at end of statement bash-2.05a# safe_mysqld Starting mysqld daemon with databases from /var/lib/mysql 030618 10:09:11 mysqld ended You can find what was wrong in the error log file (/var/lib/mysql/host_name.err). 2:running mysql -u root bash-2.05a# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/m ysql.sock' (111) bash-2.05a# ls -l /var/run/mysql/mysql.sock srwxrwxrwx1 mysqlmysql 0 Jun 18 10:09 /var/run/mysql/mysql.soc k Because MySQL server is not running. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysql
John, I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box using RPMs. The install seems to go well, but the log file contains: mysqld: Can't find file: './mysql/host.frm' From the docs, I understand this happens because I haven't set up the grant tables, but how can I do that if I can't start the database? Seems like a Catch-22 situation! All you have to do is set up the grant tables. You don't need a running MySQL server for this. You can find details here: http://www.mysql.com/doc/en/Post-installation.html If you just want to see your MySQL server running, you can start it like this: mysqld --skip-grant-tables But be warned. This is VERY insecure. Everyone will have access to your server without username and password. You can try yourself: mysql should give you an unrestricted mysql prompt (i.e. you can do whatever you want; drop databases, create tables, etc.). Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - 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
hi have you run mysql_install_db ? this sets up the mysql database initially Peter -Original Message- From: John Almberg [mailto:[EMAIL PROTECTED] Sent: 01 March 2003 20:44 To: [EMAIL PROTECTED] Subject: Can't start mysql I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box using RPMs. The install seems to go well, but the log file contains: mysqld: Can't find file: './mysql/host.frm' From the docs, I understand this happens because I haven't set up the grant tables, but how can I do that if I can't start the database? Seems like a Catch-22 situation! When I try to start MySql manually, using safe_mysqld, I get the same error in the error log. I'm sure I'm missing something simple, but I've been banging my head against this for awhile and can't figure it out. Any help much appreciated. Brgds: John -- Identry, LLC Northport, NY 11768 Ph: 631.754.8440 Fx: 631.980.4262 Em: [EMAIL PROTECTED] Member: Long Island Web Developers Guild Visit us at: www.identry.com Take control of your Web site - 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 start MySQL server
Hi! It seems you still have an old mysqld running. Check this: ps ax | grep mysqld and kill it if it does really present. duo fu wrote: Dear all: I have just removed an old version of mysql and install MySQL3.23.51 (tarball). After installation, I tried to start the server: % bin/safe_mysqld It can't be started. Message stored in file: /mysql/var/hostname.err asking Do you already have another mysqld server running on port: 3306? Aborting. I have tried hours to install it but I just could not succeed. Could anyone kindly help me out? THank you very much for your help! Frank _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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-service on Win XP
Hi Sabine (again ;-) ) I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html This could be problems w/ your path or your my.ini (overwritten my mysqladmin). If it won't start anyway, put mysqladmin.exe to your autostart. regards, (Grüße) Jan - Original Message - From: Sabine Richter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 4:25 PM Subject: Can't start mysql-service on Win XP Hello, for the first time I installed Mysql 3.23.49 on win XP professional. I installed it with admin privileges, installed the service -so far everything seemed to be ok. But when I tried to start the service, it didn't start (failure number 1067). I don't have any idea, what that failure number means, where to find something about it (who raised it: win or mysql?) and where to search for the reasons. I already searched for this failure in the mysql ref manual and in the win help system. I'll be grateful for any tip! Thanks in advance Sabine Richter - 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 start mysql-service on Win XP
Hi Jan, I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html I did! This could be problems w/ your path or your my.ini (overwritten my mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote basedir=mysql -without the last backslash! Can that be a reason? And how to change it? The same for datadir! telnet localhost 3306 says: Verbindungsaufbau zu localhost... Es konnte keine Verbindung mit dem Host hergestellt werden, auf Port 3306. Es konnte nicht, da der Zielcomputer die Verbindung verweigerte. (perhaps incorrect translation: connection to localhost on port 3306 wasn't possible. The computer didn't allow the connection) If it won't start anyway, put mysqladmin.exe to your autostart. I don't understand that. I thought that mysqladmin requires an already started server service. Isn't that right? However, I tried start mysqladmin/host=localhost It says that it needs mysqld running and tells me to check it with telnet. What I did. See above. I have no debug-version of mysqld-nt. Any other idea?? best regards Sabine - 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-service on Win XP
If a trailing slash were required, mine would not work: [mysqld] basedir=d:/mysql datadir=d:/mysql/data language=d:/mysql/share/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M - Original Message - From: Sabine Richter [EMAIL PROTECTED] To: Jan Peuker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:31 AM Subject: Re: Can't start mysql-service on Win XP Hi Jan, I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html I did! This could be problems w/ your path or your my.ini (overwritten my mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote basedir=mysql -without the last backslash! Can that be a reason? And how to change it? The same for datadir! telnet localhost 3306 says: Verbindungsaufbau zu localhost... Es konnte keine Verbindung mit dem Host hergestellt werden, auf Port 3306. Es konnte nicht, da der Zielcomputer die Verbindung verweigerte. (perhaps incorrect translation: connection to localhost on port 3306 wasn't possible. The computer didn't allow the connection) If it won't start anyway, put mysqladmin.exe to your autostart. I don't understand that. I thought that mysqladmin requires an already started server service. Isn't that right? However, I tried start mysqladmin/host=localhost It says that it needs mysqld running and tells me to check it with telnet. What I did. See above. I have no debug-version of mysqld-nt. Any other idea?? best regards Sabine - 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 start MySQL,please help......
Hi,Sir: I found the message shows that: --- 04 01:13:40 mysqld started ^G/usr/local/mysql/libexec/mysqld: File './host-bin.1' not found (Errcode: 13) 04 1:13:40 Could not use host-bin for logging (error 13) InnoDB: Warning: operating system error number 13 in a file operation. InnoDB: Cannot continue operation. 04 01:13:41 mysqld ended Could anyone help ? thanks Sounds like a file permission problem. Does the user running mysqld have the correct permissions on the directory containing host-bin.1? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
Dear Ling, Thank you so much. Can I ask why? you have to keep in mind that the mysqld (that's the MySQL server, or the daemon) is the only one that must have read/write access to datadir (the database directories). On your machine, /var/lib/mysql/ is datadir, and mysqld will run as user mysql by default. If mysql is the owner of the datadir directories and files, mysqld will have read/write access to your databases and tables, otherwise it has not. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Ling Wang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 3:51 AM Subject: 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 - 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 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
on 8/6/01 10:13 PM, Trond Eivind Glomsrød at [EMAIL PROTECTED] wrote: 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 snip What you've done (and too many others, where do they get this idea?) um, perhaps from the INSTALL-SOURCE notes that come with the mysql distribution quote from the aforementioned INSTALL-SOURCE After everything has been unpacked and installed, you should initialize and test your distribution. You can start the *MySQL* server with the following command: shell bin/safe_mysqld --user=mysql /quote i believe it's the way most of the world does it. 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. -- mike cullerton - 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
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] - 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
Dear Wang, /usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13) It's tricky, but you have to install the two databases (mysql and test) shipped along with the MySQL distribution. Here's that part: shell ./scripts/mysql_install_db And here's the manual part: http://www.mysql.com/doc/P/o/Post-installation.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Ling Wang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 4:02 AM Subject: 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 - 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
mike cullerton [EMAIL PROTECTED] writes: on 8/6/01 10:13 PM, Trond Eivind Glomsrød at [EMAIL PROTECTED] wrote: 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 snip What you've done (and too many others, where do they get this idea?) um, perhaps from the INSTALL-SOURCE notes that come with the mysql distribution But you didn't install from source. It comes with a Linux distribution, and is started as other services there (same way as the LSB standard specifies). shell bin/safe_mysqld --user=mysql If that is done, and mysql_install_db is run as root, I don't see that working either. -- 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
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
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
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
Re: Can't start MYSQL on Linux
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
Re: can't start mysql
foxwoo wrote: Dear, I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but one day the our DNS had some problem, after solve the DNS problems, we found we cannot restart our mysql. The error message is "mysqld daemon ended". The host.err is as below: mysqld started on Wed Mar 7 00:46:55 CST 2001 010307 0:46:55 Can't start server: Bind on TCP/IP port: Address already in use 010307 0:46:55 Do you already have another mysqld server running on port: 3306 ? 010307 0:46:55 Aborting mysqld ended on Wed Mar 7 00:46:55 CST 2001 mysqld started on Wed Mar 7 00:51:59 CST 2001 010307 0:51:59 Can't start server: Bind on TCP/IP port: Address already in use 010307 0:51:59 Do you already have another mysqld server running on port: 3306 ? 010307 0:51:59 Aborting mysqld ended on Wed Mar 7 00:51:59 CST 2001 How can I check wheather my server have other mysql server running, but I only need to run ONE mysql, may you help me pls. Fox. ps -ef | grep mysql This will show you all running commands that contain the string 'mysql'. Kill any running servers, and restart. - 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