Remote Access To MYSQL Server Host
I am trying to access a mysql database on my old host (I'm doing a CMS migration to something on a different server.) My hosting company doesn't have a CLUE what I'm talking about when I say MYSQL server host (I'm not even sure I do). They keep telling me it's 'localhost'. I can access both dbs through their prospective phpmyadmins.
Is there any way I can find out what the host server is? I would just export the db and then import it into the other one, but all attempts at that have failed.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
Remote Access To My Mysql Server
I ran grant all privileges on *.* to 'root'@'%'; I've got two questions... firstly, when I try to get to it from another machine on the local network it tells me access denied... secondly, I'm on a soho network with a NAT router... what port/ports do I set up to access the mysql server from the outside?
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?
Accessing Remote Mysql Host
I need to access a remote mysql host from my server. All host permissions have been set but the server refuses to connect. I can use a different one and there is no problem. It just seems to be from one specific host that I can't get access.
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.
Remote Access Not Working: Error 1251 Client Does Not Support Authentication Protocol Requested By Server
I'm trying to set up my MySQL database for remote access. I've never been a DB admin so this is all mostly new to me. I am binding to my public IP address, and I have created a new user with the following grant commands run from the mysql command line on the server: mysql> grant all privileges on prs_data.* to 'username'@'%' identified by 'change'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on prs_data.* to 'username'@'localhost' identified by 'change'; Query OK, 0 rows affected (0.01 sec) When I try to connect remotely from another host, here's what happens:
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.
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?
Connecting To A Remote Host
I'm developing a PHP script to update a table on a remote machine. I can connect easy enough but only if I add the % wildcard as a host - to my mind this makes things less secure. How can I get mysql to accept connections from my machine bearing in mind i'm on dial up.
Remote Host Connectivity
I just started using MySQL, and cannot find how to configure host access in the my.cnf file. I want to be able to allow access to a MySQL database from a remote host, and also from a particular network. How do you configure access of this sort?
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:
Copying A Local DB To A Remote Host
I have MySQL running locally on a W2K machine and have imported a large database of over 300,000 records from Access to MySQL. Now I need to isolate this database and upload it to a remote host. I'm a little confused, as the file ibdata1 in my data directory just appears to be a dumping ground for all data in all databases. I have tested this by creating a test database and adding a couple of records. There is a folder named after the database I want, containing .frm and .opt files. How do I isolate the data I need into a "standalone" form that I can use on our remote host? Again, I know that this is a real dumb question but I've been unable to find an answer anywhere else.
What May Be The Host Address Of Mysql Server
My mysql database resides on the server. I have to connect it by navicat or other conversion tool. But there is some problem of host address. It shows the incorrect host address or port no. It seems that host address is wrong. What may be the host address of mysql server.
Unknown MySql Server Host '%'
I have just downloaded and installed MySql 4.1.14. The problem is that I can only connect in the localhost, where I try connect in the % host I receive the message: Error No 2005 Unknown MySql server Host '%' (11001)
Unknown MySQL Server Host
I have a production webApplication running on linux, apache; which most of the time runs fine, except once a while; I receive this warning message: Warning: Unknown MySQL Server Host 'serverName.com' (11) in /usr/local/apache/htdocs/webApplication/db.php on line 12 ...here is my db.php ... <?PHP function dbConn() { $hostname = "servername.com"; $username = "root"; $password = "the_pwd"; $dbname = "mysqldbName"; $dbLink = mysql_connect ($hostname, $username, $password) OR DIE("Unable to connect to database"); mysql_select_db ($dbname) or die("Unable to select database"); return $dbLink; } function dbEnd($dbLink) { mysql_close($dbLink); } ?>
Can't Connect To MySql Server On Local Host
When I installed MySql on the Windows 2000 Proffessional ,it works fine.But I followed the same installation steps in Windows 2k Advanced Server.It gives me this error "can't connect to MySql server on local host".It says failed to start service . I couldn't find any mysqld.exe file in the processes list of the Task manager window. Please tell me steps to get mysqld.exe file appear on the task manager. Kindly let me know the way to get mysql running.I have the Operating System on E: drive of my computer.
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?
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
Host 'localhost' Is Not Allowed To Connect To This MySQL Server
I'm hoping someone can help me out. My instance of mysql was having an issue with too many people connecting to it at once, so I ran the configuration utility. Now all of a sudden, I cannot connect from anywhere including localhost. I keep getting the message Host 'localhost' is not allowed to connect to this MySQL server no matter what method I try of connecting. What I initially did was edit the user table and replaced the root/localhost with root/% and I'm guessing this was overwritten by the utility somehow. Can someone tell me if there's a way I can edit the user database?
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)
Getting Error #2005 Unknow MYSQL Server Host When Login On PhpMyAdmin
The site was designed by some one else with some documentation on passwords and user name at the database server. So I attempted to login using the documented logins and got the following error #2005 - Unknown MySQL Server Host I really don't know what this means. Could it mean that this database server is no longer there?
Error 1130 - Host `johnliam` Is Not Allowed To Connect To This MySQL Server.
I am running my MySQL server on the machine I am trying to connect to and when I try to connect, it says: Error 1130 Host `johnliam` is not allowed to connect to this MySQL server. I configured my username, password, port and everything else in `WinMySQLAdmin 1.4` which is in the bin folder in my server directory, C:mysql .
Connecting To A Remote MySQL Server
I havn't done this before and i'm not sure how to do it. I have another computer on a LAN that is running a mysql server and is the machine that is also running the intranet server which i am working on. What i want to know is how to connect to this server from my MySQL console so i can administer the databases without having to be in the main machine. I thought it would be as simple as using the IP address but this doesn't seem to do it. Can i connect annonymously like i can from the host or do i have to have a user account setup?
Connecting Remote Server In Mysql
Waht is the way to connect the remote database in mysql? right now i am connecting it with localhost as server name but if i want to connect other datasource it showing the error datasource not found.
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.
Connecting To Remote MYSql Server
I want to connect to a remote mysql server from command line. I don't have a mysql client installed on my local machine from which i want to connect to my Data base server.
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?
Connect From Unix Mysql Server To Ms Access Server
Im wondering is it possible to connect through my mysql db (running on fedora core 4) and access the ms access tables on the ms access server? I have a connection setup the other way around using an odbc bridge, is it possible to do this the other way around enabling me to view / edit the access tables through mysql.
Insert Records To Remote Mysql Server
for a insert statement, there are two packets on the network between the client and the server. so, the packet's number will be double of the number of insert statement. that is rough. I want there will be a few packet used for many many insert statement. Is there any way to make that true.
Access To Other Host Sql Database
I currently own a website with various different MySql databases. I use the mysql_connect ("localhost",""....) to connect. I would like to give another website access to this database. What would they have to enter in place of "localhost"?
Cannot Access With Host Other Than 'localhost'
In my "mysql" database (meaning the databased called "mysql") in the table "user", I only have one row, which says: Host = % User = jbrandt Pass = :P All privs = Y However, when I try to access MySQL in PHP by saying: mysql_connect ('my.dns.com', 'jbrandt', ':P');
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)
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?
Access Denied For User 'root'@'host' To Database 'db'
i'm trying to connect from a remote host to a db, and I just cannot. I can make a successful connection to another db (test), but not to the productive db. I have tried some things (flush privileges, grant everything), but I still cannot connect to the db.
"Host Not Allowed To Connect To This MySQL Server"
I just recently installed Fedora Core 4 and was just messing around with the MySQL server, I tried using mysql-administrator to connect to the server and i get this strange error "#HY000Host '192.168.1.104' is not allowed to connect to this MySQL server", I saw mysqlaccess and tried granting myself access to this server but i still get the same error while trying to connect!? Any thoughts?
Want To Move Home DB To Web Host Server
I have created a DB on my system at home. All I want to do is transfer the DB to my web host which has phpadmin and mySQL. I have tried to export the db from my machine using SQLyoga then importing it in using the phpmyadmin on the web host. Despite the different file formats I have exported in it has always brought up errors. I'm sure this has to be easy, that I am just missing something. I have searched the web and all kinds of forums and found nothing, although I;m probably just not typing in the right words. But all I want to do is transfer my home db to the web so i can get a little further on this website I'm trying to create.
Uploading My Database To Host Server
I have created a dump of my database using DB Tools. I then log into my server & from the cpanel I choose mysql admin tool. I then choose the SQL tab & choose the file & then get the above error!?!?! 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.
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 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.
|
TRACKER
