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.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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 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.
Connecting To A Remote Server
not 100% sure which forum this should go in.. if it is in the wrong forum i am sorry. i have just got my ubuntu box working as a server at home with dynamic dns. i have still got my website on another server. i have taken all my DB;s across to my server and want the old server to update my new one so there is only one set of data to deal with. my issue is how do i do this? so i started with started with a simple file that connects to ponywars.com with user name and password. Then realized that i should add the user in with external hosts. i did this in phpmyadmin with user name, host being *.* and setting the password and giving it ALL access to make sure i not missed something. but when i ran this from the old server it just hang for ages then said: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/ghoxmfjz/public_html/test.php on line 7 cant conect to ponywars.com so i tried it the other way around to connect to happygolucky.me.uk and get the script to run. this worked fine. so i can only think its a number of things. i tested to see if my ubuntu box was listening on 3306 which it seemed to be. i think i have added the user in correctly but not 100% sure on that one, seemed to have. is the php page understanding how to connect to dynamic dns, cant see why not as the rest of the site works, ssh works, vpn works. as i understand it i have set up a dmz which forwards it everything to the server. sorry i have not given more examples etc not sure what people need to help, so any all helps suggestions, flames etc are all welcome.
Connecting To Remote MySQL Problem
I set up a linux server for Apache, PHP and MySQL last night. A problem remains. I can't connect to MYSQL with MySQL Administrator running on another machine. The error says I cannot connect 'hostnamt' of the machine I am on. I can connect via command line on the linux server, and I have added entries in the user table specifying host as '*' with the account I am trying to use. I flushed privileges and even rebooted the machine. Is there some global setting that I must change to allow remote connections?
Connecting To Remote Mysql Using Mysqladmin
I think Idid this before but cannot remember what i did. I want to use mysql admin to connect to remote mysql server as localhost so I can set server side features without having to be on the mysql server itself. I remember something in the way of "sip networking" option or something like this.
Connecting To Remote Database Via MySQL Administrator
I have used Sql Server and other databases extensively. I have the following questions. 1. I need to connect / manage a SQL database located on a remote web server runnin Linux. My workstation is running Windows XP. I understand that this is what MySQL Administrator is for. Is this correct? 2. Can I run both MySQL and SQL Server on my Windows XP machine? 3. What one book would be the most helpful to help me get a basic table setup?
Connecting To Mysql Using Phpmydmin From Remote Location
I just installed PHP 4.3.9, MySQL 4.0.2 and PHPMyAdmin 2.6.0-pl3 on our intranet server (Win2k3 running IIS). I also have a similar setup on my local machine (http://localhost/phpmyadmin). Everything seems normal when I work on the server machine (also known as web-nt with IP xxx.xxx.xx.xx), but when I try connecting to the MySQL database on the server from my local machine (http://web-nt/phpmyadmin), two things happen: 1. If I user 'localhost' in the phpmyadmin config file on the server, it opens up properly but obviously all the images are looking at http://localhost/phpmyadmin... etc, which is on my machine. 2. If I use the IP address on the config file, which seems to be the better method, I get the following error: #1045 - Access denied for user: 'root@web-nt.acorn.com' (Using password: YES)
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?
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.
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"?
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/**************/"; ?>
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?
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.
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.
Connecting To MySQL From Another Server
I have two sites. They are on two separate servers that I both control. However, when I try and connect to mysql from another site, it does 'Host so.and.so.com is not allowed to connect to this MySQL Server.' How can I make it so so.and.so.com is allowed to connect? Is there a command through shell that I can run to allow host so.and.so.com to connect?
Connecting To MySQL Web Server
I have an Access database created for a non-profit. They would like to have this database be shared among all of their chapters, and the web hosting site seems to be the best option. My options seem to be either develop pages in PHP and upload, or use Access to connect to the MySQL database hosted on the web server. Can an Access database be connected to an MySQL database online? I imagine it can, and it shouldn't really be much different than connecting via an intranet right?
Connecting To Mysql Server
I am trying to use mysql on win98 I downloaded mysql control center. I fill out the info it asks for and it shows it registers the the server but then I cannot connect to setup my db. heres the info I put in. name:upload host:localhost username:root password:****** Ihave tried stopping and restarting everything. I used the default install settings for mysql.
Connecting To Mysql Server
Whenever i try to connect to mysql server, i get this: Fatal error: Call to undefined function mysql_connect() in ........ on Line .... What's wrong? i've mysql and apache installed on an external drive and both of them are working individually. Their host is localhost and the port for apache is 81 and for mysql is 3306.
Problem Connecting To MySQL Server!
I have a problem connecting to MySQL server! The server is working on the other computer than my scrpit(my web page). The IP of MYSQL computer is 10.0.0.2. and port 3306! When i try to connect like this : $link=mysql_connect("10.0.0.2.", "user", "password"); $db ="database_name"; ... I get the folowing massage: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.0.0.2' (10061) in D:InetpubwwwROOT....... The ip, username, password and database name are all correct! It is said, that it's possible, that the MySQL is set to work on localhost! If this is the problem, where to configure mySQL, to be able to connect from other computer?
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?
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.
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?
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.
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.
Trouble Connecting To MySQL On Windows Server 2003
Fatal error: Call to undefined function mysql_pconnect() <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connMySQL = "localhost"; $database_connMySQL = "database"; $username_connMySQL = "root"; $password_connMySQL = "mypassword"; $connMySQL = mysql_pconnect($hostname_connMySQL, $username_connMySQL, $password_connMySQL) or trigger_error(mysql_error(),E_USER_ERROR); ?> I installed the ODBC drivers as an optional solution, and that appears to be working when I test it within the program, but I don't know how to get my .php website to connect to it. .php files are working correctly on the server, but it's just not connecting to the database.
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?
Connecting From Another Server Possible?
Is it possible to connect to a database from another server? I'm using these lines: mysql_connect ("localhost", "my_user", "my_pass") or die (); mysql_select_db ("my_db"); All I have to do is change "localhost" right? to...?
Connecting To The Server
how can you connect to the server (I am on win 2K pro) ? I create a new connection with MySQL Administrator Connection = myTest Username = papillon Password = fraise HostName = localhost Port = 3306 Type = MySQL I get the message Could not connect to the specified host MySQL Error nr 2003 i try a ping pong >>> Ping = Reply form 127.0.0.1 Time-0ms TTL = 128
Connecting To Server
I am having trouble on getting my sql to work. I am using windows XP and I keep getting this error about using password YES. This is a copy of my dos window so you can see what the error is. ***************************************** C:mysqlin>mysqld C:>cd mysql C:mysql>cd bin C:mysqlin>mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 3 to server version: 4.0.20a-nt Type 'help;' or 'h' for help. Type 'c' to clear the buffer. C:mysqlin>mysqladmin -u root -p shutdown Enter password: ******* mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Connecting Server
ive got 2 linux servers, each runs mysql on tcp 3306 and an httpd on tcp 80. I can telnet to port 80 from server 1 to server 2 and visa versa, but can't telnet to port 3306 from server 1 to server 2 and visa versa. I can telnet to both 80 and 3306 on both servers from a 3rd server ive got, I can also telnet to 3306 on someone elses server from both of them. Any ideas why I cant connect properly?
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 Server
How I can connect my aplication in delphi with database mysql in remote server?
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
Connecting To Remonte Server With ADO.NET
I have rented space on a server and I am trying to connect to their mySQL server with ADO.NET . The hosting company arn't being very cooperative and havn't given me enough information to create this connection. I don't even know if their mySQL server is setup to talk to .NET What i'm wondering is, is there a way to find out the info i need to connect without being at the server? For example I need to know if the mySQL connector is installed so i can use the mysql.data class to connect.
Connecting To A Server From Windows XP
I have installed MySql 4.1 on my windows XP home computer. I would like to connect to my university's server, but when I start the program, it automatically asks me the password, then connects me to my own home server. How can I connect to the other server?
Error Connecting To Server
Warning: mysql_connect() [function.mysql-connect]: Host 'AAI-AGS-139DW.AAIGLOBAL.local' is not allowed to connect to this MySQL server in C:wampwwwfirst projectconnect_mysql.php on line 10 could not connect: Host 'AAI-AGS-139DW.AAIGLOBAL.local' is not allowed to connect to this MySQL server. what seems to be the problem here? is it my script or my server?
|
TRACKER
