How can I change mysql port number in xampp 1.8.1 portable?

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

How can I change mysql port number in xampp 1.8.1 portable?

Postby naveen » 20. February 2013 07:06

Hello all,

I have installed the latest version of xampp 1.8.1 portable version on my windows xp machine. The problem is there is already a version of app server running on my machine which is used for other pupose. I want to run both the app server and xampp portable on the same machine simultaniously.

To achieve this I have read the posts in the forum and succesfully changed the apache port number from 80 to 8080. And now apache is running on 8080 port.

Now I want to change the mysql port number from 3306 to 3307. Which files do I need to change to make this happen. I have gone through many forum posts and could not find the answer. Please help me.

Thanks,
Naveen
naveen
 
Posts: 3
Joined: 20. February 2013 06:25
Operating System: windows xp

Re: How can I change mysql port number in xampp 1.8.1 portab

Postby Altrea » 20. February 2013 12:12

Hi Naveen,

naveen wrote:I have gone through many forum posts and could not find the answer. Please help me.

http://www.apachefriends.org/en/xampp-windows.html#529 :!: :?:

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: How can I change mysql port number in xampp 1.8.1 portab

Postby naveen » 20. February 2013 14:53

Hello Altrea,

Thanks for your quick reply. I have already changed the port number from 3306 to 3307 in my.ini file and restarted the xampp control pannel. But I could not start the mysql service.

Please check the error log.
Code: Select all
7:17:09 PM  [mysql]    Attempting to start MySQL service...
7:17:09 PM  [mysql]    Executing "net start "mysql""
7:17:09 PM  [mysql]    Return code: 0
7:22:54 PM  [mysql]    Attempting to start MySQL service...
7:22:54 PM  [mysql]    Executing "net start "mysql""
7:22:54 PM  [mysql]    Return code: 0


Below is the my.ini file changes
Code: Select all
# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3307
socket          = "/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3307
socket = "/xampp/mysql/mysql.sock"
basedir = "/xampp/mysql"
tmpdir = "/xampp/tmp"
datadir = "/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
naveen
 
Posts: 3
Joined: 20. February 2013 06:25
Operating System: windows xp

Re: How can I change mysql port number in xampp 1.8.1 portab

Postby Altrea » 20. February 2013 15:26

Do you have already tried to unregister the MySQL service and start MySQL without it?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: How can I change mysql port number in xampp 1.8.1 portab

Postby naveen » 20. February 2013 15:52

unregister? I did'nt get you. I have appserver running with apache on port no 80 and mysql on 3306.

Now I want to run another instance of xampp with apache and mysql.
I have changed the apache port no to 8080 in xampp con fig files and its working fine.(Now two instances of apache are running one on 80 from appserv and the other from xampp on 8080)

I want to change the port no for mysql in xampp from 3306 to 3307 so that I can run 2 instances of mysql one on 3306 from appserv and 3307 from xampp.

Please help.
naveen
 
Posts: 3
Joined: 20. February 2013 06:25
Operating System: windows xp


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 2 guests