MYSQL :: MySql Remote Connection

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).

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.

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.

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.

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?

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 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?

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 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.

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?

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)".

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.

MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would
like to schedule a task on my local Windows computer to retrieve a
backup/dump of this remote database.

I have contacted my host, and they indicated that the server is only
open to the Internet via mySQL. Therefore, even if I did have access
to that server's command line (which I don't) to create dumps via
mysqldump, I would not be able to retrieve via FTP.

Does anybody have any ideas as to how I can generate backup files from
my local computer through a local command-line interface? I have done
it through a GUI (DBTools), but I would like to have it done via DOS
batch, so that I can schedule it. Does anyone know of any mysql backup
GUIs with command line switches? Or can somebody recommend an
alternate means of getting a local backup?

Remote Mysql
I'm having a weird problem and hours of googling could not help me solve this, so maybe someone here can help me out? I'm by no means experienced with mysql, it just worked all the time so I didnt have to bother looking into it too much :)

We have 2 servers for our forum, one "powerful" server used as webserver where phpBB runs on, and one server that just holds the database (we got that after we found that code & database on 1 server caused overload).

So far, everything went fine for nearly a year now and I had nothing to do with all of it, all I had to do back then was edit a variable on my.cnf on the database-server I think, and then it worked.

Now the webserver's power unit broke, and after that the database had all these little errors on several tables, so I went to phpMyAdmin, marked them all and clicked "repair" - probably/like/surely a stupid move [my excuse: i was tired & in a rush as I did this from work] as the tables were rather big in size (several hundred mb). As expected, the forums didnt work during that, all I got was the typical phpBB "could not connect to database"-message. This went on for ages without anything happening, the tables just stayed "in use" (I could still connect to phpMyAdmin afterall).

After it wouldnt work, I restarted mysql, i restarted the server - those tables still stayed in use, so I flushed the whole database and installed a backup into another database, changed forum-configuration to read from the new db and thought things would be fine, but they weren't.

It just won't connect to mysql it seems, at first I thought some table must be still corrupted, but after some trying out, I realized that the database/forums DO work when being addressed as "localhost" from phpBB-files running on the database-server. When I change the configuration to connect via the IP of the server instead, it will give me the "Could not connect"-error just as it does when I try to connect from the webserver.

I checked netstat on the db-server to see if the the mysql-port was open and being listened to, and got this:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

this does mean it's theoretically working, right?

I also tried to grant all priviledges again on mysql, but didnt change anything either - do you have any idea what I could do? This is driving me nuts (especially as I can see the forums running fine when connected to by localhost).

As I said - this happened suddenly and has been working before for nearly a year, that's what puzzles me most, I didnt change anything on that server mysql runs on!

Remote MySql
I have make a php application and i want to use mysql for the database in different computer, the computer ip is 10.20.37.77 and mysql port 3306, the password = "root"

here is the code

$MySQL_Username = "root";
$MySQL_Host = "10.20.37.77";
$MySQL_Passwd = "root" ;
$MySQL_DB = "squid";
$db = mysql_connect( $MySQL_Host , $MySQL_Username , $MySQL_Passwd ) ;

the error :
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'xeon' (using password: NO) in D:Program

if the php application use mysql in localhost it work
$MySQL_Username = "root";
$MySQL_Host = "localhost";
$MySQL_Passwd = "" ;
$MySQL_DB = "squid";
$db = mysql_connect( $MySQL_Host , $MySQL_Username , $MySQL_Passwd ) ;

Mysql Remote Synchronization
I need to do a two way synchronization between my web server and a laptop. The laptop is located in eastern africa and does not always have an internet connection. The web server needs to be the master, (located in the U.S.) and the laptop needs to be the slave.

Whenever the web server makes changes the laptop needs to be updated and visa-versa. Does anyone know of program or some code that could help me with this? If so is there a way to save the code so the client (on the laptop) could dial-up and press a 'Synchronize' button and have the code run?

Connect To Mysql Remote
I want to access my mysql server remote, I found that by default --skip-networking is on (Salckware - /etc/rc.d/rc.mysqld in /etc/my.cnf it is commented). So I deceide to remove it after that mysql doesn't want to start. So I try to run it "manual". I've run those 2 command:

(1)
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
--pid-file=/var/run/mysql/mysql.pid &

This gives me:
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
060822 21:24:17 mysqld ended

(2)
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --skip-networking &
This works perfect, but only with local connection, no remote connections :/

Any ideas ?

Using MS Access With Remote MySQL
I'm trying to use MS Access in order to list, edit, and add data to a MySQL database located on a remote server. I can get the tables to link (via ODBC), and display OK in an MS Access form. However, I can't seem to edit/change any of the fields. Suggestions?

Query Remote Mysql
I would like to hear your opinions how I best tackle my problem. I´m writing a game in c++ that (in the future) people can download from my website. All users have to sign in and have a record in de database. Now I want to integrate the online database in my game (example players picture). Is it possible to query my database trough the C++ client programm(game) ?
It has to work in both ways. Query de dB TO ins

Remote MySQL Login With Os X
I need to access my MySQL server running on an os x (panther) machine remotely from another machine running os x. Ive enabled SSH in system preferences but i dont really know where to go from there. ive been tralling the web for a good while now and i cant really find any info to help me. I'd like to use a gui client to login like CocoaMySQL.

MySQL Remote Administrator
i will like to remote into mysql data base
what program ca i download

Connect To Remote Mysql
I had mysql working locally with no prob, I just got my hosting, login to cpanel, mysql add a db, add a user, try to connect to the db on my hosting server via my local mysql command line
cd mysql
cd bin
mysql -h xxxxxx -u username
I end up with username@something, access denied, I am behind firewall (these days, who doesn't). I think the username being appended with @something is the root cause of access denying, but I couldn't find a way to get around it

MySQL Remote Access
I want to be able to access my MySQL database that I installed on linux, from my Windows 2000 machine. I will be using the database from various programs such as VB 6.0, MS Access, etc.
I have installed MyODBC on both my linux machine and my Windows 2000 machine. I want to be able to access the database through this MyODBC connection on my Windows machine but I'm not sure how to go about setting this up on both machines. I'm am looking for some advice as to how to set this up or if anyone can point me to some good information on the web

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?

Connecting To Remote MySQL Problem
I set up a linux server for Apache, PHP and MySQL last night.

A problem remains. I can't connect to MYSQL with MySQL Administrator running on another machine. The error says I cannot connect 'hostnamt' of the machine I am on.

I can connect via command line on the linux server, and I have added entries in the user table specifying host as '*' with the account I am trying to use.

I flushed privileges and even rebooted the machine.

Is there some global setting that I must change to allow remote connections?

How Can I Connect To A Remote Mysql Server
How can I connect to a remote mysql server ...

Connect To Remote Mysql Through Terminal...help
Is it possible to telnet or ssh to my paid webhost's mysql through the terminal on mac os x without installing mysql locally? (using the terminal to control mysql ). I really don't want to install it locally if I can avoid it as I wont be using my computer as a server. If so how?

Connecting To Remote Mysql Using Mysqladmin
I think Idid this before but cannot remember what i did. I want to use mysql admin to connect to remote mysql server as localhost so I can set server side features without having to be on the mysql server itself. I remember something in the way of "sip networking" option or something like this.

MySQL Max Connections Remote And Local
My website runs on two servers. One is mean't for PHP and the other is the database MySQL. Whenever a request is made, the PHP attempts to connect to the MySQL via a remove host variable in the mysql_pconnect() function. This works fine, however when it comes down to having lots of connections in the my.cnf file, which one do I edit?

max_connections = 1000

Now do I set this in the MySQL only, or do I set it in the PHP server as well?

Remote MySQL Connections, Still Not Working
I've read, and done all the tutorials, forum posts, and comments I could find regarding setting up a mysql server access for remote connections, but I still seem to have problems. I have a LAMP server running behind a closed router connection. A dynamic DNS is masking the connection, and I have the appropriate ports open for HTTP, SSH, VNC, FTP, and I thought MySQL (3306). But for some reason I still cannot get MySQL to connect from a foreign host.

The I have port forwarding (3306) to the correct system behind the router, and I can access the server just fine via http/ftp. The MySQL server is happily running PHP MyAdmin with the localhost connection too. I've set a (actually a couple now) user to have the ip access of "%", and granted all permissions to that user, flushed the permissions, even restarted the server. I still can't get the remote connection to work.

Connect To Remote MySql Using MS Access Via IP
I have a MySql database on a remote webserver. I used phpMyAdmin to set everything up. I would like to use MS Access as the front-end to link to the tables in the remote MySql database so I can edit, add, delete data using an Access form.

My phpMyAdmin is on a server that has an IP address (like 12.34.56.78:8585). So I tried setting up a DSN on my home system using the same IP address and MyODBC Connector. When I put in the IP as server name, and the user/pass info, when I click test it just sits there for a long time and then I get an error:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '12.34.56.78' (10060)

Remote ODBC Connections To MYSQL
I have a requirement to do some standard table work with existing online survey software (PHP based- using MYSQL). I would like to test the ability to do this work from desktop clients such as access or open office.
I have set up an ODBC connection on my machine with appropriate passwords etc. When I run the test in the WinXP ODBC diaglog, it is says that connection is succesfull.

However, when I try to use the same DSN in ACCESS or the database component of Open Office, it is that it is unable to make the connection. For example in ACCESS, trying to link tables, the message comes that the ODBC call fails.]

In OPEN OFFICE when I do the test connection, I get "ACCESS DENIED" for user... which is the user account and password that I use in the web based projects.

Connecting To A Remote MySQL Server
I havn't done this before and i'm not sure how to do it. I have another computer on a LAN that is running a mysql server and is the machine that is also running the intranet server which i am working on. What i want to know is how to connect to this server from my MySQL console so i can administer the databases without having to be in the main machine.

I thought it would be as simple as using the IP address but this doesn't seem to do it. Can i connect annonymously like i can from the host or do i have to have a user account setup?