 Is It Possible To Access The Mysql Remotely? |
|
|
|
|
  |
 Aug 24 2006, 06:17 PM
Post
#1
|
|
|
Privileged Member  Group: Members Posts: 629 Joined: 26-February 05 Member No.: 3,995  |
I like to experiment with a lot of things and I was thinking of making a sort of instant messenger in Python, but I want to let people have actual accounts so I need to be able to access the mySQL remotely. If that's not possible, are we allowed to run Python scripts on the server?
|
 |
 
|
|
Aug 24 2006, 08:03 PM
Post
#2
|
|
|
Desperately seeking "any key" to continue...  Group: Admin Posts: 3,497 Joined: 23-April 05 From: Trap17 storage box Member No.: 6,042 |
Yes you can access SQL remotely but this is not recommended.
When you code please check and double check so that it does not abuse SQL connection tries. Otherwise it will crash or shut down SQL server. As far as Python script goes, OpaQue has not said no to that. However the first sign of abuse or unstable the server admin will disallow your further usage and perhaps lead to account termination. So please make sure that you are not leaving any open "holes." Thank you. |
|
|
|
|
Aug 25 2006, 12:36 AM
Post
#3
|
|
|
The Ethical Hacker Group: [HOSTED] Posts: 1,171 Joined: 27-May 05 From: Portugal (Europe) Member No.: 7,566 |
BuffaloHELP, tell me something please, can i use the following program to remotly connect to my trap17 free hosting mysql server?
MySQL-Front |
|
|
|
|
Aug 26 2006, 06:08 PM
Post
#4
|
|
|
Privileged Member Group: Members Posts: 629 Joined: 26-February 05 Member No.: 3,995 |
The mysql, I'm assuming is at mysql.trap17.com? And how would I run the script?
|
|
|
|
|
Aug 27 2006, 03:16 AM
Post
#5
|
|
|
-=Hybrid Bus=- Group: Members Posts: 742 Joined: 2-November 05 From: My hybrid bus (in NYC), a computer Member No.: 13,709  |
QUOTE(beeseven @ Aug 26 2006, 02:08 PM)  The mysql, I'm assuming is at mysql.trap17.com? And how would I run the script? The MySQL server can be accessed from your site's address. Example: My domain is nyceducated.info, so the server address I would use to access it would be nyceducated.info. Alternatively, you could use gamma.xisto.com. either way, remember to allow remote access to the MySQL server from your IP address in cPanel: Log in to cPanel, go to the MySQL Databases page, and scroll all the way down to the bottom, where you see the Access Hosts section. Type in either your IP address (if it's static; which I bet it isn't), or just '%', which acts as a wildcard. (See the attachment below for reference.) But as BuffaloHELP mentioned above, it is perfered that you only access MySQL locally, for performance and security purposes. |
|
|
|
|
Sep 6 2006, 12:19 AM
Post
#6
|
|
|
Privileged Member Group: Members Posts: 629 Joined: 26-February 05 Member No.: 3,995 |
Thanks, that was really helpful. I'd still like to know how to run a script, though.
Edit: It doesn't seem to want to let me in. I'm trying to connect in Python using this: CODE conn = _mysql.connection(host='beeseven.trap17.com', user='beeseven', passwd='********', db='beeseven_forumz') But I'm getting this error:QUOTE Traceback (most recent call last):
File "<pyshell#8>", line 1, in -toplevel- conn = _mysql.connection(host='beeseven.trap17.com', user='beeseven', passwd='*******', db='beeseven_forumz') OperationalError: (1045, "Access denied for user: 'beeseven@ip68-100-***-***.dc.dc.cox.net' (Using password: YES)") This post has been edited by beeseven: Sep 16 2006, 07:37 PM |
|
|
|
|
Sep 20 2006, 10:35 PM
Post
#7
|
|
|
Privileged Member Group: Members Posts: 629 Joined: 26-February 05 Member No.: 3,995 |
I'm all about sharing solutions to problems, so I'll say that I figured out you can run a script using PHP's "system" command like so:
CODE <?php and that will also print out all the output of the script.
system("test.py"); ?> |
|
|
|
|
Feb 19 2007, 02:44 AM
Post
#8
|
|
|
Administrator Group: Admin Posts: 1,479 Joined: 11-June 04 From: Somewhere in Time & Space. Member No.: 1 |
QUOTE(Lyon2 @ Aug 25 2006, 06:06 AM) BuffaloHELP, tell me something please, can i use the following program to remotly connect to my trap17 free hosting mysql server? MySQL-Front Yes, Configure your IP address in MYSQL section in CPanel. |
|
|
|
|
Feb 22 2007, 09:51 PM
Post
#9
|
|
|
Super Member Group: Members Posts: 357 Joined: 8-April 06 Member No.: 21,487 |
Dear beeseven its not secure connect to one open mysql
for share your database you must ping your script ip for example ( new hosting or script hosting ) and take an ip address then go to cpanel / mysql part and at bottom of page you can find one text "localhost" submit your ip address in textboxbottom of "localhost" text thanks |