Re: OS X Installation and Setup
At 3:47 -0500 22-09-2003, Andy Callan wrote: I tried to kill 3306 and it claimed there was no such process I have a GUI fronted called MacSQL already installed that i was using before when I could only edit test_... db's in mySQL but I doubt that could be causing a problem since it didn't for PostgreSQL so i really don't know what is going on with this. You can not kill 3306. It is the TCP port. You have to try to figure out what process is listening (netstat command) and then kill it. You can also look at ps to find Mysql process. Last: Try to execute mysqladmin --shutdown and then relaunch mysql Santino PS: Disable automatic startup of MySql 3.xx from Application Utility MySqlManager. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
After successfully setting up PostgreSQL and better understanding the user and permission problems I attempted to reinstall mySQL which had been running but b/c of permission stuff i could only access databases that began with test. I installed the OS X bundle with Startup module and then got the server up and running no problem but as soon as I tried to get the mysqladmin i got the infamous ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) later i tried again and it seems to have gotten worse, i looked into the .err file after the server wouldn't start up after i aborted the first time and this was what it had: 030922 16:37:52 mysqld started 030922 16:37:53 Can't start server: Bind on TCP/IP port: Address already in use 030922 16:37:53 Do you already have another mysqld server running on port: 3306 ? 030922 16:37:53 Aborting I tried to kill 3306 and it claimed there was no such process I have a GUI fronted called MacSQL already installed that i was using before when I could only edit test_... db's in mySQL but I doubt that could be causing a problem since it didn't for PostgreSQL so i really don't know what is going on with this. Sorry to be bothering the list again but i followed the directions the best I could and this really shouldn't be this problematic, hopefully if i can get it work I can help clarify the documentation with my experiences. Thanks again -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
Are you trying to run mysqld or mysqld_safe (or safe_mysqld)? If you are going to start mysql manually, you should be in the /usr/local/mysql directory and then type the following: sudo ./bin/mysqld_safe mysqld_safe is actually just a shell script that will launch and monitor mysqld to make sure it stays running. mysqld needs to run under the mysql account (or whatever account you created for it to run under). The script handles launching mysqld under the correct account. That's why you need to use sudo, so it can switch accounts from root to run the process. The at the end just tells the scripts to run in the background so that you get control of the terminal back and can even close your terminal session without causing the script to exit. The only time I ever try to run mysqld directly is if I'm having trouble getting things to launch, because then it will show the errors in the terminal session instead of logging them. But you do need to be one level up other mysqld won't be able to figure out the paths to all the supporting files. sudo ./bin/mysqld Should tell you what the problem is. There is a lot of great stuff on OS X on Marc Liyanage's website. He even has instructions on how to configure you computer to launch MySQL at startup. http://www.entropy.ch/software/macosx/ On Saturday, September 13, 2003, at 02:54 AM, Andy Callan wrote: Does the installation of the PKG itself finish successful? No problems installing the files, the PKG works fine and everything is as it should be in /usr/local/ It's essential to start up mysqld before you continue with using mysqladmin. When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 15 Sep 2003, Brent Baisley wrote: Are you trying to run mysqld or mysqld_safe (or safe_mysqld)? If you are going to start mysql manually, you should be in the /usr/local/mysql directory and then type the following: sudo ./bin/mysqld_safe Correct. There is a lot of great stuff on OS X on Marc Liyanage's website. He even has instructions on how to configure you computer to launch MySQL at startup. http://www.entropy.ch/software/macosx/ Actually, starting with MySQL 4.0.15 you can simply use the StartupItem that is bundled with the MySQL PKG in the Disk Image! Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/Zc85SVDhKrJykfIRAqQDAJ9P1JE6+FUjS2B6jPXUstgUYwjb2wCdHAuq uk6SrLqUhm1fqTxk++eR3gg= =gPqq -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
Does the installation of the PKG itself finish successful? No problems installing the files, the PKG works fine and everything is as it should be in /usr/local/ It's essential to start up mysqld before you continue with using mysqladmin. When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Cheers, Andy -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
Hi, It could be a permission problem on /tmp and/or mysql data directory. OR You have not mysql internal tables (host, user, etc) in data/mysql. Try to open a file named (yourhost).err in data directory and see why mysql ended. Santino Does the installation of the PKG itself finish successful? No problems installing the files, the PKG works fine and everything is as it should be in /usr/local/ It's essential to start up mysqld before you continue with using mysqladmin. When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Cheers, Andy -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- 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: OS X Installation and Setup
Andy Callan wrote: When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Find the error log (which will be called machine-name.err and will be in your data directory) and see what it says. It generally prints an error that pretty much tells you what you need to do. I don't know where the package installer puts the data directory on OS X, but it might by /usr/local/mysql/data --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 11 Sep 2003, Andy Callan wrote: I can log in as 'root' if need be. After the install I get errors like: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! MySQL seems to be installed (as you can call mysqladmin, but the MySQL server itself does not seem to be running. Did you follow the instructions in the README? The MySQL server needs to be started first. I've tried installing, deleting, and reinstalling several times to try setting it up in different environments (e.g. as myself, logged in as root, autheticating as root when i'm logged in as myself) without success. Does the installation of the PKG itself finish successful? I was almost there one time I think but could not figure out what the mysqladmin -u root -h 'hostname' password password wanted for hostname, now I presume I should type exactly 'localhost' --is that correct? If you enter the command as directed in the manual, you will notice that the hostname command is enclosed in backticks (`). This means that it will automatically take the output of the hostname command as the value for the hostname field. However, MySQL needs to be started before you can work with mysqladmin! Any assistance as to what user I should be logged in as and what the exact sequence of commands i should run to set up the package (including deleting previous install) would be great, many thanks in advance. I assume you installed the official MySQL PKG packages from mysql.com. Then the installation should have put the files in /usr/local/mysql. Try to follow the instructions given in the README or at http://www.mysql.com/doc/en/Mac_OS_X_installation.html It's essential to start up mysqld before you continue with using mysqladmin. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/YFNCSVDhKrJykfIRAr39AJ9gvkpAuDrV8haifjYk+UwYplD8ggCeL21g Ufu8sperzi2TNVYAdEXld4A= =v88B -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]