Search results
This command will safely shut down your existing MySQL running on port 3306 so that you can access the same port using the MySQL on xampp. This is used to work on both without conflicts or without having to uninstall the other application or without changing the port to 3307 in the my.ini file.
Port 3306 is open, even if I stop the windows-firewall, MySQL still can't access it. MySQL is running. I've run netstat firewall xxxxxx and get these results: 3306 TCP Enable MySQL Server. and this from netstat -a -n: TCP [::]:3306 [::]:0 LISTENING 0. (I don't understand the [::])
The issue is likely due to socket authentication being enabled for the root user by default when no password is set, during the upgrade to ubuntu 16.04. The solution is to revert back to native password authentication. You can do this by logging in to MySQL using socket authentication by doing:
2 sie 2022 · To correct this when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named pipe or Unix socket file. To find out where the socket file is, you can use this command:
7 mar 2019 · The most common socket error looks like this: Output. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) There are a few reasons why this error may occur, and a few potential ways to resolve it.
13 mar 2016 · You're trying to connect to the server via ssh but using the mysql port. The port you want is whatever your ssh server is listening on, typically 22, then localhost and 3306 for mysql hostname and port.
The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.
