Softaculous

Topic : Upgrade MySQL port 3306.

Posted By: adrianxw on August 8, 2024, 6:27 am

AMPPS says MySQL has an update. Trying to upgrade I have a flag against "port 3306" saying the specified port is already in use. I'm guessing the older MySQL is using it. Do I uninstall MySQL before I install it?

Posted By: adeshmrane on August 8, 2024, 10:17 am | Post: 1

To check which process is running on port 3306 execute below command in command prompt.
netstat -ano | findstr 3306
This will give you the PID of the process running on port 3306
To stop that process use the following command.
taskkill /F /PID 13896

replace 13896 with your PID.
you can disable autostart for that process from the services window.

Posted By: adrianxw on August 8, 2024, 12:21 pm | Post: 2

That command produces a four item list:

TCP 0.0.0.0:3306 0.0.0.0.0 Listening 2120
TCP 0.0.0.0.33060 0.0.0.0.0 Listening 2120
TCP [::]:3306 [::]:0 Listening 2120
TCP [:

:33060 [::]:0 Listening 2120

Posted By: adeshmrane on August 8, 2024, 12:29 pm | Post: 3

2120 is the PID of the process running port 3306

you can kill that process using the commandtaskkill /F /PID 2120

also, you can check which process running using the task manager Open Task Manager and go to the services tab
check the process name for PID 2120

Edited by adeshmrane : August 8, 2024, 12:31 pm

Posted By: adrianxw on August 8, 2024, 1:28 pm | Post: 4

2120 appears and goes again quickly, it said something like "Group Policy Client".

Posted By: adeshmrane on August 9, 2024, 6:04 am | Post: 5

Not understanding what appears and goes again quickly means, the PID of a process changes every time the system reboots so check the PID just before you stop it.

Please share screenshots or more details for a better understanding of the issue

You can also open ticket for faster resolution of the issue.

Posted By: adrianxw on August 9, 2024, 6:41 am | Post: 6

Look at the list, the item is present, wait five minutes, look at the list, it is no longer there. Not rocket science. Forget it. The little window continues to say update available, but the product continues to do all I seem to need it to do. End of story, I thought a couple of easy actions would solve a problem I did not have.

Posted By: adeshmrane on August 9, 2024, 7:19 am | Post: 7

Please share the output of the following command by executing it in command prompt

"E:\Ampps\mysql\bin\mysqld.exe" --standalone --console

Please change E:\Ampps with your installation path.

Posted By: adrianxw on August 9, 2024, 12:42 pm | Post: 8

I am trying to do this, but am having trouble finding the back slash character! There are two keys showing it, but they don't print it, neither raw, shift, alt or alt gr.

Posted By: adeshmrane on August 12, 2024, 9:30 am | Post: 9

You can also drag and drop exe to the command prompt this will add path to command prompt terminal.
Go to Ampps installation folder then go to mysql folder and look for mysqld.exe file and drag that file to terminal.
then add " --standalone --console " to the line and hit enter

Posted By: adrianxw on August 12, 2024, 2:06 pm | Post: 10

2024-08-12T14:03:07.010079Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-08-12T14:03:07.010148Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe (mysqld 8.0.31) starting as process 27556
2024-08-12T14:03:07.059900Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-12T14:03:07.682760Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-08-12T14:03:08.563628Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-08-12T14:03:08.563785Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-08-12T14:03:08.674873Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2024-08-12T14:03:08.675061Z 0 [System] [MY-010931] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe: ready for connections. Version: '8.0.31' socket: '' port: 3306 MySQL Community Server - GPL.
Err, I think. It has taken me a while to get round a few things.

Posted By: adeshmrane on August 14, 2024, 6:30 am | Post: 11

As per your output seems like there is no issue with starting the MySQL server.

Can you try starting MySQL from the AMPPS panel and let us know if it has started or if you are facing any issues?

You can also open a ticket for faster resolution of the issue.