@lex Posted October 7, 2003 Share Posted October 7, 2003 Hi there. I am running my mysql database on a apachewebserver (Mac OS X) and worked with it for a couple of days. But then yesterday, as I started my server and wanted to connect to my own message board (for wich I created a database) it said it couldn\'t connect to the database. So I was running the terminal and treif to connect with my dp the ways I did befor, by just entering \'usr/local/bin/mysql\' But got he error message : ERROR 2002: Can\'t connect to local MySQL server through socket \'/tmp/mysql.sock\' (61) And in the error.log : 031006 07:51:06 mysqld started 031006 7:51:06 Can\'t start server: Bind on TCP/IP port: Address already in use 031006 7:51:06 Do you already have another mysqld server running on port: 3306 ? 031006 7:51:06 Aborting 031006 7:51:06 /usr/local/mysql/bin/mysqld: Shutdown Complete 031006 07:51:06 mysqld ended So it lookes like there is already a server or a db running??? I don\'t understand? How can I connect to the existing db, or reactivate it? What did I do wrong? As I mentioned before I am new to this and havn\'t much knowledge. Thx in advance @lex Quote Link to comment Share on other sites More sharing options...
shivabharat Posted October 7, 2003 Share Posted October 7, 2003 The log file has give you a clear description of what the problem is . You need to chnage the port as the port 3306 is used by another application. I am not very sure about changing port in MAC os. Locate the \"my.cnf\" file and change the port number to any unused number. If you arent sure of doing this you need to find which of your application is using the default port of mysql. Quote Link to comment Share on other sites More sharing options...
@lex Posted October 7, 2003 Author Share Posted October 7, 2003 Thx for your help. I will try this out. But how did that happen, that another app is usign the sql\'s default port? Maybe, because I didn\'t shut down the db? How do I find out what app uses port 3306? Many questions :shock: Thx @lex Quote Link to comment Share on other sites More sharing options...
@lex Posted October 7, 2003 Author Share Posted October 7, 2003 Allright, just tried to find the my.cnf but onlky found my:huge, _large, _medium and _small.cnf\'s wich are somekind of presets for the my.cnf. There is no my.cnf at my system... How do I find out about anither app that is using the port 3306? Thx @lex Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.