Can't connect MySQL server

BigBearYouTube
1

Can anyone help me with this problem?

mysql -h 192.168.100.23 -P 3306 -u bigbear -p
Enter password:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘192.168.100.23:3306’ (111)

2

Did you change the credentials after starting the container?

1 Like
3

I’ve got a short checklist to rule out the simpler causes:

  1. Make sure the machine that hosts the mysql server and the machine connecting to it are on the same vlan
  2. Double check the username and password is correct. If you are using casaos, there are sometimes multiple tabs under the settings menu for containers. Double check that the mysql login info is the same under each tab. For example, Authentic has multiple tabs. One controls the settings for the Authentic frontend, and there is another for the database. Both tabs include mysql login data, and they have to match or it won’t work.
  3. Reboot both machines. Don’t ask me why, but sometimes it just works. Hope this helps.
1 Like