Question

What is the fix for MySQL server refuse to connect issue?

I’ve deployed a Laravel application on a CentOS droplet with MySQL. The issue is after I use Laravel tinker or use PHPMyAdmin, I get “Connection refused”. I have to restart MySQL server from SSH.

Any idea what’s the issue here? Thanks in advance.

Subscribe
Share

FYI, I did a tail on mysql logs when this happen.


2021-11-21T07:06:58.671269Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.26) starting as process 33039
2021-11-21T07:06:58.696453Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-11-21T07:06:59.605756Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-11-21T07:07:12.156123Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2021-11-21T07:07:12.163376Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2021-11-21T07:07:12.382972Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-11-21T07:07:12.383191Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-11-21T07:07:12.396101Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-11-21T07:07:12.396435Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-11-21T07:07:12.443710Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.26'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution.
2021-11-21T07:07:12.443811Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi there,

Does the MySQL service run fine after you restart it?

If so I could suggest a couple of things:

  • Follow the steps here on how to tweak MySQL/MariaDB Configuration for Increased Performance and Stability:

https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability

  • Check your system logs and MySQL logs to see what is causing MySQL to crash. You can find the logs at the /var/log directory.

As a side note, with all of the recent CentOS changes, I now personally use Ubuntu to host my Laravel applications. Along with this automation script that sets up the whole server for me:

https://www.digitalocean.com/community/tools/larasail

Let me know how it goes. Best, Bobby