Connecting Aapanel's MySQL database to MySQL client workbench

achates

Hello there,

I'm trying to connect Aapanel's MySQL database to my locally installed MySQL workbench to manipulate the database that is managed by Aapanel. The current use case is this, But I'd like to connect it to a C# project as well. But it's not getting connected. Could someone please tell me any suggestions if I'm missing something? I used the IP: PORT and database username password. Tried the root password as well. but It didn't connect to the MySQL workbench. I'd like to have a step-by-step noticing point where I should give attention to make it work. I know it should get connected as I can access phpmyadmin publicly with the same username and password.

Thanks in Advance

aaP_demo1

achates
First of all, you need to check on your MySQL server Port Number at your mysqldManage

Next, go to Security > Firewall > Add New Port Rules & Complete the MySQL server port number

Then, go to your Database Management > Permission > Choose your permission method (I preferred Specified IP for my private access and prevent from unauthorized access) > Confirm

After, go to your MySQL Workbench App:

Add new MySQL Connection
Enter your connection name
Enter your server host's IP address, keep the port number on default
Enter your database username
Click on Store in Vault for keeping password to access later
Enter or Paste the copied database password
Click OK
Click on Test Connection

Finally, it can access to the MySQL Database Server. Click OK and leave the Setup New MySQL Connection.

Review the Saved MySQL Connection, click to connect to database

Done

achates

here's the issue, I'm on Aapanel version - 6.8.17,

could you please tell me any other checkpoint for which the exception delivery happening

aaPanel_Kern

aaP_demo1

aaPanel_Kern

If the server provider has a security group, it needs to be released. Note that it is not recommended to use port 3306.

aaP_demo1

achates

I have another server using an old aaPanel version 6.8.31
Clearly, I do not have any issues with the connection even though that server is using MariaDB 10.4.12

If possible, you need to check on

Database permission
Allow firewall on MySQL Server's port number both server and client machine

aaPanel_Kern

Hello, would you recommend if port 3306 is open for access? Is mysql running normally?

achates