MYSQL :: Remote Connection To Database

Remote Connection To Mysql Database Using JDBC?
I am trying to set up OpenOffice Base to connect to a remote os x server with mysql on it.

It has the default mySQL JDBC driver class set to com.mysql.jdbc.Driver

It also asks for server URL, should this be the ip address?
Port number? Default is set to 3306.

When I set the class it says that the JDBC driver could not be loaded.

Remote Connection
How do i connect to a remote (webserver) Mysql from the windows command line?

Remote SQL Connection
I am trying to access my database on the server with a MYSQL front-end
client on my computer (not the server). I have the correct username,
password and database name. I tried every possible hostname, even its ip
addy, but each time, I am rejected by the server, which says something
like - access denied. I can access the database in my php code with
'localhost', but that's of course because the code is actually running on
the server. Is there anything I have to specify on the MYSQL server in order
to gain access to it remotely?

Remote Connection
First of all hey guys i'm new to this forum and hope to get some help on getting me fully started with mySQL.

Alrite i've really briefly used mySQL with java but only with a local database.

I need help on how to create remote connections via the internet to mySQL. Basically i've been trying to test out connecting via the internet from my home machine where mySQL is installed, i've tried this through windows command line and doing:

mysql -h myip -u myuser -p

also tried with --port=3306

but it doesn't work. Does the fact that i'm behind a router and have a different local ip matter? Or does the fact that i'm doing this from the machine that holds the mySQL database but i'm using the internet IP address to make it go through the internet. I've already opened up the port in my routers firewall.

I wanted to create a java application that can access a mySQL database over the internet so I thought i'd try out remote connections on windows command line first.

I'm very new to mySQL so any help in the right direction and/or what i'm doing wrong with some explanation will help me give a better understanding.

Remote Connection
just that. and DONOT point me to any documentation ive been through it all mysql will NOT let me give any host persmissions it keeps giving me the syntax crap and to check the menual when i did it just like the friggen manual said

GRANT ALL PRIVILEGES TO db.*
-> root@'host';

and its really pissing me off.
im runing mysql 4.1.8 any ideas?
i also put the host in my hosts file and still nogo

Remote Connection
I'm having a problem connecting to mysql on a remote host because it truncates my user name (dbm.stetsonband.org):

ERROR 1045 (00000): Access denied for user: 'dbm.stetsonband.@d199-126-224-237.abhsia.telus.net' (Using password: YES)

Is there something I need to set in my mysql prefs somewhere?

Remote DB Connection
I am trying to install SAM Broadcaster and it requires tables to be installed on a mysql database remotely. I am not able to connect to the database for some reason and I am wondering if this is maybe because the MySQL server I am trying to connect to has remote connection protection on (if there is such a thing). Is there a way of determining this and is there also a way if this exists to allow remote connections to add tables to a mysql database?

Remote Connection Through Php Script
I have a mysql server running at the office on <officeip>:3306

I have a site hosted by a provider at domain.it

I have granted privileges for existing user office as office@domain.it and office@domainip

I wrote a php script using the parameters:

$host='<officeip>'

$user=office

$pass='<thepass>'

$db='<mydb>'

to connect to the office db from the website.

I get a 'Lost connection' error (no query to execute just connecting so no time-out problem)

What do you believe is wrong with it?

Remote Connection To MySQL
Trying to connect to a MySQL server from my desktop.

Specs:

My Desktop - XP OS - MySQL Administrator.
Server - Red Hat Linus OS - MySQL version 4.x

From the MySQL I am getting an error code 2003 "Can't connect to MySQL server (10060)". I am using the default port 3006.

Any suggestions? What additional information do you need to help me out here?

Remote Connection To Sql Server
I've set the remote website, dotbooks.org (207.44.234.74) as an "Access Host" in cPanel.

I'm trying to connect to wiishare.org (70.86.206.218)

The connection string I'm trying is:

<?php

$user = "username";
$password = "password";
$database = "database";

$link = mysql_connect("70.86.206.218", $user, $password);
mysql_select_db($database, $link);
echo mysql_errno($link) . ": " . mysql_error($link). "
";
?>

The string works with localhost, but not like this. It just times out
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in connect.php on line 7 Any suggestions?

MySql Remote Connection
I'm having problems in trying to remote connect to a database and it's driving me nuts.

Database is on server, trying to connect to it through internet using MySQL Control Center with following settings:

Name: Lucca
HostName: IP address of server
UserName: Beeps
Password: """"
Port: 3306

I've made sure that the firewall will allow entry and can successfully ping the server, but I get the following error:

Error 2003: Can't connect to MySQL server on "ip" (10060)

Establishing A Remote Connection
I'm trying to enable remote connections to my mysql database. I'm getting a
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused

error when I try establish a jdbc connection. I'm supplying the correct user/pass information.

A quick google tells me that I need to enable connections from places other than localhost.
okay, so I do a:

mysql> GRANT ALL PRIVILEGES ON *.* to raghav@'%' identified by 'blah';

As can be seen from the table below, i've tried doing it for anonymous accounts as well, when all of this didn't work. I've flushed privileges, and restarted the mysql server. no luck. Code:

Remote Root Connection
I am new here and I have a problem with configuring mysql. How can I set up mysql to allow remote root connections from a specific IP range?? Is this possible at all?

Remote Connection Error
I have been using a database on localhost for a while succesfuly. I am now, however going to be using this same database remotely. Whenever I attempt to connect to the database remotley I am given the error message:
Warning: mysql_connect(): Can't connect to MySQL server on 'my ip' (10060) in C:OpenSAApache2htdocsindex.php on line 9
I have removed the bind-address line from the my.ini file in C:Windows as I read in a previous post you should do, and restarted mysql, but the error still remains. Does anyone know what i'm doing wrong?

Remote MySQL Connection Slow
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the faster server's database using the slower server's PHP web pages, the overall page loads much slower than when the database was on the slower server.

Any ideas why this would be? Right now the host name is just an IP address. Does it need an actual resolved hostname to be fast? MySQL on the faster server is supposedly tweaked for fast service (my-huge.cnf).

Error 2003 On Remote Connection
I have a WinXP Home Edition where I have installed MySQL 4.x

I can use MySQL Administrator on my server, but when I try to connect to my server by entering my WAN-IP, I get the error:

"Could not connect to the specified instance.

MySQL Error Number 2003
Can't connect to MySQL server on xx.xx.xx.xx (10061)".

Remote MySQL Connection Fails
I have two XP computers, with the same version of MySQL on each. I
have the same database structure and data on each. Each computer has
the same user name, and each MySQL database has the same user names.
Locally on each, I can connect and work with the data. I can ping
each computer from the other computer. My problem is that when I try
to connect from one computer to the other I get the following error:
Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.
This happens on both computers. I can not find the reason for the
error.

How To Connect To A Remote MySQL Server Using An ADO Connection?
I would like to know how to connect to a remote MySQL server using an ADO connection object, for example from Delphi.

Query Browser When Opened Via Remote Desktop Connection
I have a MySQL database that I set up by running a couple of .sql scripts.

The .sql files are fine and not corrupted.

But they are located on our server in headoffice.  When I try to open them in MySQL Query Browser (also installed on the headoffice server) via Remote Desktop Connection, the Query Browser opens a new script tab but does not display anything (i.e. no text in the scipt tab).

Also, I'm sure this is related, I can enter a query in to the execute box and execute it, but you cannot see the text as it is being typed.  However it is there as when I click the Execute button the query runs fine.

Any ideas why I am not able to see any entered text in the Query Browser window?  I have tried uninstalling and reinstalling Query Browser a few times, but this has not cured the problem.

Making A Command Line Connection To A Remote Mysql Server?
how do i make a command line connection to a remote mysql
server?

for local connections i know it is: mysql -u root dbname

how do i connect to a remote server with a password?

Remote Connection To MySQL DB Server From Client With No MySQL DB
I have MySQL server running on a Solaris machine. I have a Perl tool that is run on multiple operating systems (Linux, Solaris, MKS on windows, CYGWIN on windows). I would like to post to the MySQL database on the Solaris machine from this script when it is run on the different local clients. All these clients share a single network share (available via Samba on windows).

Is there a Perl module that I can install in the network share that I can use to connect remotely to the server DB?

Connecting To Remote Database
I'm using MAMP on a MacBook Pro. The only database connection I've been able to write that doesn't return an error message is on the database "test" that's installed by default:

$link = mysql_connect ("localhost" , "USERNAME", "") or die(mysql_error());
mysql_select_db ("test", $link) or die(mysql_error());
...where USERNAME is a username I created and accidentally applied to all my databases. Anyway, I assumed I could use the database "test," since I can at least connect to it.

But my queries all display error messages, even after I copy the tables they reference into the database test. Finally, I wrote a very simple query:

$Geog = mysql_fetch_assoc(mysql_query("SELECT * FROM gw_geog_gw"));
But I still get the following error message:

Quote:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Users/MyName/Sites/Geobop/Files/World.php on line 7

Does that mean I'm not even connected to the database "test"?

Connecting To A Remote Database....please Help
I'm trying to connect to a remote database, but am not sure how to do that (ie what command I should use in the Terminal). I have a php file that gives me all of the details:
<?
Database Details ----#

$host = "**.**.**.***";
$dbname = "**************";
$dbuser = "**************";
$dbpass = "**************";

Paths Used in Codeing ---#

$root_path = "/home/software/public_html/**************/";
$http_path = "http://www.webaddress.com/**************/";

?>

Triggers To A Remote Database
We make use of a PACS (Picture Archiving and Communication System) and
system to store DICOM (Digital Imaging and Communication in Medicine)
images (like CT scans, MR images etc.) in our Oncology Center. This PACS
system uses mysql as it's native database, in which it stores certain
data as date and time of the examination, it uses InnoDB tables.

We are building another application around it, which will use data from
the PACS tables and will hold additional data in a seperate database in
it's own tables.

Every study has it's own unique identifier which is stored in the PACS
database. Additional data is stored in the additional database, under
the same unique identifier to be able to keep track of the data and link
it to each other.

Now I would like to know if it is possible to add a trigger to the PACS
database which will delete the related information in the additional
database if a record in the PACS database is dropped. This trigger will
have to delete the records in the additional tables before dropping the
data in it's own database, so we can maintain a more compact database
and don't store data which we cannot link to the PACS system anymore.

Remote Database Issue
I am trying to setup Joomla with the following setup.

Web server 192.168.99.80-82 Joomla is specifically at 192.168.99.82
MySQL server 192.168.99.90

I used MySQL Administrator to setup user account which I will call test. Then I right clicked the user and selected Add host from which user can connect. I then typed in 192.168.99.82. I had issues so I also added .80.

I then created a database called Joomla and then gave user test full rights to this database. I also opened port 3306 on software firewall. Then I shut off firewall.

Tried to install Joomla, but I get error when connecting to database.

I loaded MySQL Administrator on web server and I am able to connect to MySQL.

Connecting To Remote Database
I'm passing in the ip address of the server, my userid and password, but I get back my userid appended with my local machine name (or maybe it's the local domain, not sure) and it fails to authenticate? Is there any way to override this appending of domain?

Remote Table In A Database
is it possible to create remote virtual tables in mysql? By that I mean
if it is possible to define a table, which actually resides on a remote
mysql server, but which can be accessed and addressed as if the table
would be on the local database.

My intention is to move one table to a remote host, but to be able to
address the table as if it was still on the same machine.

So for example:

SELECT m.header, m.body, m.from, m.to FROM users u, messages m WHERE
u.login=m.login;

would still work, even though the table "users" resides in the database
"moon" on a different host, than the table "message", which resides on
the localhost in the database "alltables".

The problem I'm trying to solve is: I have to webapplications, which
both have a table, which stores login information. Those tables have to
be combined into one and have to be put on one of the hosts only.

One of the application will access the remote user table for logins.
Since many of the SELECTS of this application contain joins like the
example above I'm looking for a way in which I do not have to modify
the selects but can move the login table to a different machine.

Remote Database Updating
I am working on an internet enabled sensor device project. I have a small microcontroller device that is connected to a sensor device. I want this device to dial the ISP and post its readings each day. I would like to know if anyone might have any suggestions on how this could be done.

Once the unit logs onto the server how might I code it to access the data area and post its reading. Also can this even be done. I mean does the microcontroller have to have a special database driver to access the remote database?

Selecting From A Remote Database
I would like to create a stored procedure that could select from a remote database, can i do that with MySQL?

Administrate A Remote Database
How is it possible to administrate a database placed on a remote server, without having access to it's desktop ?When i use the MySql adminstrator program it disables some of the setting, and says it has to bee a localhost connection.I would like to install the dataabase on a server, and afterward just use clients to administrate through.hope someone can explane the setup.

Remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server
from another windows box using ODBC?

Accessing Remote MySQL Database
Is it possible to access remote MySQL databases?

I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.

Connect To Remote Database(MySQL)
is there some sort of setting I need to turn on where I can access the database from another server. So instead of using "localhost" I can use the actual server IP address.

And just for future reference, is this how you set up a application server connecting to a database server?

Database Synchronisation On Two Remote Sites
I am considering the possibility of trying to keep a user table synchronised on two different sites. This is not something i've done before so i'm looking for any tips that might help me on my way.

Basically I was thinking of:

- scheduling php script to connect to both databases via cron to update the table at regular intervals
- generating an xml feed and doing the same thing

Both methods would potentially involve storing a pointer to only read and write the new rows, although perhaps I could use DATETIME to also copy accounts that have been updated since last run.

Probably biggest concern is:
- security... operating in a way that the data is private. The most sensitive data is hashed passwords and postal addresses, I don't think it would be appropriate to not somehow protect this info during transfers. I'm not sure whether SSL is an option (should be) but possibly I was thinking of creating some kind of token system.

- bandwidth. both sites should be fine resource wise but due to my lack of experience in these matters I don't really know what the performance hit will be, and I would like to run the script very often

As far as I know alot of big sites (for example hotel booking engines) use xml in the background to share info but I really have no idea how it all works.

Query Database From Remote Location.
I have a database sitting on my db server, which is part of my office network (which has a domain controller). Access to the outside world is via a router, which is well locked down.

Currently, remote users access the database front end via Terminal Services but this is only a method of accessing an application stored and running on the Database Server.
What I want to do is allow access to the database from a server, which is located in another building (another part of the country). This is essentially an inter/intranet server.

What is the best way for me to get this external server to be able to query my database server?

Downloading A Database From Remote Server Using Ssh?
I need to copy a database from a remote server where I have ssh access to my local computer. Can anyone tell me how to do this?

I was thinking something like this:

- login to ssh
$mysql_admin database_name | local_pc (very simplified)

Connect To Database From A Remote Source
I own a website and plan on running multiple message boards on it...the problem is that I would like a database per board...however my host only gives 1 database....unless I want to pay an extaordinary amount of money for more.

So I have used my PC as a webserver before without any problems and in fact ran a pretty big board off it with php, mysql, phpmyadmin installed.

So my thought was to use a couple of databases off my PC to help run the new boards.

I have created the database...but I'm having trouble with the board connecting.

I'm sure that it's some kind of permission that needs to be inserted for the remote host to connect to my databases.

Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new.

i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?

VB6 Controls Not Populating From Remote MySQL Database
I have created a VB6 app that connects to a web hosted MySQL database. I have created the connection string in my app and used the Port number required by the Web Host. All my data comes back to my VB forms when I run my app from my Win XP development machine, but here is my problem...

I have installed the app using InnoSetup wizard on a Win2K pc at SP4, and it connects successfully to the databases, but my textboxes, labels, comboboxes and datagrids show no data. For example, one of my forms has textboxes and a datagrid, and a statusbar. The textboxes and datagrid are bound to ADO controls which pass SQL statements to MySQL to create the recordset. The statusbar shows the RecordCount from the resulting recordset. The statusbar shows the correct recordset count, but the textboxes and datagrid are empty. This doesn't happen on my development machine.

In my installer, I have installed all the VB Runtime files to the target machines WindowsSystem32 directory, and have installed the OCX files the app uses to the application's directory.

I am at a complete loss to know why I can connect to the database, successfully open a recordset but not populate my forms' controls with the resulting data.

Method - Remote Databases To Central Database
I am looking for the best approach to move data from four remote MySQL database applications back to a central MySQL database in near real time. Each remote database has a low number of transactions up to 15 per second of large data sets (12,000 items). The central database will be replicated across two servers for redundancy.

Database Dumps From Remote Server Via Proxy
How to copy a MYSQL database placed on a remote server using 'mysqldump' where there is a proxy server involved? This proxy server requires user name and password. I have Win XP.

Connecting To Remote Database Via MySQL Administrator
I have used Sql Server and other databases extensively. I have the following questions.

1. I need to connect / manage a SQL database located on a remote web server runnin Linux. My workstation is running Windows XP. I understand that this is what MySQL Administrator is for. Is this correct?

2. Can I run both MySQL and SQL Server on my Windows XP machine?

3. What one book would be the most helpful to help me get a basic table setup?

MySQL Slow To Connect To Remote Database
I was running a PHP/MySQL web site with the database on the local web server. I needed to move the database off the webserver (located in the firewall DMZ) and onto its own machine (behind the firewall on our private network)

Now when I run my web site it goes really slow. I ran mysql from the command line on the web server and connected through to the database machine behind the firewall using
webserver:/# mysql -h 192.168.1.7 -u www-data -p

After I enter the password, it takes around 5-7s before I see the mysql> prompt.

Is mysql trying to do reverse dns on the IP address and timing out? I added the machine details to /etc/hosts so it would be recognized but no improvement. Or do I have something wrong with my mysql configuration?

Copy Records From Tables To Remote Database
there ara two mysql server server1 and server2. server1 ip adress is 192.168.1.2 and
server2 ip adress is 192.168.1.3. both servers have same database. i want to copy records server1 to server2 have can i do this?

Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0.
I have my jsp files on the remote server Z:.
I have my local computer 'A' connected to this server.
I have my MySQL database on my 'A' computer.
I want to know how to connect the remote JSP files with the database?
Currently I am using jdbc.odbc drivers on 'A' computer.
But my server computer has Linux and uses org.gjt.mm.mysql drivers.
Which drivers and Where should be the drivers?

Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0.
I have my jsp files on the remote server.
I have my local computer connected to this server.
I have my MySQL database on my computer.
I want to know how to connect the remote JSP files with the database?
Where should be the ODBC-drivers?

Forcing Remote Reload Of PHP Page After Database Change
I'm developing a mysql database and have users access the data via homemade PHP pages that query data. When the user(s) open the PHP page or query on it, it fetches the data from the database and then refreshes the page showing the new data.

If something in the database changes, like if a user adjusts some value, is it possible for mySql to send out some sort of "autorefresh" signal/trigger to all open connections to the database, which could be used to automatically refresh the user(s) PHP page, thus giving them the most up to date information without them having to manually click refresh?

Remote Connection To Database

i have a web-hosted website and i need it to connect to my mysql database is there anyway i could set this up.