MySQL Bugs: #38482: I have two MySQL community servers on single Linux machine on diff ports

Bug #38482	I have two MySQL community servers on single Linux machine on diff ports
Submitted:	31 Jul 2008 10:36	Modified:	31 Jul 2008 12:03
Reporter:	srinivas rao	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	MySQL 5.0 community server	OS:	Linux (centos5)
Assigned to:		CPU Architecture:	Any
Tags:	I want to remove on port 3306(not working) and working 3307

Description:
80734 14:02:35  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080731 14:02:35  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080731 14:02:35  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080731 14:02:35  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080731 14:02:35  InnoDB: Started; log sequence number 0 0
080731 14:02:35 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
080731 14:02:35 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080731 14:02:35 [ERROR] Aborting

080731 14:02:35  InnoDB: Starting shutdown...
080731 14:02:38  InnoDB: Shutdown completed; log sequence number 0 43655
080731 14:02:38 [Note] /usr/libexec/mysqld: Shutdown complete

080731 14:02:38  mysqld ended

080731 14:25:36  mysqld started
080731 14:25:36  InnoDB: Started; log sequence number 0 43655
080731 14:25:36 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
080731 14:25:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080731 14:25:36 [ERROR] Aborting

080731 14:25:36  InnoDB: Starting shutdown...
080731 14:25:38  InnoDB: Shutdown completed; log sequence number 0 43655
080731 14:25:38 [Note] /usr/libexec/mysqld: Shutdown complete

080731 14:25:38  mysqld ended

080731 14:35:53  mysqld started
080731 14:35:53  InnoDB: Started; log sequence number 0 43655
080731 14:35:53 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
080731 14:35:53 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080731 14:35:53 [ERROR] Aborting

080731 14:35:53  InnoDB: Starting shutdown...
080731 14:35:56  InnoDB: Shutdown completed; log sequence number 0 43655
080731 14:35:56 [Note] /usr/libexec/mysqld: Shutdown complete

080731 14:35:56  mysqld ended

080731 14:39:10  mysqld started
080731 14:39:11  InnoDB: Started; log sequence number 0 43655
080731 14:39:11 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
"mysqld.log" 83L, 3774C

How to repeat:
how to connect with ODBC drivers with Mysql connectivity and i got a problem with ODBC set up in linux machine 2.6 kernel 

Suggested fix:
I want to remove on port 3306(not working) and working 3307
one MySQL server to be deleted how to be done 
with procedure

Many thanks for writing a bug report.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

You can kill your already running MySQL instance by using:
# kill -9 PID

or you can choose another port and socket for your new instance by editing your my.cnf:

[mysqld]
port = 3307
socket = /tmp/mysql_5.0_new_instance.sock
[client]
port = 3307
socket = /tmp/mysql_5.0_new_instance.sock

For more informations read:

http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-command-line-servers.html

Thank you for your interest in MySQL.