Page 1 of 1

Can't run MySQL “another mysqld server running on port 3306

PostPosted: 29. March 2019 09:40
by Tilk
Hello everyone! I'm new to Linux, and installed it first time, few days ago. I installed a XAMPP, but MySQL don't running from XAMPP manager.

Here is from log file

Code: Select all
2019-03-22 13:57:39 140241894139712 [Note] Server socket created on IP: '::'.
2019-03-22 13:57:39 140241894139712 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-03-22 13:57:39 140241894139712 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-03-22 13:57:39 140241894139712 [ERROR] Aborting


Then I go to conf file, and change port on 3307 in few places

Code: Select all
# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port        =3307
socket      =/opt/lampp/var/mysql/mysql.sock

...

Code: Select all
# The MySQL server
[mysqld]
user=mysql
port=3307
socket      =/opt/lampp/var/mysql/mysql.sock
key_buffer=16M


And also I change port on 3307 in XAMPP manager config window.

But there is 3306 in log anyway.

Looks like it was another MySQL server installed (may be I installed it before XAMPP when tryed another ways to install local webserver or it was intalles with my Linux Mint)

It was strings another strings at command "whereis mysql". After I delete mysql via terminal, there is only "opt" folder. But I 3306 is still busy.

Code: Select all
~$ whereis mysql
mysql: /opt/lampp/bin/mysql /opt/lampp/bin/mysql.server