I get this error for directadmin

[grandm1961]

Hello, i get this error in cockpit for directadmin:

Can't Connect to Local MySQL Server Through Socket '/var/mysql/mysql.sock'​

Now i have changed the port from 3306 to a different port, might that be the issue? And if so how can i change it so it uses the new port that i am using???

 

[Richard G]

Now i have changed the port from 3306 to a different port, might that be the issue?

Exactly how did you do this?

I hope you set it as:
port=4060

under the [mysqld] part, right? The 4060 is just an example number, it should read the portnumber you want to use there.
Did you also restarted mysql/mariadb afterwards?

Be aware that you also have to change that port number in the client configs of clients connecting to mysql.
Like your applications connecting to the database.

Question: Why would you want to change to another port? Port 3306 is closed by default in the firewall and if you need remote access, there are other ways to secure this, for example to only allow certain ip's to connect to port 3306.