Jump to content

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/1120-newbie-needs-pro-help/
Share on other sites

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.

Link to comment
https://forums.phpfreaks.com/topic/1120-newbie-needs-pro-help/#findComment-3812
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.