MYSQL :: Windows Remote Gui

Local Host On Windows Allowing Remote Access
We have MySQL running on a server in the US (we are in NZ) the response times to queries can vary, so i have installed MySQL on my Windows XP PC. i can transfer data across overnight using a scheduled task, this allows me to query yesterdays data much quicker - it is used for trends so up to date in not important - the problem i have is this

I want others within the company to be able to connect to my PC to run their own queries against my data. i do not know how to set up the ODBC connections on their PCs to 'talk' to mine. I can set them up to connect to the US with no problem but not to my PC.

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 Connection
How do i connect to a remote (webserver) Mysql from the windows command line?

Remote Control
I have MySQL running on a desktop computer that I log into through logmein.com and this is not the best solution. How can I connect remotely to use the MySQL Command Line Client on my desktop so I don't have to wait so long for each line to appear? I should also point out that this computer is on my LAN, so I shouldn't have to configure the router.

One problem I am running into right now is that when I try to make a new table, I keep getting error 1064 (42000) and I'm not sure why because everything looks correct. Code:

Remote Access
I have a MySQL server running on my iMAC and am able to access my databases locally. What steps do I have to do to allow access from a remote PC thru TCP/IP ? The manuals say it can be done but don't specify what is involved.

Accessing Remote DB
i want to inser data into a remote dB. I cant for the life of me get it to connect. The mysql_connect syntax is straightforward. Ive tried the ip number and domain name, the user name and pass are correct. No firewall probs.

Always an error lilke this:
"Can't connect to MySQL server on '130.220.33.14' (10054)"

I use phpdev to run the files at home. Is there maybe a config I have to change on it to access remotely?

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 Connection
How do i connect to a remote (webserver) Mysql from the windows command line?

Remote OUTFILE
I have three servers (S01,S02,S03)... my aplication PHP run in S01 and there are two databases in S02 and S03.

I make one file and I'm using LOAD DATA LOCAL INFILE INTO tbl_xxx to load file in S01 to S02.

My problem is:

I need export data from S03 to S01 using only mysql.
I'm using SELECT OUTFILE, but this statment is only local.

is it possible?

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

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

Cannot Log In To Remote Server
I am trying to set up a replication server and cannot get past an error trying to log on to the master from the slave. I have tried everything I can think of and am at a loss as to what else I can check/do. The error on the slave server is:

Error: 'Host 'myslave.mydomain.com' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400

The error itself is confusing. Since this is the slave log, the reference to "this MySQL server" does not make sense. I am not (should not be) trying to connect to "this MySQL server" but rather the remote master server. I am guessing that the error is just poorly worded.

I have a user on the master with the host name 'myslave.mydomain.com'. What else is needed to allow that user to connect from the slave host? I tried changing the host name to '%' but that didn't help either. Can someone point me in the right direction?

Remote Admin
how can i remote admin the mysql (i am using mysql 3.23.)
and how can i create users for the remote control (using phpmyadmin 2.2.6)

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

Remote Server
How I can connect my aplication in delphi with database mysql in remote server?

MyODBC And Remote
I'm conected to server and my app works just fine, and I was connecting to MySQL over ODBC (my app is running on winXP)! It was good while I was using only USERNAME with blank PASSWORD in MySQL! But when I put password, I can't connect, and of course my USER/PASS combination is OK! I try to search for known MySQL bug in this version but with no results!

Remote Login
When logging into mysql, mysql appends '@hostname' to whatever the username you provide is. Example:

> mysql -h hostname -u dsb

'dsb' becomes 'dsb@hostname.com'

Does anyone know how to turn that off so that the exact username specified is used.

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 Connecting
The admin on my work server won't give me access to the mysql control panel. So what I'm thinking is using my yahoo mysql database instead.
What would I replace for localhost?

$oConn = mysql_connect("localhost", "user", "pass");

Second question, would yahoo allow remote connects?
Third question, will the queries run slowly when remote connecting?

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?

Connecting To A Remote DB
I am running some website on fedora with VMWARE and my main OS is windows server 2003. I am trying to use db on the windows server but whenever I try to connect to it from fedora I get bug messages.

"Warning ! [2003] - Can't connect to MySQL server on 'ep038' (13)
Server unavailable. Is your MySQL server started ?"

I am sure that the server is started and running on port 3306.
I am sure of the hostname.
I can ping the hostname from fedora so it IS accessible.
I am sure of the login and password (I set them myself).
The weird thing is that when I run a tcpdump, apparently fedora doesnt even try to connect to the remote host database.

Remote Sql Server
I am using PHP on my site and I wanted to play around with myqsql.
Rather than just going ahead and upgrading my account @ a monthly cost for testing, I thought that I would just add mysql on my pc and connect to it from my remotely hosted site.
I opened port 3306 on my firewall.
I can connect to the database but it will not allow me to select the database

Remote Access
I've set up a User account called 'test' for my MySQL database (for use from my Uni). The host value for 'test' is '%' but for some reason I can't connect when accessing the Database from a dynamic dns name.
Test can connect when the JDBC is run using 'localhost' but the connection attempt simply times out when I change the URL to 'bailz.dyndns.org'.
The PC is running behind a router but I can access the web server no problem from outside... it's just MySQL via JDBC that I'm having trouble with.

Remote Site.
i jus completed my first database site and ready to upload. but need to know 2 things.
1. where exactly is the database? ive got my site in the inetpub.. is the database in here C:Program FilesMySQLMySQL Server 4.1 ?
2. how do i upload it along with the site? is there just 1 file to upload or is there lots... ?

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 Access
I have:

Computer A, my computer, through which I can pretty much install anything I'd like.
Computer B, my webserver, a computer on the network that I installed mySQL, and that uses IIS for its server. It also uses Windows, and not UNIX/Linux.

Anyways. I'm trying to setup MySQL so that I can use it remotely from Computer A, either using it directly with something like SSH or Dreamweaver/PHP. However... I'm completely new at this.

Remote Access
I am facing problem when i try to connect to a remote mysql server using mysql_connect command.

It give error " Can't connect to MySQL server on {IP} (10061) in"

I have even added one user and gave it permission to connect from any host (%) and allowed DB rights too.
I have checked that mysql variable -skip_networking is also off.
There was fire wall installed on mysql server but that has been removed but still problem is not solved.

Connecting To Remote Database
I'm using MAMP on a MacBook Pro. The only database connection I've been able to write that doesn't return an error message is on the database "test" that's installed by default:

$link = mysql_connect ("localhost" , "USERNAME", "") or die(mysql_error());
mysql_select_db ("test", $link) or die(mysql_error());
...where USERNAME is a username I created and accidentally applied to all my databases. Anyway, I assumed I could use the database "test," since I can at least connect to it.

But my queries all display error messages, even after I copy the tables they reference into the database test. Finally, I wrote a very simple query:

$Geog = mysql_fetch_assoc(mysql_query("SELECT * FROM gw_geog_gw"));
But I still get the following error message:

Quote:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Users/MyName/Sites/Geobop/Files/World.php on line 7

Does that mean I'm not even connected to the database "test"?

Local Version Same As Remote?
I'm setting up a local development environment and wondering which version of MySQL I should be installing. I will eventually upload files to a server with MySQL 4.0.15, should I use this version for my local dev setup, or can I use 4.1.22 without any problems?

Connecting To A Remote Database....please Help
I'm trying to connect to a remote database, but am not sure how to do that (ie what command I should use in the Terminal). I have a php file that gives me all of the details:
<?
Database Details ----#

$host = "**.**.**.***";
$dbname = "**************";
$dbuser = "**************";
$dbpass = "**************";

Paths Used in Codeing ---#

$root_path = "/home/software/public_html/**************/";
$http_path = "http://www.webaddress.com/**************/";

?>

Triggers To A Remote Database
We make use of a PACS (Picture Archiving and Communication System) and
system to store DICOM (Digital Imaging and Communication in Medicine)
images (like CT scans, MR images etc.) in our Oncology Center. This PACS
system uses mysql as it's native database, in which it stores certain
data as date and time of the examination, it uses InnoDB tables.

We are building another application around it, which will use data from
the PACS tables and will hold additional data in a seperate database in
it's own tables.

Every study has it's own unique identifier which is stored in the PACS
database. Additional data is stored in the additional database, under
the same unique identifier to be able to keep track of the data and link
it to each other.

Now I would like to know if it is possible to add a trigger to the PACS
database which will delete the related information in the additional
database if a record in the PACS database is dropped. This trigger will
have to delete the records in the additional tables before dropping the
data in it's own database, so we can maintain a more compact database
and don't store data which we cannot link to the PACS system anymore.

Problem Of Remote Connectivity From Mac OSX
I have a flash application that work on both plateforms Pc and Mac. In this application i do a connection to a MySqlDatabase to activate it.

so, to make my tests i have a pc and mac on the same home network

to make sure it works fine, i have installed EasyPhp on my PC and MAMP on the Mac, to be able to test the connection to local MySqlServer.

the syntaxe that i use to connect to the database is this one :

mdm.Database.MySQL.connect(host:String, port:String, compression:Boolean, userName:String, password:String, databaseName:String)

So, to connect to local MySqlServer : i have this code:

mdm.Database.MySQL.connect("localhost", "3306", true, "root", "", "DBName");

and it work just fine on the PC using EasyPhp and on the Mac using MAMP. I can connect on my database on each plateform.

So now, i want to connect to our remote MySqlServer, so, to connect to our Private server : i have this code:

mdm.Database.MySQL.connect("64.150.160.230", "3306", true, "userName", "userPassword", "DBName");

on the PC: it works just fine, i am able to connect to our database and do queries on our private server.

on the Mac : it cannot connect... erroe message: unable to connect to server

i really don"t know where could from my problem, i am working on since a week without answers.

Enabling Remote Connections
Can someone tell me how to set up the mysql server to accept remote connections?

Im using mysql 4.1 on Linux Ubuntu 5.10

I have tried editing my.cnf and changing the bind-address from 127.0.0.1 to the server's IP address, but this just results in the server failing to restart with the following error:

Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

What do I have to do to get it to accept local and remote connections? Code:

Remote Access Through SSH Tunnel
I've got a MySQL database being hosted by a company. The site has
phpMyAdmin for external administration, but I'd like to use a program
like EMS MySQL manager, or maybe even an OBDC connection for certain
things. But I can't get the SSH tunnel to work.

I can access the account using an SSH logon through putty, and once in,
I can access MySQL using the terminal. But I can't get port forwarding
to work.

If MySQL is working with phpMyAdmin, shouldn't it be able to work with
an SSH tunnel? Code:

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?

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 ?

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?

Merging Remote Db Into A Central Db
I'm wondering if there is native support for merging data automatically (periodically) from multiple identical mysql databases into a central database.

Mysqldump On Remote Host
I would like to run the mysqldump command on my local machine to dump the DB on my remote production machine. When I try the command:

xxx:~> mysqldump -vvv --host="host name" -u users db_dev
-- Connecting to "host_name"...

mysqldump: Got error: 2003: Can't connect to MySQL server on 'host_name' (110) when trying to connect

FYI, I took out my usernamem and host name and replaced them with users and host name.
Is there a config on the remote prod machine I need to make?

Allowing Remote Login
I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306, the root username, and
the password, but they still can't get access. Of course, no firewalls or
other things in the way.

Is it true that MySQL defaults to local access only, and to enable remote
access you must do something unusual with grants? If so, how would I do
this? (warning, we use the win version, but this question is not a
windows-only thing so it is topical for this list:-)

Remote Database Issue
I am trying to setup Joomla with the following setup.

Web server 192.168.99.80-82 Joomla is specifically at 192.168.99.82
MySQL server 192.168.99.90

I used MySQL Administrator to setup user account which I will call test. Then I right clicked the user and selected Add host from which user can connect. I then typed in 192.168.99.82. I had issues so I also added .80.

I then created a database called Joomla and then gave user test full rights to this database. I also opened port 3306 on software firewall. Then I shut off firewall.

Tried to install Joomla, but I get error when connecting to database.

I loaded MySQL Administrator on web server and I am able to connect to MySQL.

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?

Connecting To Remote Database
I'm passing in the ip address of the server, my userid and password, but I get back my userid appended with my local machine name (or maybe it's the local domain, not sure) and it fails to authenticate? Is there any way to override this appending of domain?

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?

Connecting From Remote Computer
the database is on host xxx.xxx.xxx.333, Im connecting from xxx.xxx.xxx.222
In the 'user' table in the 'mysql' database on 333 i have a user called 'wordpress'. There are numerouse entries for this user, each has a different host, they are...

%
xxx.xxx.xxx.222
localhost

They all have the same password.

I try and connect and get Access denied for user 'wordpress'@'xxx.xxx.xxx.222' (using password: YES)

I then try a mysql command on the 333 server to set permissions for user 'wordpress' on database 'wordpress' like this...

grant select,insert,update, delete on wordpress.* to wordpress@'xxx.xxx.xxx.222' IDENTIFIED BY 'myPassword';

...but it says that is doesnt match any rows in the user table.

They are both windows machines.

Windows Remote Gui

I'm looking for a software: - for Windows - that would allow me to do everything that phpMyAdmin allows to do - To connect to a remote MySQL server - Secure - FREE!

I'm looking for a software:
- for Windows
- that would allow me to do everything that phpMyAdmin allows to do
- To connect to a remote MySQL server
- Secure
- FREE!