Can I Access MySQL Database From Outsite, Directly

Pages: 1, 2
free web hosting
Free Web Hosting > Astahost > Hosted Members Support

Can I Access MySQL Database From Outsite, Directly

PureHeart
I'm going to make an OFFLINE FORUM. So I want to know is that possible or not. My paid host don't allow that. How about astahost?

Reply

Houdini
First of all what is an OFFLINE FORUM, I mean if it is not online nobody can see it the thing has to be online or it is nothing at all, or just what do you mean?

Reply

yordan
We can imagine a lot of ways of making an offline forum. For instance, sending mails and receiving the answers. So, first of all, we must see what PureHeart means by offline forum.

Reply

PureHeart
OFFLINE FORUM is a kind of forum run on client. It will download all the new threads and posts of the forum at one. After that, the user can disconnect and do things on the copy of forum (on their local machine)(reply, create new topic, for example). This will save BW and connecting time. After that, they reconnect and send all their work back to the forum.

An OFFLINE FORUM is going to be used for my Dial-up users, because they're charge based on time of connecting, not BW.

Reply

Houdini
Then all they need is to query the database with the new messages which should be nubered sequentially so the query would only download those posts which were entered since their last visit, you would have to have a means of letting the database know what the last message was that was on their machine, the database does not care whether or not the user that is quering them just now came online and will fulfill the query and be done with that request. The database itself is always online but with the users intermittently accessing it is of no matter.

Instead of acting like a normal server the forum is actually being used like a mail server but how it is being used doesn't matter even if a user is constantly online but does not make a request for data then the database as far as it is concerned they are not there so I really don't see what the problem with the offline or limited use of the database is you would just fetch all the new messages then log off and the database could care less as well as the user.

Reply

xboxrulz
From years of experience with the MySQL database, I think you can.

For example:
site: <your domain>:3306

xboxrulz

Reply

miCRoSCoPiC^eaRthLinG
YES YES YES smile.gif I mean YES you can ..

All you gotta do is from cPanel MySQL DB Setup, add the hostmask which will be allowed to connect to your DB.

If you want all users to be able to connect to this DB, your hostmask should be %.%.%.%

and if it is only a certain segment from IP range say, 213.214.x.x - you do 213.214.%.%

That'll enable you to connect - for hostname, set your subdomain's name and port should be 3306.

To test your configuration and remote manipulation of your databases, I recommend this tool called SQLYog - a real power-packed MySQL Administrator Tool, the lite version of which is freely downloadable at http://www.webyog.com


Reply

ruben
If you set up % as access host won't people be able to manipulate your database (yes there is a password, but it would probably be in that offline program, right?
+ people would be able to query your database till it crashs?

Reply

PureHeart
The password which is store in the program is for an read-only account.
The program will submit information via HTTP instead of direct query.

I've never thought about that before. I may make some query time limitation in the program.

Thank you ruben.

Reply

yordan
QUOTE
+ people would be able to query your database till it crashs?

It's the same thing with your web access, people using a trainer like "loadrunner" will be able to query your database site until it crashes.

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.

Pages: 1, 2
Recent Queries:-
  1. sqlyog mysqldb unable to insert - 88.73 hr back. (1)
  2. rpg to mysql database access - 227.72 hr back. (1)
Similar Topics

Keywords : access, mysql, database, outsite, directly

  1. Small Issues About Mysql Connector/j 5.1
    (2)
  2. Sql*plus On Your Pc
    Connecting to a remote database (3)
    1. INTRODUCTION. Most of you are familiar using Oracle sql*plus, in order to perform very
    simple queries, or writing down complex sql scripts. In order to do that, you usually simply rlogin
    or putty to the remote Unix/Linux machine and run your queries in a command-line prompt window. When
    you want to create complicated (at least several-lines long) scripts, or test the reproducibility of
    a table/index creation script, you start it on the Linux remote system. If you want to modify it,
    you get it back on your PC, modify it with your favourite developer’s program ....
  3. Login System
    I want to make a login system using Mysql. I am amateur in these thing (6)
    I want to make a login system using Mysql. I am amateur in these things so please explain in detail
    like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of
    table I should make and and the website or PHP for it . If you think i hav chosen wrong site please
    give any better database hosting site. Please help me Best Regards Pritesh Gupta....
  4. Free Or Opensource Database/schema Browser?
    Alternatives to TOAD or PL/SQL Developer (6)
    I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse
    through a database(s), the different schema objects, and perhaps the stored
    procedure/function/packakge editors. One thing I have tried is to the use the Data Tool Plugins set
    for my Eclipse but that brings my machine's performance to crawl. One a further note, I am
    basically looking for Windows environment, with connections to remoate databases.....
  5. Which Language Is Easy And Secure Today For Web Development
    is PHP MYSQL is easy and Secure ? (2)
    Web development Application now a day using PHP MySQL Mostly as i observed on discussion topics on
    Forums friends switch to PHP MYSqL, Did PHP MYSQL is Easy and Secure for todays environment what
    you are say about this Hacking tracking stolen password are very much popular now a days his website
    hacked by X person so many time comes to news please emphasis on security issue when you go to
    develop any web tools . what is the right way to tight security on PHP what thing i kept in mind
    which logic i use that any one can not hack webtools. when i was use java/j2ee languag....
  6. Mysql Overhead
    (3)
    Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
    near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
    press of a button but i'd like to know what happens when i optimize a table. Also when you make
    a new table you can limit the size of VARCHAR to a number, that number would be the number
    characters allowed in that column per entry. I'd like to know how the limit works for texts, is
    it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
  7. Cpanel Error When Loggin In...
    Unable to access my cPanel... (5)
    Hey all... I was trying to get into my cPanel to try to move some files, and it entered this page
    error: Not Found The server was not able to find the document (./frontend/rvblue/index.html) you
    requested. Please check the url and try again. You might also want to report this error to your
    webhost. cpaneld/11.23.6 Server at www.skemb.astahost.com Does this mean anything or make any sense
    to any of you!!?? Any kind of response is appriciated... Thanks all! - skedad -....
  8. How To Understand A Database Schema
    A very nice and simple tutorial (4)
    Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
    Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
    Understand a Database Schema . As its name says, this tutorial will help you to better understand a
    Database Schema and covers the following basics topics that every Database Schema must define:
    QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
    "Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....
  9. Best Database
    (13)
    What is the best free database if some one trying built a social networking website? And how to
    operate it with dreamweaver 8?....
  10. Database
    (7)
    $c = mysql_connect('localhost', 'root', 'p1kap1ka');
    mysql_select_db('lite2', $c); $mykey=256573440; ?> In this code where shall I post
    my database name (and my database name should it contain my hosting name so before it there should
    be a165_game For example? or should it just be game?) and where shall I put the user password?....
  11. What You Need Before You Can Create A Text-based Game..
    Using PHP, HTML and MySQL (7)
    Please comment and rate, after you finished reading! /smile.gif" style="vertical-align:middle"
    emoid=":)" border="0" alt="smile.gif" />
    ################################################################# Change log: Aug 22 2008: The
    Tutorial Was Created. V1.0.0 Aug 30 2008: Added XHTML and a small CSS part. Also corrected some
    small things and added this change log. V2.0.0
    ################################################################# OK.. Many people here want to
    create text based games. Many of you ask us here on the forums: "how to create a text-based game....
  12. Some Useful Database Links.
    (7)
    I thought I would take a moment to point the users here to some of the database resources available
    for reference and learning. First I will start with actually designing the database. This site by
    R937 covers the basics of database design. The author is professional database guru and a frequent
    helper at the at DB forums listed below. The Library of Free Data Models is an excellent
    resource for finding data models for projects you may have or as examples of well put together data
    models. With around 500 data models the chances are you find something at least cl....
  13. How To: Display A Members/user List.
    With PHP, Mysql, and HTML. (3)
    Alright, some of you might want to display your User's or Members on your site. Notes: 1.This
    is to fit in with Feelay's register and Log-in scripts you can find in the tutorial section. 2.I
    made this to show the members of my site who is a member and what their ID is. First off, we must
    set up a connection to our MySQL Database. CODE $con =
    mysql_connect("localhost","database_username","database_username_password"); if (!$con)   {
      die('Could not connect: ' . mysql_error());   } What it does: 1.It is starting a PHP
    document. 2.Next it sets....
  14. Php Tutorial: Making A Shoutbox
    Requirements: PHP, MySQL (12)
    Hi everyone, I'm going to tell you how to make a simple shoutbox using PHP and MySQL. To start
    off, open up mysql in the command line, or phpmyadmin, and create a database called shoutbox. Next,
    enter the following sql into the command line, or the phpmyadmin sql box, while using the shoutbox
    database: CODE create table messages(author varchar(30), message text, time timestamp, mid int
    auto_increment, primary key(mid)); This creates the table we need to store the messages, note the
    "mid" column, this gives each message a seperate id number, we'll see why ....
  15. Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )
    A small tutorial to explain integrating php, ajax and MySQL Database (11)
    Hi all.. I'm back with a new small tutorial! Introducation A tutorial to integrate
    Ajax, Php And Database ( Im using MySQL) + Visitor Tracking! Here you can enter values to some
    input fields, and by clicking some enter button, ( or u can call the function on some other event)
    those values will be sent to the database, along with visitor details ( IP Address, Input Value,
    Visitor Agent etc)! Those values will be stored in some database and you can retrieve the same using
    some simple php code and even deleted some rows from those databases! Requiremen....
  16. Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)
    150 MB space, 10000 MB Bandwidth, php, mysql, CPanel (10)
    Hello Members, We are proud to introduce a new member to Xisto group of sites.
    Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
    mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
    http://www.Qupis.com
    Feel free to add your reviews and comments about it. -AstaHost
    Management ....
  17. Navcat For MySQL
    is Navcat any good? (9)
    Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
    played around with the demo. Has any one used it beore, if so please let me know if its worth
    buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
    and functionality. Regards....
  18. Firefox 2
    Access-key and close tabs configuration (5)
    When I installed Firefox 2.0 I got a little probelm... Accesskeys: I use access-key to follow
    links and send forms very often, and in Firefox 1.5 y default they were used by pressing
    "Alt"+"Accesskey". In Firefox 2.0 the default value has changed, so to follow accesskeys you many
    press: "Alt"+"Shift"+"Accesskey" wich is more complicated. To change Firefox 2's behaviour,
    browse: "about:config" and set the value of the following keys to: ui.key.chromeAccess = 5
    ui.key.contentAccess = 4 This way the menu bar accesskeys are associated to the combination
    "Alt"+"S....
  19. Read/Write Issues After Copying An Access .mdb File
    (3)
    Alright, I'm currently creating an interface program for a MS Access database. I've only
    used Access once in the past but used other DB's a handful of times so I didn't have any
    trouble getting the general program created. My issue arose when I tried to make it so that the
    users needing to use the program can just copy the .exe and the .mdb files and use it. The program
    doesn't require users to share the database but to store their OWN programs information in their
    OWN database, so basically each needs to have their own database with the exact same d....
  20. VB.NET & MS Access Issue
    (7)
    Alright, I haven't had much experience with vb.net or ms access as it is, let alone using them
    together, so I need some advice on the best way to do this. I need to create a program that
    basically is a form to fill out with information, and upon filling it out it can be saved. Saving
    consists of making a row in a ms access database and placing each field as a column entry within
    this new row. Then I need to be able to retrieve this information from the DB and fill out the form
    as it was originally if the user chooses to load. This is all fine and wasn't hard to....
  21. CuteNews: PHP-based Blog System - No MySQL
    (11)
    I don't know if you guys have heard about CuteNews, but I think it's an awesome blogging
    system. If you don't know where to get it or how to set it up, here is a quick run-down.
    Download the zip file (virus free) from http://www.mysharebox.com/dl.php?key=8276639 . 1) Unzip
    the file. 2) Make a folder titled "cutenews". 3) Upload the contents of the cutenews folder into the
    one you've just created. 4) CHMOD the file index.php to 777. 5) CHMOD the folder "data" to 777.
    6) Then CHMOD all the files and folders inside of "data" to 777. 7) Go to http://YO....
  22. Important: Basics Of Using PHP And MySQL
    (10)
    I generally notice confusion with new users to PHP and or MySQL and first of all I believe that
    unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is
    automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox
    Netscape or any other browser that has been set. PHP is a different matter to view the output of a
    PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply
    will not work. (Note serverside langauge requies a server) HTML is client side and ....
  23. MySQL Output Database Question
    (18)
    I am new to MySql and have just created a database after using a script. My problem is not the
    script, but what it says about putting it into the output file. I cant figure out the right terms
    to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
    'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
    please help me out?....
  24. VB6-MS Access Question
    help please (9)
    hi guys, I am developing an application in Visual Basic 6.0 and using MS Access as my backend. What
    i want is that my database should not open when someone doublec clicks on the .mdb file. But my
    application should be able to access it. What can be a possible solution to this problem? Please
    help. Thanx in advance.....
  25. MySQL For EasyPHP Users
    Does anyone use this program? (5)
    I installed a program called EasyPHP because it was an easy install and I wanted to be able to learn
    php and still be able to down the road learn MySQL. But I can't figure out how to use MySQL.
    Does anyone out there use this program that could tell me alittle about it. Alot of the product
    site is written in a different language, but everything on the program is english so that is good.
    Any help would be appreciated.....
  26. [PHP + MySQL] Encrypting Data
    To protect the password of your DB, for example. (11)
    Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the MySQL
    DB. Here we go! ------------------------------------------------------------------------ CODE
    $password = "abc"; $new_password = md5($password); echo $new_password; ?> The password "abc"
    was codfied using md5() This will be: 900150983cd24fb0d6963f7d28e17f72 CODE $normal_pass =
    "abc"; $encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($normal_pass) ==
    $encripted_pass)   echo "Login Sucessful!"; else   echo "Incorrect password."; ?> This c....
  27. How To: Connect, Read, Write, Close A Database
    VB.NET (5)
    Here is a tutoral or a novice programmer. This tutorial assumes you have a basic knoladge of
    databases and VB.NET. It also assumes that you have a MS access database named Testdb.mdb with a
    table called "Table1" that has at least one column called "Col1". You must start with a form with
    one label on it. If you need any help email me at bob3695@gmail.com. The first step is connecting
    to the database. The first thing you must do is add the ADODB reference. To do this in the
    "Project" menu click "Add Reference" then select ADODB from the list and click "Select". The next....
  28. Sharing Files In Windows Xp Home
    I always get an "access denied mesage" (15)
    when trying to access another computer's shared files on my home network i recieve an error
    message " is not accessable. You might not have permission to use this network resource. Contact
    the administrator of this server to find out if you have access permissions. Access denied" anyone
    know why I am getting this message?....
  29. Creating A Game In Rpg Maker 2000/2003
    Part 1 - New Game and the Database (18)
    Creating a game in RPG Maker 2000/2003 Part 1 (I AM ONLY GOING TO TEACH YOU HOW TO MAKE AN
    RPG GAME IN THIS TUTORIAL!) First of all, you need to find some resources. When I say resources, I
    mean Character Sets, Chip Sets, Music, Backdrops, and Enemies. (Also others) The perfect place to
    find thoses would be at one of these great websites: www.gamingw.net www.phylomortis.com But,
    before you save them, you need to create a new game. Once you click on "New Project", this screen
    will pop up. The Directory Name is simply the name of the folder that it will mak....
  30. MySQL Realtime Replication
    how to replicate mysql in realtime (4)
    i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
    siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
    do realtime replication. the idea is that there are master server and slave server. both are having
    the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
    you'll never have to manually copy the database file of wasting your time to manually use the
    mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....

    1. Looking for access, mysql, database, outsite, directly






*SIMILAR VIDEOS*
Searching Video's for access, mysql, database, outsite, directly
Similar
Small Issues About Mysql Connector/j 5.1
Sql*plus On Your Pc - Connecting to a remote database
Login System - I want to make a login system using Mysql. I am amateur in these thing
Free Or Opensource Database/schema Browser? - Alternatives to TOAD or PL/SQL Developer
Which Language Is Easy And Secure Today For Web Development - is PHP MYSQL is easy and Secure ?
Mysql Overhead
Cpanel Error When Loggin In... - Unable to access my cPanel...
How To Understand A Database Schema - A very nice and simple tutorial
Best Database
Database
What You Need Before You Can Create A Text-based Game.. - Using PHP, HTML and MySQL
Some Useful Database Links.
How To: Display A Members/user List. - With PHP, Mysql, and HTML.
Php Tutorial: Making A Shoutbox - Requirements: PHP, MySQL
Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking ) - A small tutorial to explain integrating php, ajax and MySQL Database
Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom) - 150 MB space, 10000 MB Bandwidth, php, mysql, CPanel
Navcat For MySQL - is Navcat any good?
Firefox 2 - Access-key and close tabs configuration
Read/Write Issues After Copying An Access .mdb File
VB.NET & MS Access Issue
CuteNews: PHP-based Blog System - No MySQL
Important: Basics Of Using PHP And MySQL
MySQL Output Database Question
VB6-MS Access Question - help please
MySQL For EasyPHP Users - Does anyone use this program?
[PHP + MySQL] Encrypting Data - To protect the password of your DB, for example.
How To: Connect, Read, Write, Close A Database - VB.NET
Sharing Files In Windows Xp Home - I always get an "access denied mesage"
Creating A Game In Rpg Maker 2000/2003 - Part 1 - New Game and the Database
MySQL Realtime Replication - how to replicate mysql in realtime
advertisement




Can I Access MySQL Database From Outsite, Directly



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
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