473,691 Members | 2,065 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

about remote mysql

10 New Member
i connect mysql remotely. it is very slow
i google search, some web sites said, put
i have done that...however, it is still very slow
i read some web sites, someone said.. change the host file in mysql, however, i cannot find the host file in my mysql directory,
the version i installed is the version for windows.

Can anyone give me some ideas
Jul 26 '09 #1
6 2213
126 New Member
Can you provide more information, is your mysql server stationed on a host? What software are you using to connect it?
Jul 26 '09 #2
10 New Member
thanks very much.

1) mysql_connect(' localhost','roo t','123') ->both mysql and php in the same machines
2) mysql_connect('' ,'root','123') ->both mysql and php in the same machines

the above 2 cases, it works well

3) mysql_connect(' 333.333.333.33' ,'root','123') ->mysql and php in different machines

the speed become very slow

The same case also happen in my python/tkinter programs as well....

The speed is 10 times lower than normal.. always exceed the time limit

i am testing it in the windows version mysql....

Can anyone give me some clue ???
Jul 26 '09 #3
126 New Member
How far are the machines, is it the same network? Or the same country...? What I can see from now, it's not mysql, but network problem.
Jul 26 '09 #4
10 New Member
Dear Canabee.
Thanks..very much...i am not familiar with networking, what i found is if i ping the remote server, it returns the speed of average 180ms. if i ping my localhost, it returns 0ms. Does it means that connecting remote mysql, we needs 180 times than local mysql....

i am totally confused..
Jul 26 '09 #5
126 New Member
Theoretically, yes. 180 ping is usually on really really low speed connections or if you're in Europe and your mySQL server is in the States, or the opposite...
Jul 26 '09 #6
10 New Member
dear canabeez
thanks very much
Jul 26 '09 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

by: filesiteguy | last post by:
Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating. Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers. In my experience, typically web hosting providers only allow localhost access to MySQL databases.
by: JStrummer | last post by:
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...
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be used for high-end commercial application? Thanks
by: Ian Davies | last post by:
Hello all The following code allows me to connect to a local MySQL database on my pc from a VB6 project. **************************************************************************** ** Dim conn As ADODB.Connection Dim cs As String Dim MyServer As String
by: Ike | last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on allowing all incoming and outgoing ports. I have a username and password setup, which CAN connect to this database, from Also on, which is running Tomcat, I have a Java servlet, called, say, servlet.class in WEB-INF/classes. servlet.class has permissions 755, as does WEB-INF/classes. Additionally, I have on...
by: courtney.machi | last post by:
Hello, I am trying to connect to a remote mysql server through php. Here's the code: mysql_connect("my.hostname.edu", "username", "password") or die (mysql_error()); mysql_select_db("db_name") or die ("unable to select db".mysql_error()); $r1 = mysql_query('SELECT * FROM table') ;
by: dronkanoki | last post by:
I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error: Access denied for user: 'username@ipaddress.serviceprovider.net' (Using password: YES) I had MySQL installed locally for testing, and myODBC worked fine. All the other apps I use locally (Dreamweaver, PHPmyAdmin, MySQL Front) work great on the remote server with the same login info. This is my thought (patience, please). My...
by: Jerim | last post by:
I have a script on one server, trying to access the MySQL database on another server. The server with the script is on an outside network, hosted with another company. The MySQL server is here in the office;behind a firewall. Script works fine when it is on the local machine, but when I moved it to the offsite webserver it gives me: Warning: mysql_connect() : Lost connection to MySQL server during query in...
by: Robin S. | last post by:
I've used phpinfo() to confirm settings for mySQL on our host server, and it's not returning accurate info. phpinfo() returns a mySQL client API version of 3.23.54 (uselss for me), where as a SELECT VERSION() query on the mySQL database returns version 5.0.27 (exactly what we need). I think there's something wrong with the mySQL library in PHP. Is there any more thurough method of seeing php's settings for mySQL? Obviously I don't...
by: jmohan | last post by:
Dear Sir/Madam, I develop a website in asp.net with c#. And also, I develop a toolbar in the toolbar studio separately. Aim of the Website: Enabling the visitors to become a member of our webiste by downloading the toolbar from our website. After the member downloads the toolbar, The toolbar is added to the ie browser. The member can get the facilities such as searching, weather online, internet radio,etc., The toolbar includes a...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.