Jul 26, 2008

Setting Up A Remote Mysql Connection - Need help!

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

Setting Up A Remote Mysql Connection - Need help!

s2city
Okay... I'm hosted here on Trap17. I would like to connect to a remote MySQL database located on another server... can someone walk me through what I need to do to set this up, or if it can even be done?

Thank you in advance!

Reply

guangdian
change the localhost to your url.

when you installing the mysql data to your page.

thank you

Reply

s2city
I've tried that already... it says that there's an error in the database... so I'm assuming that means, it didn't work.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. mysql connection permissions - 2.44 hr back. (1)
  2. remote mysql connection for phpbb - 28.43 hr back. (2)
  3. cpanel allow remote mysql connections wordpress - 32.27 hr back. (1)
  4. mysql setting up connection to a remote database - 36.35 hr back. (2)
  5. set up mysql remote connections - 41.27 hr back. (1)
  6. mysql add remote connect - 45.79 hr back. (1)
  7. enable remote mysql connections - 56.21 hr back. (1)
  8. remote mysql connection php - 74.20 hr back. (1)
  9. enable mysql remote connection - 76.79 hr back. (2)
  10. free host remote connetion mysql - 78.17 hr back. (1)
  11. mysql remote cpanel - 81.60 hr back. (1)
  12. mysql remote connection configuring - 97.70 hr back. (2)
  13. how to configure mysql 5.0 for remote connection - 112.17 hr back. (1)
  14. remote mysql connection failed - 117.14 hr back. (1)
Similar Topics

Keywords : setting, remote, mysql, connection

  1. I Need Help With Setting Up My Site, Made Using Java
    any help would be appreciated (5)
  2. How Do I Find My Mysql Password? [resolved]
    Cannot access my MySQL (5)
    After all the recent problems, my account has been restored. I have setup my parked domain agin, and
    that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
    that's all). I had to create a new user for my databases, and created the user with exactly the
    same username and password I had before, but some of my web pages do not let me access the pages I
    have associated with my databases. Where could i find out what my DB password is? (Although I am as
    good as sure I am using the right one). I have tried my old password, the new c....
  3. Remote Access Mysql
    (8)
    Is it possible to directly access my local database from my website? For example, if somebody
    submits info on my website, the info they submitted would be transferred to my local database
    directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
    my database to my subdomain is because it would be difficult to keep the website database and my
    local database in sync . . . or is there a way to do that? Thanks for any replies.....
  4. Setting Up Ftp Accounts
    (4)
    I would like to setup an FTP account for users of my website, but I'm not too sure how to do it.
    I'm using Joomla for a website, and the members who register can submit Articles in certain
    sections. I would like most of the images in these articles stored locally(also to get some
    functions, they need certain extensions on the file name, which a free host cannot do). So I would
    like there to be an FTP account that members can access and upload images too, but not delete any of
    them. Thanks.....
  5. Question About The Upgrade And The Mysql Usage ?
    question about the upgrade and the mysql usage? (3)
    thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
    Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
    1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
    Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
    Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
    Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
  6. Question About Adding Message Board To Site
    Using mysql? (5)
    Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
    how can I set up a messageboard. Thanks. std split from another topic ....
  7. Phpbb2.17 Mysql Problems
    Just this week they started (4)
    The forum has been up and running for about a year and a half. It has been through numerous server
    upgrades, etc, including the recent HDD change, but for some reason, just this week it started
    throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
    SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
    be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
    u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,....
  8. Database Connection Problem
    phpBB2 installation error (5)
    *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
    Transfered all of the database files over. On my new forums all of the old posts and everything
    shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
    me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
    says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
    know anyway to fix this?....
  9. Smf Forum Board
    Connection Problems (2)
    Hey, i just uploaded and installed Smf on my website. Everything is working fine with the forums
    themselves, but every now and then i get 1 or 2 messages. Here they are. " Database Error: Lost
    connection to MySQL server during query File: /home/justin/public_html/forums/Sources/Load.php Line:
    1165 " " Connection Problems Sorry, SMF was unable to connect to the database. This may be caused by
    the server being busy. Please try again later. " But i have all of my database information correct.
    What does this mean and can anybody help me? Thanks ~Justin~....
  10. 99 Mysql Databases?
    (2)
    I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
    lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
    have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
    just prefix my tables, but I was just wondering why it would say that. If for some reason it was
    letting me get more than one database, and I wasn't supposed to, I don't want to get my
    account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m....
  11. Problem Setting Up Addon Domain As Allowed Number Is 0 [resolved]
    cannot add an addon domain as I have 0 allowed! (2)
    Right... a couple of days ago I registered another domain for use as well as my main one
    www.projectjim.co.uk Today, I realised that I was able to use both with my trap account as putting
    my new domain as an addon /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0"
    alt="biggrin.gif" /> Trouble is, when I come to make it it won't let me, saying I'm not
    allowed to add any more than (0) addon domains! My cpanel shows 0/0 allowed addon domains (not
    unlimited or 9) On searching I'm pretty sure I have exactly the same problem as the dude in thi....
  12. Mysql Access Error[resolved]
    (5)
    The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
    never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
    Please kindly look into this.....
  13. Setting Up Domain For Invisionfree
    help plz (1)
    I already have my domain at www.gamingcentral.trap17.com Yes, i know i have forums already there.
    But i want to switch over to invisionfree cause i am having some problems with the software. But,
    when i go to change the domain from http://z4.invisionfree.com/gamincentral/index.php?act=idx to
    www.gamingcentral.trap17.com i get this error message The domain you have entered does not appear to
    point to this server at this time. The domain should point to z4.invisionfree.com with a CNAME
    record. If anybody knows why this is happening please let me know. Thanks....
  14. Mysql Server Problems [resolved]
    (3)
    hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
    ERRORS, like that the server is going down so now and often is it due to my cms or is the server
    having some probs ? this is what i just saw from the statistics: QUOTE Service Status
    named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
    (5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
    Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17....
  15. Cpanel And Mysql Problem. [resolved]
    (3)
    hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
    to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
    ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
    loads with a blank page. however both worked earlier today. so is there a problem with the server?
    and if there is, will it be fixed?....
  16. Time Zone Setting
    (4)
    Help! Guys! I have a php script which shows me the time and I think the server time set
    differently. Is there any way I can change my individual time zone. It looks very odd on the web
    page. I am using the Indian Standard Time.....
  17. Sites Disapeard, Mysql Errors? Also Server Folders Deleted
    (18)
    Hello its 15:40 and I login see if everything runs oke, and I see numerus things deleted my mysql is
    working again. Whats going on? My Webpage couple websites got deleted, and server folder files now
    whats going on? /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> my
    forum also give errors but mysql db stil there /sad.gif" style="vertical-align:middle" emoid=":("
    border="0" alt="sad.gif" />.......
  18. Ftp Connection Horribly Breaks Down
    ----/_____|---------... (5)
    So...I am uploading Xoops CMS (Already tried Joomla and Drupal and didn't like) because
    Fantastico's is outdated. My FTP Client connection breaks down continously alone. Is this my
    problem or is there a server issue I should know about? Should I send in a different mode like
    ASCII or Auto? I am also sending with PASV(Passive) parameters. Thanks by now.....
  19. Obdc Connection? To Msql? Allowd? Inportend
    if a obdc connection is allowd so I can host my site on here instead o (0)
    Hello, I host my own mmorpg. I was wondering if a obdc connection coud be set up? And If I wanted it
    how much oints it woud cost? Its in general a simpel register / user option site. With md5
    decryption safe website no secrurity problems. So is it posible to get a obdc connection to a msql
    database on my server? thanxs in advance for any reply's....
  20. The Difference Between Mysql And Postgresql ?
    (4)
    I found those two in cPanel and they loofed nearly the same as each other but what is the difference
    ? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ?
    Please reply , thanks a lot.....
  21. Mysql Backup Cronjob
    How to? : / (6)
    Well, I want basically a cron job that will run and backup my MySQL database. I've been told
    in the shoutbox that you can do it via cron job. Didn't told me how. Now, I just want help on
    how to do it and what commands I should put in the cPanel. ....
  22. Help My Forum Connection Isn't Working
    (4)
    can anybidy help me. I have had a forum amde and I can;t access it??????? Contribute with quality.
    You could have gave more information like which forum software, URL to your forum, what error
    message and the exact nature of the issue, i.e. it shows this but not that...or not showing at all. ....
  23. How Do You Check Mysql Info, And Act According To It's Content?
    (6)
    As part of a web-game on my site, I have a php form that requires people to enter their username,
    and information about the characters they want to have in the game. All this information is stored
    into a MySQL table. I want the players to be able to visit a page where every character they have
    registered with their username can be seen. My question is simply, how can I check the values of
    the MySQL data, and act accordingly? What I need to do is check for a Username and a character
    number, and if it finds it, takes the data in that part and acts on it, eg. by showing th....
  24. I Can Not Create Mysql Databases In Control Panel Using Phpmyadmin
    Phpmyadmin says i don't have permissions to create databases (3)
    I went to phpmyadmin script a few minutes ago and i could not create a database. Since it says
    there on my control panel that i have unlimited mysql databases, plus i am using only a couple of
    databases, please respond and fix this, please.....
  25. Is It Possible To Access The Mysql Remotely?
    (10)
    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?....
  26. Does Trap17 keep back-ups of my MySQL Databases?
    (6)
    ok, well i screwed up yes i admit it i screwed up big time... anywho, umm i was wondering is
    trap17 kept back-ups of the MySQL Databases??? and if they do would it be possible for me to get a
    copy of the backup for my forums sent to me somehow? because stupid me, i was re-installing my
    forums, and went to make a backup of my MySQL database jsut in case, and selected all and hit make
    backup, and well it only made a backup of only one of the databses, so right now i am without the
    many posts i had ten minutes ago so if you so keep backups thats awsome!! youv....
  27. How To Crate Mysql Database?
    urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ....
  28. Cannot Delete Folder After Lost Ftp Connection
    permission not given to delete file (7)
    hello, well i had created a subdomain and was transferring files into the folder i was disconnect
    from the server many times while uploading the files via ftp once when i reconnect, i saw a file
    with an unusual name something starting with preftp... i tried deleting the file, but it said that
    permission was not granted to do that i tired deleting the complete folder and also tried deleting
    the subdomain from the cpanel but it was of no use can anyone help me with this? thx for your time
    Modified topic title. ....
  29. Installing Apache, Mysql, Phpmyadmin Locally
    Solving the "php_mbstring.dll missing" (5)
    Since Trap17's CP provide the individual site's owner with goodies like MySql and
    PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
    on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
    expected that most people considering to make use of a database on their site will want to do most
    of the tedious job of developing and testing on their own local system before sending the wrapped-up
    result on their domain/subdomain. This involves four basic steps (sorry for the compuwi....
  30. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (4)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....

    1. Looking for setting, remote, mysql, connection

Searching Video's for setting, remote, mysql, connection
Similar
I Need Help
With Setting
Up My Site,
Made Using
Java - any
help would
be
appreciated
How Do I
Find My
Mysql
Password?
[resolved] -
Cannot
access my
MySQL
Remote
Access Mysql
Setting Up
Ftp Accounts
Question
About The
Upgrade And
The Mysql
Usage ? -
question
about the
upgrade and
the mysql
usage?
Question
About Adding
Message
Board To
Site - Using
mysql?
Phpbb2.17
Mysql
Problems -
Just this
week they
started
Database
Connection
Problem -
phpBB2
installation
error
Smf Forum
Board -
Connection
Problems
99 Mysql
Databases?
Problem
Setting Up
Addon Domain
As Allowed
Number Is 0
[resolved] -
cannot add
an addon
domain as I
have 0
allowed!
Mysql Access
Error[resolv
ed]
Setting Up
Domain For
Invisionfree
- help plz
Mysql Server
Problems
[resolved]
Cpanel And
Mysql
Problem.
[resolved]
Time Zone
Setting
Sites
Disapeard,
Mysql
Errors? Also
Server
Folders
Deleted
Ftp
Connection
Horribly
Breaks Down
-
----/_____|-
--------...
Obdc
Connection?
To Msql?
Allowd?
Inportend -
if a obdc
connection
is allowd so
I can host
my site on
here instead
o
The
Difference
Between
Mysql And
Postgresql ?
Mysql Backup
Cronjob -
How to? : /
Help My
Forum
Connection
Isn't
Working
How Do You
Check Mysql
Info, And
Act
According To
It's
Content?
I Can Not
Create Mysql
Databases In
Control
Panel Using
Phpmyadmin -
Phpmyadmin
says i
don't
have
permissions
to create
databases
Is It
Possible To
Access The
Mysql
Remotely?
Does Trap17
keep
back-ups of
my MySQL
Databases?
How To Crate
Mysql
Database? -
urgent help
Cannot
Delete
Folder After
Lost Ftp
Connection -
permission
not given to
delete file
Installing
Apache,
Mysql,
Phpmyadmin
Locally -
Solving the
"php_mb
string.dll
missing"
;
Mysql
Database
Setup :
Setting Up
Mysql
Database -
Guide to use
MySQL
database in
your site
advertisement



Setting Up A Remote Mysql Connection - Need help!



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE