Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


You are here: Index > AMPPS > General Support > Topic : Upgrade MySQL port 3306.



Threaded Mode | Print  

 Upgrade MySQL port 3306. (11 Replies, Read 6879 times)
adrianxw
Posted on # August 8, 2024, 6:27 am
Group: Member
Post Group: Newbie
Posts: 6
Status:
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?
IP: --   

Upgrade MySQL port 3306.
adeshmrane
Posted on # August 8, 2024, 10:17 am | Post: 1
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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.
IP: --   

Upgrade MySQL port 3306.
adrianxw
Posted on # August 8, 2024, 12:21 pm | Post: 2
Group: Member
Post Group: Newbie
Posts: 6
Status:
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

IP: --   

Upgrade MySQL port 3306.
adeshmrane
Posted on # August 8, 2024, 12:29 pm | Post: 3
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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
IP: --   

Upgrade MySQL port 3306.
adrianxw
Posted on # August 8, 2024, 1:28 pm | Post: 4
Group: Member
Post Group: Newbie
Posts: 6
Status:
2120 appears and goes again quickly, it said something like "Group Policy Client".
IP: --   

Upgrade MySQL port 3306.
adeshmrane
Posted on # August 9, 2024, 6:04 am | Post: 5
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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.
IP: --   

Upgrade MySQL port 3306.
adrianxw
Posted on # August 9, 2024, 6:41 am | Post: 6
Group: Member
Post Group: Newbie
Posts: 6
Status:
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.
IP: --   

Upgrade MySQL port 3306.
adeshmrane
Posted on # August 9, 2024, 7:19 am | Post: 7
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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.

IP: --   

Upgrade MySQL port 3306.
adrianxw
Posted on # August 9, 2024, 12:42 pm | Post: 8
Group: Member
Post Group: Newbie
Posts: 6
Status:
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.
IP: --   

Upgrade MySQL port 3306.
adeshmrane
Posted on # August 12, 2024, 9:30 am | Post: 9
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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
IP: --   

Upgrade MySQL port 3306.
adrianxw
Posted on # August 12, 2024, 2:06 pm | Post: 10
Group: Member
Post Group: Newbie
Posts: 6
Status:
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.
IP: --   

Upgrade MySQL port 3306.
adeshmrane
Posted on # August 14, 2024, 6:30 am | Post: 11
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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.
       
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
2 guests, 0 users.


All times are GMT. The time now is September 20, 2024, 3:38 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.309