Knowledgebase: MySQL
Do you allow remote MySQL access?
Posted by Arvand Sabetian (Import) on 26 December 2008 09:10 AM
|
|
Yes. On our ASP plans, you can simply connect to the mysql server on port 3306 with the correct credentials. For hostname, simply use your domain name or the hostname of the server you are on (included in the setup email) On our linux plans, you would need to add your IP (or the IP of the host connecting to the database) under the "Remote MySQL" section of the control panel. If your IP changes, you can input '%' which is a wildcard for any IP to have the ability to connect to your databases. If you have any issues with the above, please don't hesitate to contact support with your question(s). | |
|
Comments (26)
Greg Salisbury
23 September 2010 08:21 AM
Hi, Im trying to connecto to our MySQL Database using Navicat Lite but Im getting the following error message:
1130 - Host 'ip65-47-89-90.z89-47-65.customer.algx.net' is not allowed to connect to this MySQL server. I went to the Remote MySQL section of the control panel and inputted % under access hosts but that doesnt appear to work.
1130 - Host 'ip65-47-89-90.z89-47-65.customer.algx.net' is not allowed to connect to this MySQL server. I went to the Remote MySQL section of the control panel and inputted % under access hosts but that doesnt appear to work.
12 October 2010 06:21 PM
I would contact support. Often times, you may actually be connecting to the wrong server as % should resolve most issues like this.
Steven Henthorn
11 January 2011 07:18 PM
I do not know how to get to the Remote SQL setting of the WebsitePanel, I have the Personal Class Asp package, I get to the panel with cp.sazul.com
Please can you give me some assistance.
Thanks.
Please can you give me some assistance.
Thanks.
Arvand Sabetian
12 January 2011 06:27 AM
On Windows, there is no Remote SQL setting. It is automatically made available to you. Simply use your domain name as the hostname.
Warren Mayall
05 February 2011 03:11 AM
Having the same problem, what do you use as the name of the database. Can you simply give it a name or is there a set name to use?
Help!!
Help!!
Arvand Sabetian
11 March 2011 03:20 AM
The name would be outlined from within the control panel when you create the database.
Jo Green
12 March 2011 04:43 PM
if you use ftp you can look at the config.php and the settings are there
Javier Lerones
22 April 2011 06:58 AM
I am having the same problems, on Windows try to connect using my domain name as the hostname, my username and password. It returns: "Host 207-..... blah blah blah' is not allowed to connect to this MySQL server.
The control panel is returning an error when trying to create users or a database in MySQL 5, something about MySQL.Data dll missing?
The control panel is returning an error when trying to create users or a database in MySQL 5, something about MySQL.Data dll missing?
Arvand Sabetian
25 April 2011 07:54 AM
I believe this has already been resolved in the case of your server. If you are unable to create mysql user/databases then please contact support.
August Hogan
28 May 2011 02:04 AM
You say "On our ASP plans, you can simply connect to the mysql server on port 3306 with the correct credentials. " How? I'm trying to run Coldfusion Administrator.
Arvand Sabetian
02 June 2011 11:10 PM
You would need a MySQL client to connect remotely or through your code you would connect to localhost 3306 . If your coldfusion app is relying on a DSN, you would need to request to have it created through support.
Jeffrey
10 May 2012 08:19 AM
Why am I not allowed to change the User settings and grant some user other privleges on certain databases using MySQL workbench?
Michael Carr
27 September 2012 10:40 AM
I would suspect you are being limited by the permissions of the user you are connecting as.
Kashif Imran
09 February 2013 01:59 AM
I am not able to connect to MySql database remotely. I am using MySql Workbench.
Michael Carr
19 February 2013 08:35 AM
Your connection details are likely not correct. Please contact support and we will be glad to help you with that.
Paresh dudhat
12 April 2013 11:32 PM
I am not able to connect to my mysql database..
I have personal class asp pro account.
My hosting is on this server.. lotus.arvixe.com
I am getting error no 2003.. I have tried ip,domain name as host but none of them worked
I have personal class asp pro account.
My hosting is on this server.. lotus.arvixe.com
I am getting error no 2003.. I have tried ip,domain name as host but none of them worked
Michael Carr
15 April 2013 10:45 AM
Usually you will want to use "localhost" when setting up a script to connect locally. Remote connections can be made via the domain (assuming your DNS is correct) or the IP. If you continue to have problems please contact support and we will be happy to take a look for you.
Cereso Rodrigues
25 May 2013 09:31 AM
I have two problems: I can not access my mysql database from client local, for example, use mysql workbench and I can not access my mysql database from application in arvixe. Return following errors respectively: ERROR 2003 <HY000>: Can't connect to MySQL Server on 'rhsobr.com' and 'The server encountered an error processing the request. The exception message is 'An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.'. See server logs for more details. The exception stack trace is:'
Sicelo
20 November 2013 08:20 AM
Hi, do you allow remote mysql in your Linux business class plans or does it have to be dedicated class plans? I ask this because lots of hosting companies out there disable remote mysql in shared hosting and only allow in dedicated hosting.
Michael Carr
20 November 2013 10:38 AM
We allow remote MySQL access on all of our Linux based account.
Ranjana
26 November 2013 10:52 PM
I am building a window application in .net & want to connect to cpanel database.
As you said "On our ASP plans, you can simply connect to the mysql server on port
3306 with the correct
For hostname, simply use your domain name."
I am writting :
"SERVER=some_ServerName;DATABASE=some_DataBase;UID=some_UserID;PASSWORD=some_Password;"
but still it is giving an error:
"Authentication to host 'www.conffeexperience.in' for user 'coffee' using method 'mysql_native_password' failed with message access denied for user 'coffee'@'122.168.239.69'(usin password yes)"
now what to do? please help me, its urgent.
As you said "On our ASP plans, you can simply connect to the mysql server on port
3306 with the correct
For hostname, simply use your domain name."
I am writting :
"SERVER=some_ServerName;DATABASE=some_DataBase;UID=some_UserID;PASSWORD=some_Password;"
but still it is giving an error:
"Authentication to host 'www.conffeexperience.in' for user 'coffee' using method 'mysql_native_password' failed with message access denied for user 'coffee'@'122.168.239.69'(usin password yes)"
now what to do? please help me, its urgent.
Michael Carr
04 December 2013 07:35 PM
please open a support ticket and we will be glad to take a look
Erkan SOYBAYRAKTAR
18 February 2014 01:27 AM
MySql Connection Problem
This is My Code
<?php
$baglanti = mysql_connect('localhost','erkansyb_student','120967');
if(!$baglanti){
die('Baglanti hatasi : ' . mysql_error());
}
mysql_select_db("erkansyb_student",$baglanti);
$sonuc = mysql_query("SELECT * FROM student");
while($row = mysql_fetch_array($sonuc)){
echo $row['OgrenciAdiSoyadi'] . " " . $row['veliAdiSoyadi'] . '<br/>';
};
?>
Error Code
Access denied for user 'erkansyb_student'@'localhost' (using password: YES)
This is My Code
<?php
$baglanti = mysql_connect('localhost','erkansyb_student','120967');
if(!$baglanti){
die('Baglanti hatasi : ' . mysql_error());
}
mysql_select_db("erkansyb_student",$baglanti);
$sonuc = mysql_query("SELECT * FROM student");
while($row = mysql_fetch_array($sonuc)){
echo $row['OgrenciAdiSoyadi'] . " " . $row['veliAdiSoyadi'] . '<br/>';
};
?>
Error Code
Access denied for user 'erkansyb_student'@'localhost' (using password: YES)
Michael Carr
18 February 2014 08:26 AM
This reads like the access details are not correct. either the password or the DB user is not granted access to the database
erickson disla
16 April 2014 03:04 PM
Hi would like to know if I can help create a database mysql external data? softaculous can be in and defend me well in phpmyadmin, but for some reason when I create the database and try to start section gives me an error. thanks
Michael Carr
18 April 2014 09:16 AM
Not sure I fully understand, if you could create a support ticket and include your exact steps and the error message we will be able to help.