Newbie needs Pro-help!
Posted 07 October 2003 - 07:58 AM
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
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
Posted 07 October 2003 - 09:54 AM
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.
Posted 07 October 2003 - 07:09 PM
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:
Posted 07 October 2003 - 07:52 PM
There is no my.cnf at my system...
How do I find out about anither app that is using the port 3306?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users