Activity Stream
48,167 MEMBERS
64965 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1.     
    #1
    Member

    Default Remote MySQL

    Hello guys,

    I need to login in a application using my database details.
    But I cant enter because appears this error:
    Could not create database connection

    Someone told me to:
    Check to see if you need to add your ip address to your cpanel. It should be under your cpanel "Remote MySQL". Its pretty simple, just add your ip address and save the setting. Or if not cPanel then in the "WHM" control panel.

    Some hosts might require that you contact them to set it up.
    Most desktop applications of the sort require the remote ip to be set up before you can connect.
    I did:
    cPanel:
    http://i.imgur.com/gF693.png

    WHM:
    http://i.imgur.com/EuKjH.png

    And he said:
    Ask your host if they allow the connection through the firewall..
    Can someone help me solving this issue?
    How can I solve this through WHM?
    I use csf firewall.

    Thank you guys!
    Divvy Reviewed by Divvy on . Remote MySQL Hello guys, I need to login in a application using my database details. But I cant enter because appears this error: Could not create database connection Someone told me to: I did: Rating: 5

  2.   Sponsored Links

  3.     
    #2
    Banned
    Website's:
    cityvillehelp.com
    Possible Problems

    1) check if your firewall is blocking the port .. try to disable the firewall then try
    2) are you entering the correct database details ?
    3) try entering the main IP of your vps instead of domain name
    4) which software are you using ?? try mysql workbench (it's free)
    5) make sure you are not using localhost when connecting to the db from your pc (i am sure you won't be doing this mistake)

    6) are you entering your correct IP in the cpanel/whm ?? make sure it's not ur router's IP or the DHCP server's IP
    7) are you getting any error numbers ??
    8) have you checked your mysql server logs ? you may find many more details like why you are getting access denied error





  4.     
    #3
    Member
    1) I disabled the firewall but I continue with same problem.
    2) yes I am
    3) already tried that without success
    4) Im using PHPLD pagerank updater application
    5) any more suggestions?

  5.     
    #4
    Banned
    Website's:
    cityvillehelp.com
    try to connect using
    mysql workbench

  6.     
    #5
    Member
    Website's:
    solidservers.ca
    Hello there,

    Check your MySQL settings (/etc/my.cnf) to ensure that it is listening for an external connection. If you have disabled networking, you will have to comment that out, then restart the server. You can also run this command to see what it is listening on:

    Code: 
    netstat -anp | grep mysql
    Chris

  7.     
    #6
    Banned
    Website's:
    cityvillehelp.com
    since he has cpanel/whm installed

    that setting gets activated automatically as he will add the remote IP for accessing the database

    anyways .. you can check

  8.     
    #7
    Respected Member
    If this is not your vps/dedi than most likely even tho the option is there the host does not allow remote connection to the Mysql...

  9.     
    #8
    Member
    I have an dedicated server...

    Here is the result of the command given by SS-Chris:
    PHP Code: 
    root@server [~]# netstat -anp | grep mysql
    unix  2      ACC ]     STREAM     LISTENING     25846834 20992/mysqld        /                                                                             var/lib/mysql/mysql.sock
    unix  3      
    [ ]         STREAM     CONNECTED     247733406 20992/mysqld                                                                                     /var/lib/mysql/mysql.sock
    unix  3      
    [ ]         STREAM     CONNECTED     247084969 20992/mysqld                                                                                     /var/lib/mysql/mysql.sock
    root
    @server [~]

  10.     
    #9
    Member
    Website's:
    solidservers.ca
    Hi there,

    You are not listening on a TCP socket, otherwise it would list port 3306. You need to check your my.cnf file. Someone stated added it in WHM corrects this, however, I do not believe they are correct. Adding in WHM will allow the IP in the mysql hosts table, this does not change the daemon though, as it is driven by the my.cnf file.

    Chris

  11.     
    #10
    Member
    Thank you for your precious help SS-Chris

    I had "skip-networking" present in /etc/my.cnf. I commented that line out and restarted MySQL (/etc/init.d/mysql restart).

    Now is working fine

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to enable remote connection to MySQL server
    By jasoothai in forum Server Management
    Replies: 3
    Last Post: 25th Jun 2012, 06:08 PM
  2. Replies: 0
    Last Post: 6th Mar 2012, 02:16 PM
  3. Bind remote Mysql user to Ip
    By tawy in forum Server Management
    Replies: 6
    Last Post: 31st Aug 2011, 07:26 PM
  4. MYSQL Error while Import via MYSQL Dumper (Error
    By desibreaker in forum Server Management
    Replies: 10
    Last Post: 5th Aug 2011, 07:26 PM
  5. Mysql help
    By Xman in forum Server Management
    Replies: 5
    Last Post: 28th Sep 2009, 11:56 AM

Tags for this Thread

BE SOCIAL