nummell
Oct 25 2007, 12:40 AM
| | Hi...
One of my hosts hasnīt MySQL but i need to develop a login system so I need to know if itīs possible to use a MySQL database intalled in another host...
If itīs possible can you explain me how to do it?
Thanks in advance |
Reply
BuffaloHELP
Oct 25 2007, 12:46 AM
Are you referring to using another hosting's SQL? For example, Hosting site B is using hosting site A's SQL? This is called remote connecting to database and if the hosting company allows remote connection to database, then yes. But majority of hosting companies do not offer because of the security reasons. With Trap17 hosting you are able to use Trap17 hosting as a remote database but it's at your risk. Please refer to our hosting member area for more information.
Reply
nummell
Oct 25 2007, 12:59 AM
Thanks for the information. I still need to know how to "call" the database... Usualy is LOCALHOST - USERNAME - PASSWORD How do you call a database on another host?
Reply
faund
Oct 25 2007, 02:50 AM
You could use the connect test code below CODE <?php
$link=mysql_connect('221.133.22.11','root','123456');
if(!$link) echo "connection failure";
else echo "Connection success";
mysql_close();
?> You should replace "221.133.22.11" with your remote mysql server's IP. "root" will be replaced with your remote mysql server's username. "123456" will be replaced with your remote mysql server's password. It's not a good idea to connect a remote mysql server I think, anyone of server down, your site will down, and transfer your account infomation through internet is really a dangrous action.
Reply
nummell
Oct 25 2007, 11:15 PM
Thanks for the info... Maybe Itīs better for me to move my other domain to trap17
Reply
asglu
Apr 6 2008, 07:23 PM
here is the basic and simple php script to connect mysql database CODE <?php
$server = "";//database server name
$database = "";//database name
$username = "";//data base user name
$password = "";//database password
$connection = mysql_connect($server,$username,$password);//to connect the msql server
mysql_select_db($database,$connection);//to select data base
mysql_close();//close the mysql server after use
?>
Reply
fffanatics
Apr 6 2008, 09:25 PM
Yeah, just use the scripts above to accomplish what you need. It is very simple since lots of hosts do not even have their own local mysql server. For instance, godaddy gives you the ip for their sql server and you have to use that instead of localhost in your script. It helps keep loads down on very popular servers and such.
Reply
shadowx
Apr 6 2008, 10:02 PM
Well im fairly sure there are flat-file style MYSQL databases... I cant remember the name but try google... It doesnt require a database server to run, it somehow converts the MYSQL commands (they might vary slightly from normal DB code) into file read-write commands and then uses ordinary (but encoded) files to store the data and then reads and writes to those files so it should work perfectly on your set up. Try google for "flat file database mysql" or something similar.
Reply
Recent Queries:--
connecting to remote mysql database - 74.01 hr back. (1)
-
downloading a blob file from a server php mysql - 101.07 hr back. (1)
-
mysql call mssql query - 478.40 hr back. (1)
Similar Topics
Keywords : mysql
- Mysql Hacks
(1)
Creating A Php Login System Using Mysql
I need help in creating a login system, what I want is a login system (10) Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login
form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no
experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a
personalised page for each user and when they login the system transfers the user to their page.
Another thing that the system MUST have is a way of stopping unwanted users entering someones page.
CODE For example lets say I register and my UN is jesse123 and my personalised pages a....
The Only Reason I Choose Ms Sql Server Rather Than Mysql
(0) The only reason i choose ms sql server rather than mysql is, MS SQL has more security
features!! MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I
developed some application to support chinese letter, and dont know how to build one in mysql - Lack
in t-sql syntax, like query in query is not fully supported - Does not have today SQL features like
BI support (today really required) And compare MS SQL to MySQL, the only reason why mysql is
favourable is - it is free! Dont u guys agree?....
Need Advice On Setting Up Mysql Database.
I have a huge amount of daily data updates to be inserted. (4) First of all, to get the idea of what I am trying to achieve here, please have a look at my
idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
file for how to make use of the map.sql data located on the help.travian.com website, which also
gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi....
The Best Free Php Mysql Blog
any idea (5) Hi everyone Recently i tried to upload a personal blog. as I know a bit of PHP programming I was
looking for a free open source PHP blog. first I tried Wordpress out but there was few problems
that i needed to change php.ini or .htaccess file and also some other PHP settings. as i was trying
it out on a free web host i didn't have access to php.ini. so i have changed it from Wordpress
to bblog , i have installed it successfully and i followed it's safety instruction (deleting
install folder and install.php and CHmod config.php )then i got another problem i ....
Mysql-essential-5.0.51 Installion Problem
please help me.(urgent) (2) Dear friend, please help me. Iam working on php project (matchmaking site). I have downloaded mysql
essensial 5.0.51. When i was installing mysql 5.0.51, i got following error - Error 1901: Error
attempting to read from the source installation database:
c:\windows\installer\527ec6.msi What is solution of this problem ? Iam using
windows xp professional version 2002 (service pack 2). Please post your reply. Iam waiting for your
answer. ....
Mysql Query Problems
I need some help or a tutorial? (6) I seem to be having trouble with getting my Query to post my user's ID numbers. CODE //
Make a MySQL Connection mysql_connect("localhost", "user",
"password") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error()); // Retrieve
all the data from the members table $result = mysql_query("SELECT * FROM members WHERE
id='$id'") or die(mysql_error()); // store the record of the
id table into $row $row = m....
Database With Mysql++
getting mySQL++ to work with trap17 (7) Hi, I'm trying to build an online game and figured the easiest way to do the server list would
be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
website and I always get an abnormal program termination; however, it will work with the mySQL on my
own machine. The code is below: CODE #include <iostream> #include <iomanip>
#include <mysql++> #include "pass.h"//holds my password (i program at
school) int main(void) { Connection con("t3jem3_test","....
Mysql Datatype Int() Question
Not sure what value to use inside int() (1) Can anyone clarify what the value in int() actually does? CREATE TABLE job_class ( jc_id int(1)
NOT NULL AUTO_INCREMENT PRIMARY KEY, jc_index int(2) NOT NULL, jc_name varchar(20) NOT NULL, jc_type
varchar(20) NOT NULL ); I was under the impression that any integer value used inside a () was
the limit that data-type would have. In the PRIMARY KEY column I was able to add integer values
1-18. I'm kinda confused now If I can add 2 digit integers there then what is the point of
assigning values inside brackets() For the varchar() any number put in there does limit....
Loading File Into Blob Fields To Mysql
(1) Hi all! does any know how to load file into blob filed by sql script?....
Mysql And Sql
difference??? (7) I was wondering what is the difference between MySQL and SQL. I was really confused when i planned
to do a project recently. This question has haunted me for a long time. Is it both same?....
Mysql Database Copying
(4) Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and
the bridge is not working like the Joomla! one does. (with the seperate db capability) i know
how to transfer all the tables by hand but depending on how much data you have stored in mysql could
take a long time. Take short time!? Help me!....
Installing Mysql On Unix, Linux
(2) Download the latest version of MySQL.Choose the latest stable release and, from the stable release
page, choose the option under "Source Downloads" marked "tarball (.tar.gz)". Download the file into
a directory where files can be created and there is sufficient disk space. A good location is /tmp.
Change directory to this location using: 1. % cd /tmp Note that the % character
should not be typed in; this represents the Linux shell prompt and indicates that the command should
be entered at the shell prompt. 2. Uncompress the package in the new ....
Mysql Tools Database
Opensource sql tools... (1) You can download mysql query web browser on http://www.mysql.com you also can download plugin
there...like conector mysql from visual basic ,java,etc with my sql query tool browser you can make
and maintance youre database sql easily because use gUI interface..!!....
Looking for mysql
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for mysql
*MORE FROM TRAP17.COM*
|
advertisement
|
|
