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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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?
View Replies !
Accessing Remote Data Folder
I have MySql 4.0.17 server on my machine. My data folder is on a network drive. Recently I installed MySql 4.0.17 on a different machine, changed the my.ini file to point to the same remote data folder and restarted the MySql. I get the following error- "Could not start the MySql Server on local computer. Error 1067: The process terminated unexpectedly". So I copied the remote data folder onto my local machine and changed the my.ini accordingly, it is working perfectly fine. The storage engine is Innodb. Am I missing something here. I am pasting the contents of my my.ini file below. Code:
View Replies !
Accessing MySQL Database.
I have recently installed MySQL 5.0.27 / PHP 5.2.0 / Apache 2.2.3 on an XP os. I created an empty database via the MySQL command line which is visible when I type SHOW DATABASES at the mysql prompt. I have changed my root password which works OK. I set up the password to the empty db by: GRANT ALL ON database name.* TO username@localhost IDENTIFIED BY 'password' To access the db, when I type : mysql -D dbname -u username -p I do not get a prompt to enter the password.
View Replies !
Accessing Mysql Database From Php File
I can access mysql in dos with the command of c:mysqlinmysql -u root mysql but when i write the command of mysql_connect ("localhost", "username", "password") i don't know what my username or password is. I have installed Apache to run the mysql database and php on my computer although I don't know where to find out the username and password so if someone could help that would be great.
View Replies !
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 !
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 !
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 !
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 !
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 !
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 Replies !
Database Accessing
I am created a database in one pc and i copied the database to another pc.when i try to execute on any tables in that database i am getting a error that table doesn't exists.how to solve this problem?
View Replies !
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 !
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 !
Accessing Only Part Of A Database Value
I'm currently writing a form where a user will input the first three characters of a postcode. In my database I have registered users full postcodes, but when I run my query I only want to match the from the form to the first three letters of the database value.
View Replies !
Trouble With Accessing Database -- Too Many Rows?
The database is used for an online game. One of the tables keeps track of all the lands in the game. There are 7 continents, each with a different set number of regions (239 in total). Each region has 625 sectors, and each sector contains 25 lands. The total number of rows in the database is 3,734,375. I recently populated the table with the necessary rows. The table comes out to over 93MB. I've already modified the structure of the table to maximize the space usage. I had no problems accesses my database before populating the world. However, now that I have, I can't access the database as a whole. I can send queries to select certain tables (such as the user table), and even check out the individual table structures in phpMyAdmin. But it locks up every time I try to connect to the database directly (ie selecting the database using phpMyAdmin or connecting through the game). I suspect it's because of the huge amount of data in the database. I tried to send a query to delete all the records in the land table, but it doesn't go through and just locks up.
View Replies !
Accessing Remotely Hosted Database (ODBC)
I am developing an IVR application and will host it in-house. The application will need to access MySQL database which is hosted remotely in a web server. How could I access remote MySQL database using ODBC? Does the web server have to support SSH?
View Replies !
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 !
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 !
Auto Script Returns Error Accessing Database
I have a shopping cart with an automatic installation script. Add a new database without tables, configure the script with the table's user/password, and it's supposed to set up all the tables in the database. Yet each time I call the setup program, I get this error: DataBase Error, mySQL Error Reason : Access denied for user: 'username@domain.com' (Using password: YES) at /home/webadmin/[omitted]/cgi-bin/[omitted].pm line 109 The password appearing in the script is definitely not "YES" and I have checked to ensure that the script contains the correct user and password for the database.'
View Replies !
Capture IP Addr Of Network Users Accessing Database
I'm running MySql 5 and PHP 5, along with Apache2 on a winxp box. My database has info that needs to remain confidential, and as an extra security measure, I want to capture the dsn of the network users performing transactions. I have Apache configured to do this, but how do I get that data into my databse, so that I can match a transaction to a specific terminal at a specific time? I suspect somebody has already answered this, but I figure I haven't googled the right question. I am also capturing the user name and the time of each transaction, but that is pretty straightforward.
View Replies !
How Can I "see" A Table In A Database On A Remote MySQL Server After Creating It
I used the following SQL to create a new table in a database on a remote MySQL server by copying one already there. I know the table exists SOMEWHERE in cyberspace. I can read its data, write to it, delete from it. But I cannot see it. The only way I know it exists is by running this SQL from Access 97 pass through query: SELECT ALL new_tbl.name FROM new_tbl The database resides on a MySQL server that was created with a single table (named test) in it for testing purposes. I ran the following SQL to create another copy of the table in the same database named: new_tbl CREATE TABLE new_tbl SELECT * FROM test; I cannot see the new table in the Access 97 database window under the Tables Tab. Anybody know how to overcome this? Its a severe drawback to programming efforts not to KNOW what tables are in your database.
View Replies !
Remote Database
I have a data acquisition system written in VB6 that populates an Access database and does some processing of the data. I want to talk to this program from any browser via the internet. I only have a hosted (unix or asp) web service. Is there a simple scheme by which I can pass say a command code plus variables (eg. via a form) to this machine and display the result from this machine via say an xml document. I know I can use PcAnywhere to take over the machine but this is not quite an acceptable solution(!) Anybody has experience in this sort of remote control?
View Replies !
Accessing Dev.mysql.com
I'm trying to download MySQL4.1 from the MySQL site and when I try and go to the download section on the site it either fails or, if it loads, the "pick a mirror site" links always fail. By "fail" I mean that it doesn't manage to retrieve the requested page, either sticking on "waiting for dev.mysql.com" or "connecting to dev.mysql.com" in the status line of the browser, eventually giving up with an "operation timed out" error message. Is anyone else having this problem or is it just me? - this has been ongoing for the past couple of days now. Incidentally, I need a version of MySQL that can handle subqueries yet I'm still using glibc-2.2.5-40 and Redhat 7.3 (upgrading simply isn't an option right now) - can anyone suggest a stable sub-version of 4.1 that fits this criteria?
View Replies !
Remote Table In A Database
is it possible to create remote virtual tables in mysql? By that I mean if it is possible to define a table, which actually resides on a remote mysql server, but which can be accessed and addressed as if the table would be on the local database. My intention is to move one table to a remote host, but to be able to address the table as if it was still on the same machine. So for example: SELECT m.header, m.body, m.from, m.to FROM users u, messages m WHERE u.login=m.login; would still work, even though the table "users" resides in the database "moon" on a different host, than the table "message", which resides on the localhost in the database "alltables". The problem I'm trying to solve is: I have to webapplications, which both have a table, which stores login information. Those tables have to be combined into one and have to be put on one of the hosts only. One of the application will access the remote user table for logins. Since many of the SELECTS of this application contain joins like the example above I'm looking for a way in which I do not have to modify the selects but can move the login table to a different machine.
View Replies !
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.
View Replies !
Remote Database Updating
I am working on an internet enabled sensor device project. I have a small microcontroller device that is connected to a sensor device. I want this device to dial the ISP and post its readings each day. I would like to know if anyone might have any suggestions on how this could be done. Once the unit logs onto the server how might I code it to access the data area and post its reading. Also can this even be done. I mean does the microcontroller have to have a special database driver to access the remote database?
View Replies !
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.
View Replies !
Connect To Remote Database
I try to connect to mysql database on a server (let say ip is 192.168.0.1) I use MySQL ODBC 3.51 Driver to connect i try to check for the database, it only show database started with "test" in the folder name I can rename my folder to "testdb" or "test1" and it will appear normally on the connector however if I rename my folder to "db" or "1" it wont appear there if I connect to localhost (or leave "server" field empty) all databases name is showed there normally ("db" and "1" will appear) Is there any solution for this? i try to use grant query and stuff like that but doesn't seem to change anything I test using vista, xp and windows server 2003 test also done by typing own IP address to try to connect to local pc database (same problem occur)
View Replies !
Administrate A Remote Database
How is it possible to administrate a database placed on a remote server, without having access to it's desktop ?When i use the MySql adminstrator program it disables some of the setting, and says it has to bee a localhost connection.I would like to install the dataabase on a server, and afterward just use clients to administrate through.hope someone can explane the setup.
View Replies !
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 !
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 !
Accessing MySQL DB From Another Domain
what is the best way to access data in a MySQL database on one domain from a PHP script on another. We have a secure (SSL) server on one domain which will be used for secure credit card transactions. We would like to be able to extract insecure contact information from MySQL database on another domain in another hosting environment.
View Replies !
Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against MS SQL on a corporate network. I have a Yahoo web page, and I'm going to use their MySQL DB. I want to run queries, Inserts, Updates and Deletes. I have no idea how to connect to MySql on Yahoo from a client like C# or VFP.
View Replies !
Accessing Mysql From Another Host
New install of mysql on Solaris 10 x86. I cannot connect from any other host, lots of traffic on google with people with the same error. Talk of the grant command fixing this, but no details. So simple question. What "exactly" do I type to allow connections to port 3306 from another host to avoid messages such as ERROR 1130 (00000): Host 'am-ms-t.foo.baa' is not allowed to connect to this MySQL server
View Replies !
Accessing MySQL Data
This morning when I tried to access my MySQL installation through MySQL Query Browser, all schemas have a message stating "Fecthing Data..." when I expand the schema. If I access MySQL through the command line, I get the following message when I execute a "use" command: "Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A" If I execute mysql using "-A", then it appears I can access the data, but it's very slow. Has anyone experienced this and if so, do you know how to resolve it?
View Replies !
Accessing Mysql Server On LAN
I have a problem accessing mysql server on my LAN: i can access it locally but not from other machine. The error is: Lost connection to mysql server during query. I've disabled the firewall but it's still not working. What i don't know is if i set the users correctly...
View Replies !
Accessing A Mysql DB Remotely
I am building a kiosk which uses a lockdown browser. The browser uses a php page to access a MySQL DB on a web server. It will not allow me to connect to the DB because I am using the following connection string: mysql_connect("localhost","*****","*****"); mysql_select_db("******") or die ('I cannot connect to the database because: ' . mysql_error()); I know that the problem here is that I'm trying to connect to 'localhost' when the actual DB resides elsewhere. The question I'm asking is how to find out how to connect to my DB. Is it just mysql.mydomain.com instead of localhost or what?
View Replies !
Connect To A Database On Remote Server
By process of the fabulous PHP, I'm trying to connect to a database on a different server, Server A, from my one I want to manipulate the info on, Server B. I'm using a MySQL username, password and database from Server A just as if I'd be connecting to a database on Server B. Just changing 'localhost' to the IP of Server A isn't cutting it. How would be a clear-cut way to go about it? Would Server A need to give me more permission or something?
View Replies !
Connect To Database From A Remote Source
I own a website and plan on running multiple message boards on it...the problem is that I would like a database per board...however my host only gives 1 database....unless I want to pay an extaordinary amount of money for more. So I have used my PC as a webserver before without any problems and in fact ran a pretty big board off it with php, mysql, phpmyadmin installed. So my thought was to use a couple of databases off my PC to help run the new boards. I have created the database...but I'm having trouble with the board connecting. I'm sure that it's some kind of permission that needs to be inserted for the remote host to connect to my databases.
View Replies !
Query Database From Remote Location.
I have a database sitting on my db server, which is part of my office network (which has a domain controller). Access to the outside world is via a router, which is well locked down. Currently, remote users access the database front end via Terminal Services but this is only a method of accessing an application stored and running on the Database Server. What I want to do is allow access to the database from a server, which is located in another building (another part of the country). This is essentially an inter/intranet server. What is the best way for me to get this external server to be able to query my database server?
View Replies !
|
TRACKER
