Connecting To Remote MySQL Database With CPanel
Is it possible for a remote server or even another account on the same server to access the MySQL Database of an account?
The reason I ask this is a I have a client who wants to set-up a second website but wants to pull a lot of the data from his existing website which is in a MySQL Database.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
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?
View Replies !
View Related
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"?
View Replies !
View Related
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/**************/"; ?>
View Replies !
View Related
Problem Selecting DB On Remote Server (I Use Cpanel)
I'm having problems connecting to my a mysql db on a remote server. Essentially, when I try to select the db.. mysql_select_db ("db_music") or die(mysql_error()); .. I get the "Access denied for user.." line. However, I am sure all my info is correct. I've also added my ISP into the list of allowed mysql hosts. Could this be a problem w/ my ISP or a local firewall?
View Replies !
View Related
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?
View Replies !
View Related
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?
View Replies !
View Related
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.
View Replies !
View Related
Connect To Cpanel Database With MySQL Administrator
I just want to see how mysql administrator works and can't even get the software to properly connect to my database in my cpanel account. I gave the program my site's dedicated IP address for the server host. The username/pw I supplied are those for the user who has access to the database. I have put my ip on the list of allowed hosts in cpanel. Everything should be good, right? I click OK in the program and I get: can't connect to mysql server on 'xx.xxx.xx.xxx' The x's are actual numbers, of course. What gives?
View Replies !
View Related
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)
View Replies !
View Related
Connecting To Remote Mysql With Command Line
my client got a dedicated box at rackspace but now that its time to move the db from my localhost to the remote server i find out there is no phpmyadmin installation. im also unsuccessful in connecting with Navicat (somehow that NEVER works ...). can anyone offer any advise on how to connect either with my GUI or with an SSH client. or SSL? having always relied on a GUI to work with db's im totally lost!
View Replies !
View Related
Connecting To A Remote Mysql Server From A Java Application On Another Machine
i've a java application on a (remote/network) machine and mysql running on my local pc.other users who have access to that remote machine must be able to run that java application which will have to get data/send data to the server(/DB) on my local PC. i was able to run the application when its on my local pC using localhost in the connection string. But, now how do i set the connection string so that the java application accesses the DB (/server) from my local PC?
View Replies !
View Related
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?
View Replies !
View Related
Connecting To A Remote Server
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.
View Replies !
View Related
Connecting On Remote Servers
I have 2 web servers running. One has MySQL installed and all my pages on that server connect to it fine (using localhost in the connection string). But I cannot connect from my other server, I get the error - Warning: mysql_connect(): Can't connect to MySQL server on '**the server with MySQL**' I've scoured Google all day and can't figure it out. The bind-address line in my.ini is commented out, skip-networking has been turned off, and the all the users in MySQL are host-independent (they all have the @ sign), so it's not a permissions thing. Other than these issues, what else could be causing a remote connection error?
View Replies !
View Related
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.
View Replies !
View Related
Connecting To Remote Host Db
I have two websites. 1. abc.com 2. xyz.com i am connecting from abc.com to xyz.com mysql server using the follwing code. PHP Code: $link=mysql_connect('http://xyz.com', 'user_sql', '123456'); but does not work, error : Can't connect to MySQL server on 'xyz.com' (4) i hav done only one setup in xyz.com. that is in xyz cpanel under "Remote MySQL" i have just allowed abc.com in the remote host list. What could be the problem. any other setting srequir?
View Replies !
View Related
Connecting To MySQL Database
I have a windows program that retrieves and stores information into a mysql database. I ran this program a couple of months ago without a problem but now when I try to run it I cannot connect to my database. What all do I need to make a windows program connect to a mysql database? So far I have downloaded the MyODBC driver. Also I am able to connect to the database via webpages. Is there anything else that I would need besides that MyODBC driver? I do have the right port(s) open also...
View Replies !
View Related
How To Setup A Remote Mysql Database
i have a vb front end application and im using mysql as my database. i would like my vb application to connect in database through internet. so i setup my other computer ( windows 2000 ) as a server, i installed a webserver, enabled http, but when i try connect my application an error occured. which maybe mysql has not been setup correctly. i would just ask if anybody here knows how to setup a remote mysql database so my vb can connect to it.
View Replies !
View Related
Accessing Remote MySQL Database
Is it possible to access remote MySQL databases? I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.
View Replies !
View Related
Connect To Remote Database(MySQL)
Is there some sort of setting I need to turn on where I can access the database from another server. So instead of using "localhost" I can use the actual server IP address. And just for future reference, is this how you set up a application server connecting to a database server.
View Replies !
View Related
MySQL Slow To Connect To Remote Database
I was running a PHP/MySQL web site with the database on the local web server. I needed to move the database off the webserver (located in the firewall DMZ) and onto its own machine (behind the firewall on our private network) Now when I run my web site it goes really slow. I ran mysql from the command line on the web server and connected through to the database machine behind the firewall using webserver:/# mysql -h 192.168.1.7 -u www-data -p After I enter the password, it takes around 5-7s before I see the mysql> prompt. Is mysql trying to do reverse dns on the IP address and timing out? I added the machine details to /etc/hosts so it would be recognized but no improvement. Or do I have something wrong with my mysql configuration?
View Replies !
View Related
Accessing A Mysql Database On A Remote Server
i would like to know how to connect to a remote mysql server which is on linux from a windows system. I gave the command: mysql -u root -p redhat -h 192.168.1.132, where the ip is the ip of the linux server. But i got the error message stating that :- Host 192.168.1.114(which is my system ip) is not allowed to connect to this MySQL server.Sreejith
View Replies !
View Related
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.
View Replies !
View Related
Msaccess->mysql Cpanel Migration
I developed a site in php/msaccess and am currently hosting it at home. i have recently purchased web hosting services w/ mysql/cpanel and would like to migrate the site form home to my knew host. my first question, is how do i move the data from an msaccess db to the cpanel mysql db?
View Replies !
View Related
Control Center :: GUI To Connect To A Remote Mysql Database
I'm trying to get the GUI to connect to a remote mysql database from my client machine. What is the proper syntax for this in the GUI? I have tried everything with no luck: using the ip of the host, using the complete dns hostname of the host, using root as the user, using root@hostname as the user. I keep getting access denied for every attempt. I'm sure I am using the correct password.
View Replies !
View Related
Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0. I have my jsp files on the remote server Z:. I have my local computer 'A' connected to this server. I have my MySQL database on my 'A' computer. I want to know how to connect the remote JSP files with the database? Currently I am using jdbc.odbc drivers on 'A' computer. But my server computer has Linux and uses org.gjt.mm.mysql drivers. Which drivers and Where should be the drivers?
View Replies !
View Related
Trying To Revoke User Privs Cpanel Phpmyadmin Mysql 4.1.21-standard
I have created a user (someone). Logged into cpanel as the main account if I try .... REVOKE ALL PRIVILEGES , GRANT OPTION from someone@localhost; I get"#1044 - Access denied for user 'myaccount'@'localhost' to database 'mysql'" Can anybody tell me if there is anything I can do / another way to accompish the creation of a new user but only allow them access to certain priviliges? e.g. I don't want them to be able to drop tables. If I do this - there is also an error...... GRANT DELETE , INSERT , SELECT, UPDATE ON myaccount_thedb.table_1 TO someone@localhost; ""SELECT,INSERT,UP command denied to user 'myaccount'@'localhost' for table 'table_1'"" Also updateing the user privs in cpanel gives no errors but does not work.
View Replies !
View Related
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
View Related
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?
View Replies !
View Related
Connecting To My Database
I have set up a Database, and i'm trying to install "Vwar" on my website, it asks for my "Database Server" and username and password, my problem is, i don't know what my Database Server would be, i have pictures of what the sites look like here http://img.photobucket.com/albums/v457/Epicsoldier/Database.jpg http://img.photobucket.com/albums/v457/Epicsoldier/VwarProb.jpg
View Replies !
View Related
|
TRACKER
