Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




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?




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
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?

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?

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.

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

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 ?

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

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?

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)


Connect MYSQL From A Remote Location
I can connect to MYSQl via PHPmyadmin...only on the localhost. What do I need to do - to connnect, say from home or off the localhost?

Connect To A Remote MySQL Server On The LAN
The MySQL setup on my WinXP machine runs fine with host localhost, username root, and my password. But I can't seem to access my databases from a different machine on my LAN. When I try to connect from another network PC , I always get:

MySQL Error No 2003
Cannot connect to MySQL server on 'remotehost' (10060)

All the settings in my ini seem correct. I've allowed TCP/IP connections. I know which port to specify. Did I forget to do something on the LAN to allow remote access? I've tried sharing the basedir and datadir folders. That didn't work.

I also tried using IPs instead of hostnames. Didn't work either.

When I try to ping the remote host (using MySQL Administrator), I just get a timeout error.

Cannot Connect To Remote Host MySQL
I'm trying to connect Mysql query browser from my PC (NT) to MySQL on a remote host. I always get the error message :-

"MySQL Error Number 2003"
"Can't connect to MySQL server on 'whatever.com' (10060)"

I've tried with Mysql control centre, and navicat, and they report the same error message.

I CAN connect from dreamweaver, but I really want some good GUI tools to administer the DB and data.there is phpMyAdmin on the remote site - but it bugs me.

Can't Connect To Remote MySQL Server
I am developing a site on a remote cPanel system and I am not able to connect to the MySQL database from my location. My application can connect to the server using localhost just fine.

I have ensured that the correct port is open in the firewall (the server responds to telnet on that port) and I have added our IP address as an access host in the MySQL area of the client's cPanel but I am still unable to connect.
The exact error message when I try to connect is:

Access denied for user: 'user@<my IP>' to database 'user_database'

Connect To A Remote MySQL Server
I need to connect to a remote mySQL server. I have the IP address, userID, and password. When I try using these from another computer I get an "access restricted" error. How do I get to this remote mySQL server?

Remote Connect To Mysql Server
My host says that I don't need to login to my server in order to connect to my mysql server. They say all I need to do is enter this command into a mysql client:

mysql -h xxx.xxx.131.240 -u User -p Database
Password

However, they don't want to mention any client to use to connect with.
What client can I use? Putty? Where do I enter that command?

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.

How To Connect To A Remote Host Using MySQL Command Line Client
I can't establish a connection with a remote host using MySQL Command Line Client. ODBC conn setup successfully. Databases on this remote host can be reached using Crystal Reports. I open MySQL Command Line Client > prompted to enter a password > done successfully so I can connect to local databases. The following is entered to connect to remote host:

mysql -h hostname -u myuserid -p

but once I hit enter nothing happens.

Slow Connect
Does anybody know why it sometimes takes more than 10 seconds to connect to a database and sometimes it just takes half a millisecond?

Connect To A Remote DB
Is it possable to to have a program on my server that can
access his db?

<?php
MYSQL_CONNECT("http://remotehost.com","db_name","pass_word")
OR DIE("Keine Verbindung zur Datenbank");
mysql_select_db("db")
or die("Didn't work again");

Remote Connect
I've installed MySQL 4.1.12 on my server, I can connect from the local
machine with navicat, but
not from a remote machine. I checked with 'nedstat' and there is something
listening on port 3306.

I have tried several users and settings. What i want is to set a user name
(:support) and that this user
can connect remotely with navicat to the mysql server.
How would I do this? Or what am I doing wrong?

Connect To A Remote DB
just started a cource in mysql using the mysql db on the instructers
server . Is it possable to to have a program on my server that can
access his db?

<?php
MYSQL_CONNECT("http://remotehost.com","db_name","pass_word")
OR DIE("Keine Verbindung zur Datenbank");
mysql_select_db("db")
or die("Didn't work again");
?>Paul

Can't Connect From Remote Machine
I am writing some code in ASP3 on an XP windows machine. I am trying to connect to a linux machine which is Redhat 7.3 that is hosting my MySQL database. I am use this code to connect.

objConn.Open "Driver={mySQL};Server=http://4.7.165.99;Port=3306;Option=131072;
Stmt=;Database=DB name;Uid=User Id;Pwd=MyPassword;"

This is the Error message I keep getting:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have been looking all over the web, and can't find how to fix this issue, can anyone help me?

Connect To Remote Server
I am very new at this. I installed MySQL and PHP on my Hard drive. I can connect to MySQL through localhost on my hard drive. We have a server at work at a remote location. He just installed MySQL and gave me a password on root. As far as I know there are no databases created. I need to connect to the remote server and create a new user and database.

I've downloaded Secure CRT but don't understand how to use it. I entered my ip addresss in a new session and it seems to connect but then it says session fails.

I put a test script up and just get an error message. Should this script at least not give me an error message. Should I contact the person in charge of the server?

<?

/**
 * Connect to the mysql database.
 */
$conn = mysql_connect("localhost", "root", "password") or die(mysql_error());

?>

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Connect To Remote Server
I have created a database in a remote host using MySQL 5.0. I created tables using the control panel of the host. I accessed the tables several times using the same procedure.
Recently, I downloaded MySQL Admin and tried to connect to the remote server. Nothing happens. It just froze there without any message or what. Is there a secret way of doing this? I can connect to a remote host in a local network but when it comes to using the internet via a router I always encounter this same kind of problem.

Can't Connect To Remote Host (10061)
I'm running MySQL server on a WinXP box at home. I have a cable modem/router. I've set up port forwarding on port 3306 to the machine running MySQL. I can connect locally just fine, but when I try to connect from a remote location using:

mysql -h xxx.xxx.xxx.xxx -P 3306 -u root -p mysql

I get:
ERROR 2003: Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)

When I try:
mysqladmin ping -h xxx.xxx.xxx.xxx

Code:

Mysqld Restarting On Remote Connect
I'm on FreeBSD 5.4 with mysql-server-4.1.18_2.
Whenever I connect to mysql from a remote client, I get:

Mysql error number 2013
lost connection to mysql during query

Also, the following is logged:

060506 09:47:25 mysqld restarted
060506 9:47:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060506 9:47:26 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 642388.
InnoDB: Doing recovery: scanned up to log sequence number 0 642388
InnoDB: Last MySQL binlog file position 0 79, file name ./isd-bin.018710
060506 9:47:26 InnoDB: Flushing modified pages from the buffer pool...
060506 9:47:26 InnoDB: Started; log sequence number 0 642388
/usr/local/libexec/mysqld: ready for connections.
Version: '4.1.18-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.18_2

mysql works fine from localhost and I've granted permissions to connect from certain remote hosts. I just don't know why mysql restarts when a remote host tries to connect.

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.

Unable To Connect To Database Server. Can't Connect To MySQL Server On 'localhost' (10055)
I am running a PHP application with mySQL . Some times it gives the following error.
I do not understrand why this error occures .

today i am using the application but it is not giving the error but error occures yested day .

Unable to connect to Database Server. Can't connect to MySQL server on 'localhost' (10055).

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.

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?

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 Do I Enable Remote Access To MySQL Database Server
I want to connect to my mysql server which is seperate on an external server but i dont know how to enable remote access to MySQL database. The mysql server is on xp and running mysql 5.

Backup/Restore Mysql Database From Remote Server To Local Pc
Im trying to download mysql database "dbproducts1" which is residing in my webhost's server (Linux). From telnet i backed up using "mysqldump -u -p dbproducts1 > dbproducts1.sql"

Then i downloaded this file via ftp to my local pc(WinXP). Now on my local pc to restore database i went to command prompt and i did following:

mysql -u -p dbproducts1 < dbproducts1.sql

I got following error:

ERROR 1064 (42000) at line 380: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use

 near '-workshop (
  title varchar(250) NOT NULL default '',
  decription longtext NOT ' at line 1

I opened the phpmyadmin and found that dbproducts1 database was restored but with only few tables i.e. not all tables in the db was restored.

Can somebody please help me to backup/restore this database. I checked the mysql server version and found following:

server version: 5.0.24a-community in my local winxp pc
server version: 3.23.36 in my webhost's server (Linux)

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?

Cannot Connect To Mysql Database
I am creating a html page to allow user submit their inputs in the text fields and the inputs they inserted will be submitted into the table "account" which is in "myfyp" database. I created the database using the PHPMyAdmin and I am using localhost as the webserver.

The problem now is I cannot connect into the database which I received the connection error message as I have set in the codes. The PHP file which is linked with the HTML form i created is namely "register.php", while the connection file is "connect.php", and the HTML form is "register.html". Code:

How To Connect To MySQL Database
I have a program run in mysql database flatform (note that this program run and creat some mysql talble- i must not install mysql server). Now i want to connect to this database to view these table. I have tried to use mysql control center but it doesn't work (i think it because my program not have mysql server)

Connect One MySQL Database To Another
I need to connect a MySQL database on one server to another MySQL database on another server. The situation is similar to DBlinks in Oracle.

I know if you want to connect to another DB on the same server, you can use something like:

select a.cola, b.colc from thisdb.tablename as a, thatdb.tablename as b where a.colb = b.colb;

I need something similar but both databases reside on different servers altogether. Is it possible in MySQL and how can it be done?

Can't Connect To Mysql 5 Database.
I just installed the latest one but when i try to connect to it with MySQL administrator it sais im connecting to an MySQL 3.x server. and that it can only connect to 4.x ore higher.May it be something wrong in the setttings causing this error?

Could Not Connect To The Database, Please Recheck The Settings You Specified. Also Make Sure That A Database With The Name You Specified Already Exists On The Database Server. PhpAdsNew Will Not Create The Database For You, You Must Create It Manually
The error message I get above is the same everytime when trying to install phpAdsnew. I have tried everything. I am hosted through yahoo! and have actually succesfully installed scripts before even though I know nothing about it. Now that I have a "auto-install", it does not work. Yahoo! also offers php-nuke with the auto-install where you just click a few buttons, and I get a similar error stating that it can not conect to the database.

Please can anyone help me and tell me what I am doing wrong?

Connect A FTP Server With A MySQL Database
I want to connect a FTP server with a MySQL database but I don't know if it possible...
In fact, I have a FTP server with some documents and I want to store these documents in my database... Is it possible?

Connect MySQL To An Different Database Through ODBC
Is it possible to make a statement where you can import selected tables from a different datasource? Something like

INSERT INTO mysqltable
SELECT * FROM odbctable

Where "odbctable" connects through a connection string in de ODBC manager of Windows.
I know of a MySQL ODBC driver, but can MySQL communicate with ODBC itself on a Windows platform the other way around?

Connect To MySQL Database Remotely
Im trying to connect to my MySQL database from a remote server. Im using the below asp srcipt but im having no luck. Im getting this error:

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

Can anyone tell me what i need to download to get the connection working or what settings i need to change? Im happy to change the driver im using. Im using Unbunu Server with MySQL 4.1.1 . Code:

Even Root Cannot Connect To Database 'mysql'
The version of my mysql server is 3.23.58. Before hand, everything works fine. However, when I connect to the data server sit in host 'A' from host 'B' by jdbc. As mysql's user table denied the access from host 'B', I know when attribute 'host' in table 'user' is set to '%' will fix the problem, However, I set it graphically from phpmyadmin.

After setting, the direct result is I cannot connect to any databases in this server@A even from A the error msg is: ERROR 1044: Access denied for user: '@localhost' to database 'mysql'. By googling, I copied the 'user.frm', 'user.MYD', 'user.MYI' from another host to the corresponding path in host A and restart mysqld.

It doesn't work. Then, I tried 'mysql_install_db', gone in vain either. It cost me nearly 2 whole days . I have many important databases stored in this server, I am afraind the install of a new one will bring more problems. Any suggestions, or ideas?

Connect Frm Cmd Line But Not Via Php To Mysql Database.
I have installed a new issue of mysql 4.1 and am able to build and control a database via the cmd line. However I can't connect using php. My system is windows XP.

My php commands require a pw and user name and I don't have a user name. I tried to connect to the root with php and could not. Below is the results and the php program I used. Code:

Connect To MySQL Database From Another Host.
I am trying to connect to MySQL database at on host (DBhost) from another host (PROGRAMhost).

While I try to connect to the database at DBhost from DBhost itself the next is working fine for me: mysql_connect("localhost","dbname","dbpassword")

Now I am trying to find out what to use instead of localhost? I tried to replace localhost with host's url : port (I tried number of ports) but this is not working (even when I am connecting from DBhost itself). How can I find out what is the proper value to use instead of localhost?

Cant Connect To Database With MySQL Administrator
I have to MySQL databases set up on different servers.  No matter what I try I cannot connect to either of them with any windows based clients such as MySQL adminstrator.  Both databases have users that allow a connection from any where and I can connect to them between servers just not windows.

Cannot Connect To MySQL Database Using An Applet
I have a database I created in mySQL. I've been entering data every day
into the database using a Java application that I wrote. The database
and the Java program are on the same Win 98 SE machine.

I've been working on another program (an applet) to send and receive
data over the internet. I got the applet to connect with the database
and receive data. All the while I was developing the applet, I would
tell it to find the database at 127.0.0.1 if I wasn't connected to the
internet, or I'd give it the current IP address of my connection if I
was. This seemed to work fine all along.

Now that the program is nearing completion, I uploaded a copy of it to
my personal web space to give it a "real-life" try. Code:


Copyright © 2005-08 www.BigResource.com, All rights reserved