MYSQL :: Query Browser When Opened Via Remote Desktop Connection

Cant Load Text File Into Table From Remote Browser
I'm trying to run:

$sql = "LOAD DATA INFILE 'E:AHLog.txt' REPLACE INTO TABLE `items`
FIELDS TERMINATED BY '' LINES TERMINATED BY ''";
$result = mysql_query($sql);

And I thought that "REPLACE" would take care of repeating rows, but it doesn't. How do I write a mysql command that only inserts UNIQUE rows, and not repeat rows?

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

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.

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.

32763 Opened Tables In 3 Days...
32763 Opened tables in 3 days...

The MySQL Manual says "If the value is quite big" you should increase your table_cache. What is quite big for 7 sites running PHP MySQL?

What should my table_cache be set to.

Query Browser
I am looking for graphical query tool to work with MySQL 4.1. I installed a copy of their query browser, but get the following error.

MySQL Error Nr. 1251
Client does not support authentication protocol requested by server; consider upgrading MySQL client

Anyone have any insight into this error as I think it should work with 4.1, or otherwise have any suggestions for a query tool?

Query Browser
I'm having a hard time with the Query Browser. I can't figure out how to view the rows. When I click on the table in the Browser, nothing shows up and at the bottom there is a message saying Library Error Number 3. I am sure this is something simple but it's making me tear my hair out.

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?

Mysql Query Browser
I wander how can i connect to database by using mysql query browser using my cpanel account
remotemysqlhost,username, password

Browser Address Bar Query
How could I execute a query in the address bar of my web browser?

Starting Query Browser
i installed mysql server 5.0 and other GUI components and the connector.in windows XP from the start menu i click my sql query browser and the dialogue box appears asking the host ,username and password and giving the port 3306(already filled in)i give localhost and the password which i gave during installation ,and an error comes saying mysql error 1045:access denied for user ODBC@localhost.

Using The MySQL Query Browser
I am in the RESULTSET 1 tab and I've tried to run multiple querys in the query window such as:

SELECT PKEY, ENTITYCODE, REQNNUM FROM INVPO.INVPO_POI;
select * from INVPO.INVPO_POI_APV

and I've also tried this in the Script 1 tab but I cannot see any results.

I just want to be able, like in Query Browser in SQL Server, to see sets of results.

Query Browser - Blanko-ed
I am new to this MySQL, and I am using the MySQL Administrator GUI program. I've managed to create the tables but I am unable to populate the data into the table - when I right click the table, the option EDIT TABLE DATA is blanko-ed, but the rest are clickable. When i choose TOOLS, the MySQL Query Browser option is also blanko-ed.

I installed everything under Administrator account level, and I do not know what is the reason. I did not change any setting so far.

Mysql Query Browser
I am trying to run the following statements in mysql query browser

DROP TABLE IF EXISTS `bedbugs`.`airports`;

CREATE TABLE `bedbugs`.`airports` (
`city` char(20) default NULL,
`country` char(20) default NULL,
`name` char(20) NOT NULL default '',
PRIMARY KEY (`name`)
);

basically two different queries through one query window.

I get the following error:

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 ';
CREATE TABLE `bedbugs`.`airports` (
`city` char(20) default NULL,
`cou' at line 1

Can someone explain what is going on. If I comment out either query - the other one runs fine (basically I can run one at a time).

Is this some sort of limitation of the query browser?

Query Browser 1.1.4 Conflicts
I am using MySQL Server 5.0.2 alpha-nt with Mysql query browser 1.1.4 on winXP.
1.
When i open the query browser a WinXP error reporting dialog opens claiming 'mysql-nt.exe has created some error...
2.
When we execute scripts in query browser 1.1.4, it only shows if any errors have occured. How do i see the results of the script. 3.
Besides the statement ' select @var; ' in the browser shows @var as containing NULL even though it soes contain some value
ALso can someone guide me to the download page of mysql server 5.0.1.

MySQL Query Browser
I am using the MySQL Query Browsers, and when I am performing some actions, like changing the character set or collation, it gives my syntax errors and won't commit the change.
Does anybody else have these problems with the MySQL query browser? And how do I fix these?
I am running on MySQL 5.0 Beta, but had same errors on MySQL 4.1

PhpAdmin & MySQL Query Browser
I am new comer to PHP. I come across phpAdmin & MySQL Query Browser, which to my opinion, perform similar task.

Can you guys tell me, phpAdmin & MySQL Query Browser, which one is better?

Export Query Results Through Browser
This would seem simply enough but I am struggling with it. I am using PHP 4 and Mysql 5.0 I need to take the results of a query and allow the user to download the results....

How To Call With Query Browser A Sp With Out Parameter?
I've a stored procedure like as sp_add_value(IN value int, OUT msg Varchar(10)) and i not get call in query browser.

Error While Connecting To The DB Using Query Browser
I am a newbie to mySQL world. I have sucessfully installed the mySQL and also have created a schema and a few user accounts. However when I try to connect to the DB from a REMOTE machine using the mySQL Query Browser, I get the following error:

"MySQL Error Number 2003 - Cant connect to mySQL server on 'myserver.mydomain.org'". However, I am successfully able to ping the server. Here are the specifics:

1. The Host Server where mySQL has been installed is at my home and is connected to the internet via a Broadband Linksys Router.

2. As I do not have a static IP, I registed for a Dynamin DNS service. I made sure that the port 3306 is opened, both at the router and on the machine where mySQL is installed.

3. I am trying to connect to the mySQL server from my home laptop, which is also behind the same Linksys router. I have also tried connecting from a truely remote machine (the one which is not behind this router, but is connected to internet) - again unsuccessfully.

4. The user account using which I am trying to connect has an 2 entries in the mysql.User table - one with column Host=localhost and another with column Host=%.

5. AFter a bit of googling, I found out that this is a common issue when BIND_ADDRESS and SKIP_NETWORKING are left uncommented in my.cnf file. However, I do not have a my.cnf file in the filesystem. And I have not created one..

6. I am able to connect to this mySQL server using SSH (using mysql -h localhost -u userName -p)even from a remote machine.

However I am not able to connect using mySQL query browser. Am I still missing something here?

MySQL-Query-Browser Installation
I am currently migrating a db from SQL Server & MySQL and ? (front end yet
to be decided upon) As I familiarise myself with MySQL populating tables
etc can be quite clumbersome. After reading the MySQL site it appears the
"Query Browser" is the correct tool which I've downloaded, extracted and
followed the instruction for installing it... without success, it doesn't
work.

To clarify what I've done I've:
Downloaded: mysql-query-browser-1.1.6-linux.tar.gz
Extracted it using: tar -vzxf mysql-query-browser-1.1.6-linux.tar.gz
In the doc directory there is a html file that explains the installation
procedure under Linux...

"To install MySQL Query Browser, run this command:
shell> tar --directory=/opt -xzvf mysql-query-browser-version-linux.tar.gz

This installs the application binary in /opt/mysql-query-browser/bin. Change
into that directory and run mysql-query-browser to start the application.
You can replace /opt with your desired installation path."

I have done all of this and the files were extracted
to /opt/mysql-query-browser as expected.

The question is, how do I run the application?

Query Browser 1.28beta OS X Not Usable (for Me)
I'm having some strange problems which seem to have only to do with the Query Browser 1.28 beta for OS X. What I mean is, regardless of what MySQL database I connect to (local OS X or on a Win2k server on the same network), the problems I list below happen consistently; at the same time, Query Browser 1.28beta running on that same Win2k server can manage both its own and my OS X box's MySQL installations just fine. So on to the problems ...

Mysql Query Browser Import From Csv
The only way that I was able to backup my tables was from the mysql query browser export to csv option. I know that I am stuck with having to recreate the table schema's but right now I am having problems importing the tables. I am using phpMyAdmin, since there is no import feature in query browser. The problem that I am having is because double quotes (") are not escaped (") in the text fields, and phpMyAdmin is unable to insert all of the data. Is there a way to fix this issue, I have been able to open all of the files with microsoft excel, which seems to sort the columns out fine, even though they aren't escaped.

Can't Connect Using MySQL Query Browser
I'm having a little problem connecting remotely to my MySql database. First a little background on my setup. All machines are on my home LAN behind a router. Linux Machine; Ubuntu Linux with MySql installed and running without a problem, command line. Windows XP machine with MySql query browser client installed.

The problem comes in with trying to connect the XP machine to the Linux box to access the sql tables. It mainly says it can't connect to my database/schema. I know the database is fine(or at least it seems) because I can SSH over to it and run queries without a problem. I've tried using the IP address, the machine name to connect but nothing works. I've investigated the .sock files, ports and for some reason I can't get a good connection with the Windows client software to my database.

Query Browser Won't Install On SuSE 9.2
MySQL Query Browser won't install on SuSE 9.2 because it requires the following:
libgal-2.0.so.6
libgal-a11y-2.0.so.6

These do not appear on the SuSE installation disks.
I googled and didn't find them available for download
What can I do?

Insert A Record Using MySQL Query Browser
I know I can probably type in the actual query, but I was wondering if there was a means of inserting a record without typing "insert into table_name (blah, blah2) values (blah, blah)". I'm looking for a method as easy as typing into an Excel spreadsheet or Access DB. (I know I'm gonna get bashed for mentioning Microsoft products.)

Error After Installing MySQL Query Browser V. 1.1.20
After installing MySQLQuery Browser on a new computer (Windows XP Pro SP2), it works but there is a constant and rapidly flashing error on the bottom of the application. When you exit the application you get the following error:

Application Error
Exception EAccessViolation in module MySQLQueryBrowser.exe at 0003F211. Access violation at address 00040211. Read of address 00040211.

This application works on 2 other PCs but is acting crazy on the new PC. Any ideas? I know nothing about SQL, I'm just the PC support.

How Do You Import A Mysqldump File Using Query Browser?
I have a MySQL 4.1.5-gamma-nt-max instance running on a Windows 2000 Server box. I have tried creating a script to restore a mysqldump backup file to a schema on that server. Here is my syntax:

set foreign_key_checks=0;
source b:/folderwithdata/data.043006
set foreign_key_checks=1;

When I execute this locally on the server from the command line, it executes without a hitch. However, the server is going to be located in a server farm where I will not have access so I have tried to execute this from my workstation using Query Browser. I launch Query Browser and execute the script and get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use. ErrorNr: 1064 near 'SOURCE B:/FOLDERWITHDATA/DATA.043006 SET FOREIGN_KEY_CHECKS=1' at
line 1

Like I said, it executes fine on the server via command line so I know it's not bombing out on some syntax within the file itself. So I'm assuming it has something to do with how I'm writing the script in the GUI itself.

Running Multiple Queries In Query Browser
What is the magic word to get query browser to execute a string of queries?

CREATE TABLE And MySQL Query Browser
I am using the ODBC 3.51 Driver to Do a "create database" and then create some tables on that database.

I see in the ..mysqldata directory my new database I have created and the associated .frm files, however MySQL Query Browser and Administrator do not see these schema's.

I am guessing it may be due to user privileges. MySQL is running locally and the connection string does not contain a Username and password.

Also, when I do show databases from within the Query Browser, it does not show my Database, only the one that I had created manually.

There must be some more setup that I am not aware of to register the Database or something.