Results 1 to 10 of 11
-
11th Feb 2012, 05:34 PM #1OPMember
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.
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..
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
-
11th Feb 2012, 06:44 PM #2BannedWebsite's:
cityvillehelp.comPossible 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 localhostwhen 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
-
11th Feb 2012, 06:53 PM #3OPMember
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?
-
11th Feb 2012, 07:56 PM #4BannedWebsite's:
cityvillehelp.comtry to connect using
mysql workbench
-
12th Feb 2012, 02:37 AM #5MemberWebsite's:
solidservers.caHello 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
-
12th Feb 2012, 08:02 AM #6BannedWebsite's:
cityvillehelp.comsince 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
-
12th Feb 2012, 05:54 PM #7Respected 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...
-
12th Feb 2012, 06:51 PM #8OPMember
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 [~]#
-
12th Feb 2012, 07:48 PM #9MemberWebsite's:
solidservers.caHi 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
-
13th Feb 2012, 12:45 AM #10OPMember
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
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
How to enable remote connection to MySQL server
By jasoothai in forum Server ManagementReplies: 3Last Post: 25th Jun 2012, 06:08 PM -
NimcoHost.com: Remote MySQL, Perl Module, Site Sotware, Linux/Windows Hosting
By nimcohost in forum Shared Hosting OffersReplies: 0Last Post: 6th Mar 2012, 02:16 PM -
Bind remote Mysql user to Ip
By tawy in forum Server ManagementReplies: 6Last Post: 31st Aug 2011, 07:26 PM -
MYSQL Error while Import via MYSQL Dumper (Error
By desibreaker in forum Server ManagementReplies: 10Last Post: 5th Aug 2011, 07:26 PM -
Mysql help
By Xman in forum Server ManagementReplies: 5Last Post: 28th Sep 2009, 11:56 AM
themaCreator - create posts from...
Version 3.51 released. Open older version (or...