How do I connect to my database using a program?

If you wish to administer your database from your own computer, via a program like navicat or cocoamysq, you will need to add an "access host" via the MySQL Database Icon in the cPanel.

To do that enter the IP address of the computer with the the SQL software into the access host box.

To find your ip address you can go to Looking Glass . Your default IPv4/IPv6 is visibile for whitelist.

Also make sure your username matches the username created in the MySQL database section of CPanel, and make sure you add the user to the database you want to access.

- CSpace Hostings / https://cspacehostings.com

  • 41 Utilizadores acharam útil
Esta resposta foi útil?

Artigos Relacionados

Do you allow remote MySQL access in your servers?

Yes, to manage your databases remotely you will need to add an "access host" via the MySQL...

Do you provide PostgresSQL for your accounts?

Yes. We do provide PostgresSQL interface for all cPanel users.- CSpace Hostings /...

Do you support MS SQL?

No, we do not support MS SQL.- CSpace Hostings / https://cspacehostings.com

How do I create a MySQL back-up?

1. First log in to your Cpanel 2. Click MySQL Databases 3. Click phpMyAdmin 4. Click Export...

How do I create an empty MySQL database?

1.First log in to your Cpanel 2.Click MySQLDatabases 3.Create a user by typing any username and...

Powered by WHMCompleteSolution