Jump to content


Photo

Newbie needs Pro-help!


  • Please log in to reply
3 replies to this topic

#1 @lex

@lex
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 07 October 2003 - 07:58 AM

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

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 07 October 2003 - 09:54 AM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 @lex

@lex
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 07 October 2003 - 07:09 PM

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

#4 @lex

@lex
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 07 October 2003 - 07:52 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users