MYSQL :: Remote MySQL Connection Fails

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.

Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!).

I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection.

What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used).

I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.

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?

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)

Database Connection Fails
I've been having problems with my CGI script, it overloads the
server. I think it's because the database connection fails because
the following error is logged whenever the server overloads.

DBI->connect(server=localhost;database=Employee) failed: at db.pm
line 53
db.cgi:: Could not connect to database
db.cgi:: No database connection exists
db.cgi:: No database connection exists

And I use these settings to run mysqld.

/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I read some documentation that skip-external-locking should be used
instead of skip-locking, but that seems like a minor thing. I'm not
entirely sure it is the database connections, I'm just trying to
eliminate possible causes.

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

Query Fails In MySQL 5
I just migrated a Mambo CMS site from a server runing MySQL 4 something to one running MySQL 5.0 and am getting one problem (was expecting many more) with a query generated in the admin section:

SELECT c . * , g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name
FROM mos_content AS c, mos_categories AS cc, mos_sections AS s
LEFT JOIN mos_users AS u ON u.id = c.checked_out
LEFT JOIN mos_groups AS g ON g.id = c.access
LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id
WHERE c.state >=0
AND c.catid = cc.id
AND cc.section = s.id
AND s.scope = 'content'
AND c.sectionid = ཊ'
ORDER BY cc.ordering, cc.title, c.ordering
LIMIT 0 , 10

MySQL said: Documentation
#1054 - Unknown column 'c.checked_out' in 'on clause'
The problem appears to be with the fact that the table mos_content is aliased as c and the the SELECT uses a wilcard to select all its columns. For some reason, when the ON clause test the value in any of the colums using the alias, it says they are onknown.

Mysql Fulltext Search... Fails???
Something seems to be wrong. See, I make query:
MySQL
SELECT DISTINCT g.GameID, g.Title, p.FullName PlatformFROM game gINNER JOIN platform p ON p.PlatformID = g.PlatformIDWHERE g.`Title` LIKE '%age%'

I get results like:
res.txt
That's OK.
And when I make query:

MySQL
SELECT DISTINCT g.GameID, g.Title, p.FullName PlatformFROM game gINNER JOIN platform p ON p.PlatformID = g.PlatformIDWHERE MATCH(g.`Title`) AGAINST('age')
OR

MySQL
SELECT DISTINCT g.GameID, g.Title, p.FullName PlatformFROM game gINNER JOIN platform p ON p.PlatformID = g.PlatformIDWHERE MATCH(g.`Title`) AGAINST('age' IN BOOLEAN MODE)
It gives me NOTHING!
Empty set and that's all... What's wrong???

Mysql 4.x Week Function Fails
I think there is a bug in mysql 4:

select week("2003-08-15") from po.orders limit 1;

produces: 32

after:

set session default_week_format=3;

it produces: 33 (which is correct in the Netherlands)

The documentation states:

set global default_week_format=3; (As root!)

This command should set the default_week_format. This command fails:

mysql> set global default_week_format=3;
Query OK, 0 rows affected (0.00 sec)

mysql> select week('2003-08-14');
+--------------------+
| week('2003-08-14') |
+--------------------+
| 32 |
+--------------------+
1 row in set (0.00 sec)

This result is incorrect. It should be 33.

If I use:

mysql> set session default_week_format=3;
Query OK, 0 rows affected (0.00 sec)

mysql> select week('2003-08-14');
+--------------------+
| week('2003-08-14') |
+--------------------+
| 33 |
+--------------------+
1 row in set (0.00 sec)

This is result is correct...

I use mysql 4.0.14. I also did the same test on mysql 4.1 alpha, which has
the same results.

Harm de Laat
Informatiefabriek
The Netherlands

Mysql Query Fails Due To A ' In Data.
I am having problems now with the following code.

An example of my topic.

"we'll meet again"

But when the following line searches for it i get an erro saying that the code is wrong.

I know that it is to do with the ' , but how do Iget round this problem i have. without having to remove all of them from the data.

$topics = mysql_query("SELECT * FROM `forum_topics` WHERE `topic` = '" . $topic . "'") or die(mysql_error());

MySQL Fails To Launch On Mac OSX Command Error
I just bought kevin Yanks "build your own database driven website using php & MySQL" and I was going step by step on the installation process for Mac OSX users. After I installed MySQL and attempted to login using the:

shell%sudo/usr/local/mysql/bin/mysqld_safe

command i get this error:

[Denise-Womacs-Computer:~] denisewo% shell%sudo/usr/local/mysql/bin/mysqld_safe
shell%sudo/usr/local/mysql/bin/mysqld_safe: Command not found.

MySQL Fails To Start After Reboot In Win2K
I get this error (code 87).
I install MySQL 5.0, everything is fine.
I can work with it all day, no problem, all month, no problem.
I reboot ONCE, it fails to start automatically.
I manually start it... FAIL AGAIN.
I reinstall, all ok.

I catch too much info on google and I've read like 20 pages without any solution... just the same problem.....

Update Query Fails In Previous MySQL Version
The following query runs fine on my development server (v4.0.17):

"update user inner join events on user.username = events.username
set user.LastMessageDate = '$current_time'
where events.text_sent=0 and events.to_mobile >0 and events.GMT_event_send_time<='$send_time'"

but fails on my production server running v3.23.56.

Anyone any ideas why it doesn't run and what I need to do to fix it?

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

Fails Normalization?
I have a massive table with around 10 million records. Probably 50% of these records have redundant information. For example maybe 1 column out of 15 is different between 2 or 3 different records. Note: the address is divided into pieces in the actual database, but I wrote it as one field in this example.

ID...Name...Address....Cat....Lat..........Long...
123 ABC 123 Main St 45 3387287 -12077273
124 ABC 123 Main St 87 3387287 -12077273
125 ABC 123 Main St 64 3387287 -12077273
etc
I'm thinking that if I could collect all these Cat values and put them into 1 single column, maybe seperated by semicolons or something, that I could improve the performance of queries on the data.

ID...Name...Address.........Cat........Lat..........Long...
123 ABC 123 Main St 45;87;64 3387287 -12077273
etc
The main problems I forsee with this method is if my user is searching for Category 64, I'll have to use a LIKE '%64%' statement or something inefficient.

Another possible solution might be to separate the data into normalized tables such as this:

AddressTable:
ID...Name...Address.......Lat..........Long...
123 ABC 123 Main St 3387287 -12077273

CatsTable:
ID...AddID...Cat
1 123 45
2 123 87
3 123 64
I'm afraid that if I have a 5 million row AddressTable and a 10 million row CatsTable that running constant joins would bog down the system.

Update Sql Fails For 4.0.26
I executed the following sql commands on 4.0.26(linux)

drop table gtest;

create table gtest(id int default 116, name varchar(20) default 'peter');

insert into gtest(id, name) values(100, default);

select * from gtest;

+------+-------+
| id | name |
+------+-------+
| 100 | peter |
+------+-------+

1 row in set (0.00 sec)

Then i tried the following

update gtest set id=default;
update gtest set name=default;

I get the following error

ERROR 1064: 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 'default' at line 1

I looked up the docs and its a SQL stmt parse error.

Update Fails
I'll put this very simply, will give my current code if necessary (first trying to explain it here I came to an conclusion I'd better erase it and only ask..)

I have a script, which by using mysql_affected rows, checks if UPDATE query was used to update already existing data. If that fails, INSERT query will create that data. However Mysql only returns affected rows as true, if the old data is different than the new one.

What I'm asking here is - Which do you think is the best way to update - or if nothing to update - insert new data to sql. I guess REPLACE wont work when it should be done by id fields?

Replication Fails
we want to set up a replication server to distinguish between reads and writes
where one database server is for reads (m1), and the other is for writes (m2)
m1 will replicate the data from m2
so that when we serve pages, users only connect to the reads database server
now, what we need is a system whereby we are notified if replication stops for whatever reason
so that we can switch reads to the write server temporarily or restart the slave
does anyone know of an app or way to get alerted as soon as replication stops?

DNS Lookup Fails
I have a mysql server that is set up in a subdomain. I also have all my permissions set to restrict users from this domin (i.e.) 'user'@'%.sub.domain.com'. On ocassion the DNS lookup seems to fail, and the IP doesn't from which the user is connecting to doesn't get resolved to a DNS name. In such cases, users can not connect because the domain name is no longer being used as the host, but the ip. The mysql server is running on windows. I don't beleive this to be an error with mysql, but i'm wondering if there is some kind of mysql.hosts file in which i can enter the ip's and respective DNS entries for known connecting computers? I'm just fishing here, maybe there is another work around for this, but i want to avoid having to make duplicate entries for each user: one for the DNS and one for the IP.
These occurences are few and far between, but most other windows apps don't seem to be to affected by this, i suppose because of the way it caches domain names, but that is just a guess.

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