How to add my IP address to Access List and allow direct MySQL connection?

Why do you need to add your IP to the list of allowed hosts?

Once configuring Database connection, you may see the following error:

SQL error "access denied for user '....." @'........" (using password YES)

You will see username that you're trying to insert while connecting to your database and your local IP (the IP of your computer that you have Store Managerr installed). The error says that user that we have specified cannot connect to our database from our local IP.

If you're absolutely sure that the username and password is correct, it means that your hosting is blocking all external IPs from being connected to your database. To fix it you need to sign in your Hosting Control Panel and add the IP.

How to add IP if I do not have hosting control panel

If you're using shared hosting, most likely you do not have Hosting Control panel where you can handle those things. It means that you should contact your hosting company and ask them to do the job for you.

Just retype the IP that you can see in your error message and ask your hosting to "Add this ip to your access lists to be able to connect to your MySQL database".

How to add IP if I have cPanel

If you hosting company offers you some control panel, most likely you can grant access on your own. Let us review such tool as cPanel - one of most popular and widely used management applications.

Login your hosting control panel

There's no single way to open cPanel but often you can just add "/cpanel" to your website link to get into. So type /cpanel in browser's address bar and press Enter key.

To get inside you have to type login and password provided by your hosting company. Often it corresponds to your FTP access details provided by your hosting, so you can try to insert your FTP settings here. In case you do not know your access details, contact your developer or hosting company to get access.

2. Find the Remote Database Access in the list of services

3. Click on "Remote Database Access" and you will see Access List section.

4. Type IP address of your home/office computer and click "Add Host" button

5. You will see page indicating successful operation and your IP in the list

6. Connect your Store Manager application
Use test connection. Once the connection is successful, connect to your store data and start using Store Manager features.

Note: Besides cPanel there are several other management applications which may be used by your hosting. Take this short explanation as general "how to" guide, details shown here may differ from yours.