Issue start mysql even changed port number to 3307

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Issue start mysql even changed port number to 3307

Postby luckylam » 10. October 2013 05:04

HI guys I need your help...
I have two mysql installing, one has port 3306...
Now I change mysql xampp to 3307, I have ALREADY configured in my.ini file but it seems not working at all. What's the problem?
Any help would be appreciated!
Code: Select all
# password       = your_password
port            = 3307
socket          = "C:/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3307
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql"
tmpdir = "C:/xampp/tmp"
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M
max_allowed_packet = 1M
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"
luckylam
 
Posts: 3
Joined: 01. October 2012 03:58
Operating System: Window XP

Re: Issue start mysql even changed port number to 3307

Postby Altrea » 10. October 2013 05:43

How should we know that without any information?
Why do you think it is not working?
What is the response of the relating log files?
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Issue start mysql even changed port number to 3307

Postby luckylam » 10. October 2013 09:36

In control panel it said:
Code: Select all
MySQL Service detected with wrong path
3:33:40 PM  [mysql]    Change XAMPP MySQL and Control Panel settings or
3:33:40 PM  [mysql]    Uninstall/disable the other service manually first
3:33:40 PM  [mysql]    Found Path: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" MySQL
3:33:40 PM  [mysql]    Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql

in log file:
Code: Select all
130928  9:12:34 [Note] Plugin 'FEDERATED' is disabled.
130928  9:12:43 InnoDB: The InnoDB memory heap is disabled
130928  9:12:43 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130928  9:12:43 InnoDB: Compressed tables use zlib 1.2.3
130928  9:12:48 InnoDB: Initializing buffer pool, size = 16.0M
130928  9:12:48 InnoDB: Completed initialization of buffer pool
130928  9:13:10 InnoDB: highest supported file format is Barracuda.
130928  9:13:41  InnoDB: Waiting for the background threads to start
130928  9:13:42 InnoDB: 5.5.32 started; log sequence number 9367709
130928  9:13:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130928  9:13:42 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130928  9:13:42 [Note] Server socket created on IP: '0.0.0.0'.
130928  9:13:45 [Note] Event Scheduler: Loaded 0 events
130928  9:13:45 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.32'  socket: ''  port: 3306  MySQL Community Server (GPL)
130929  0:19:44 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

130929  0:19:46 [Note] Event Scheduler: Purging the queue. 0 events
130929  0:19:49  InnoDB: Starting shutdown...
130929  0:20:03  InnoDB: Shutdown completed; log sequence number 9367709
130929  0:20:05 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

130929 12:03:01 [Note] Plugin 'FEDERATED' is disabled.
130929 12:03:04 InnoDB: The InnoDB memory heap is disabled
130929 12:03:04 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130929 12:03:04 InnoDB: Compressed tables use zlib 1.2.3
130929 12:03:06 InnoDB: Initializing buffer pool, size = 16.0M
130929 12:03:06 InnoDB: Completed initialization of buffer pool
130929 12:03:07 InnoDB: highest supported file format is Barracuda.
130929 12:03:26  InnoDB: Waiting for the background threads to start
130929 12:03:27 InnoDB: 5.5.32 started; log sequence number 9367709
130929 12:03:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130929 12:03:27 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130929 12:03:27 [Note] Server socket created on IP: '0.0.0.0'.
130929 12:03:28 [Note] Event Scheduler: Loaded 0 events
130929 12:03:28 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.32'  socket: ''  port: 3306  MySQL Community Server (GPL)
130929 14:55:43 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

130929 14:55:46 [Note] Event Scheduler: Purging the queue. 0 events
130929 14:55:51  InnoDB: Starting shutdown...
130929 14:56:08  InnoDB: Shutdown completed; log sequence number 9367709
130929 14:56:10 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

I'm using win7, the lastest xampp
luckylam
 
Posts: 3
Joined: 01. October 2012 03:58
Operating System: Window XP

Re: Issue start mysql even changed port number to 3307

Postby Altrea » 10. October 2013 09:48

You have installed MySQL 5.0 as single component and registered as windows service.
XAMPP control panel can not separate this service from it's own applications.
So if you want to use the XAMPP MySQL with a different port, you need to specify the port and a new service name for MySQL both in the control panel configs too.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 100 guests