Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

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

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
micro_learner
Asked:
micro_learner
2 Solutions
 
paullamhkgCommented:
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
 
owensleftfootCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now