Problem connecting to remote database

  • caleno76

    (@caleno76)


    5 years, 6 months ago

    Hello,

    I am trying to add a remote database connection but have been unsuccessful so far.

    The MySQL database is hosted on the same hosting account as my wordpress website.

    The database name is cycadlis_worldlist, but in the data explorer it is prefixed by rdb:, so it turns into rdb:cycadlis_worldlist

    For MySQL host I have tried both ‘localhost’, and an ip address provided by my webhost’s ‘remoteMySQL’ app in CPANEL as an ‘Access Host’. This is 66.198.240.10.

    For username, I put my MySQL username, which is in this format cycadlist_username

    For password, the password for this database

    For port, 3306 which is the port used for mysql as shown in PHPMyAdmin.

    For MySQL schema, I’m not quite sure. If I leave it blank, it says ‘preparing connection’ and then does not advance beyond that. If I put the database name there (cycadlis_worldlist) or information_schema, then I get the error message ‘Remote database connection invalid’.

    This should be very straightforward, but I am obviously doing something wrong. If anyone could provide some advice as how to move forward it would be much appreciated.

    thanks,
    Michael

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi Michael,

    Is your MySQL hosted on the same plysical server? If so, you can connecto to ip 127.0.0.1. If not, use your public server ip.

    Make sure your username is accessible from the ip adress you are connecting from. If the database is on the same physical server, this would be something like: ‘cycadlist_username’@’127.0.0.1’ or ‘cycadlist_username’@’localhost’. If you are connecting from another physical server, you need to add the ip of the server you are connecting from.

    You must enter a valid MySQL schema name. The plugin will not be able to connect without it. This is the name of the database to witch you want to connect.

    Does this help?
    Peter

    Thread Starter caleno76

    (@caleno76)

    5 years, 6 months ago

    Hi Peter,

    I greatly appreciate you taking the time to look into this issue.

    I had a chat with my webhost’s support team and they confirm that all the settings I am using are correct.

    Using either 127.0.0.1 or ‘localhost’ should be fine, the username is fine (cycadlis_caleno) and doesn’t require the @ with the IP, and the database name (put into the MYSQL schema field) is correct: cycadlis_worldlist.

    He suggested removing the rdb: from the Database name field ‘since it’s already defined as a remote connection’, but I realize this isn’t an option in the plugin. This shouldn’t matter, right? This is the name the plugin uses for the database (with the rdb prefix) and I don’t actually have to rename my database with that prefix, correct?

    Any other ideas of what I can try? I still get the same error message.

    thanks!

    Michael

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi Michael,

    The rdb prefix is used within the plugin to identify the remote database only. The plugin uses the MySQL Schema value to connect to the database.

    Can you give me temporarily access to your server? You can use the contactform on the plugin website to send me a message. I’ll reply with my private email, which can use to send the necessary information.

    Thanks,
    Peter

    Thread Starter caleno76

    (@caleno76)

    5 years, 6 months ago

    Hi Peter,

    Appreciate your willingness to help, I will contact you privately via the contact form.

    regards,
    Michael

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Problem connecting to remote database’ is closed to new replies.