Solved

Installing Mysql server in Home ..Do you already have another mysqld server running on port: 3306 ?

Posted on 2004-09-01
2
353 Views
Last Modified: 2013-12-15
With a good amount of help on this forumn I have been able to Install Mysql server on my home directory

/home/myName/mysql

But whenevr I run the mysqld command to run the server I get the following error
******************
40901 18:27:36  Can't start server: Bind on TCP/IP port: Address already in use
040901 18:27:36  Do you already have another mysqld server running on port: 3306 ?
040901 18:27:36  Aborting

**********************

Is this because of the fact that there is already a mysql server running on my main machine..how should I work around this problem so that I can access the mysql server in my home directory

Please note that I dont have root previalges

Thanks for your time
0
Comment
Question by:micro_learner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Assisted Solution

by:paullamhkg
paullamhkg earned 250 total points
ID: 11960209
yes mostly there is another mysql running in the same computer which your /home/myname installed. but there is way to run multiple mysql in same computer have a check here http://dev.mysql.com/doc/mysql/en/Multiple_servers.html

Actually www.mysql.com will have lots of info you can find for Mysql setting take some time and read their manual, you can download from mysql site.
0
 
LVL 17

Accepted Solution

by:
owensleftfoot earned 250 total points
ID: 11962371
If you only need local access to your own mysql server you can start it with --skip-networking to prevent it trying to open a remote access port, ie 3306.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The purpose of this article is to demonstrate how we can use conditional statements using Python.
Fine Tune your automatic Updates for Ubuntu / Debian
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question