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 Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
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?
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?
Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0. I have my jsp files on the remote server. I have my local computer connected to this server. I have my MySQL database on my computer. I want to know how to connect the remote JSP files with the database? Where should be the ODBC-drivers?
How To Connect To An ODBC Source
I need help connecting mysql to an Oracle database. The Oracle database is set as an ODBC driver on my PC. I currently use MS access, connect via the ODBC connection and it runs great. I now want to connect to this ODBC connection using mysql, but I don't know how. Can anyone get me connected?
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 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?
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
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?
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 ?
Connect To Remote Server
I am very new at this. I installed MySQL and PHP on my Hard drive. I can connect to MySQL through localhost on my hard drive. We have a server at work at a remote location. He just installed MySQL and gave me a password on root. As far as I know there are no databases created. I need to connect to the remote server and create a new user and database. I've downloaded Secure CRT but don't understand how to use it. I entered my ip addresss in a new session and it seems to connect but then it says session fails. I put a test script up and just get an error message. Should this script at least not give me an error message. Should I contact the person in charge of the server? <? /** * Connect to the mysql database. */ $conn = mysql_connect("localhost", "root", "password") or die(mysql_error()); ?> Client does not support authentication protocol requested by server; consider upgrading MySQL client
Connect To Remote Server
I have created a database in a remote host using MySQL 5.0. I created tables using the control panel of the host. I accessed the tables several times using the same procedure. Recently, I downloaded MySQL Admin and tried to connect to the remote server. Nothing happens. It just froze there without any message or what. Is there a secret way of doing this? I can connect to a remote host in a local network but when it comes to using the internet via a router I always encounter this same kind of problem.
Connect To Remote Mysql
I had mysql working locally with no prob, I just got my hosting, login to cpanel, mysql add a db, add a user, try to connect to the db on my hosting server via my local mysql command line cd mysql cd bin mysql -h xxxxxx -u username I end up with username@something, access denied, I am behind firewall (these days, who doesn't). I think the username being appended with @something is the root cause of access denying, but I couldn't find a way to get around it
Connect To Remote Mysql Through Terminal...help
Is it possible to telnet or ssh to my paid webhost's mysql through the terminal on mac os x without installing mysql locally? (using the terminal to control mysql ). I really don't want to install it locally if I can avoid it as I wont be using my computer as a server. If so how?
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)
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:
Mysqld Restarting On Remote Connect
I'm on FreeBSD 5.4 with mysql-server-4.1.18_2. Whenever I connect to mysql from a remote client, I get: Mysql error number 2013 lost connection to mysql during query Also, the following is logged: 060506 09:47:25 mysqld restarted 060506 9:47:26 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060506 9:47:26 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 642388. InnoDB: Doing recovery: scanned up to log sequence number 0 642388 InnoDB: Last MySQL binlog file position 0 79, file name ./isd-bin.018710 060506 9:47:26 InnoDB: Flushing modified pages from the buffer pool... 060506 9:47:26 InnoDB: Started; log sequence number 0 642388 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.18-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.18_2 mysql works fine from localhost and I've granted permissions to connect from certain remote hosts. I just don't know why mysql restarts when a remote host tries to connect.
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.
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.
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?
Wrapping Database Source
Is there a wrap putility available for MySQL to wrap or obfuscate database source code? The reason for this being if I place a database off-site people who have access to the DB cannot steal your source.
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.
Comparison Of Open Source Database Servers
We need to compare the open souce Databases- MySQL and PostgerSQL based on features as well as on performance. If anyone has done such a comparison, please share your knowledge with us.
MySQL Database - Adding New Data Source 'Access Denied For User'
I am trying to install MySQL on my machine at the moment. I have downloaded the file mysql-essential-5.0.21-win32 from the MySQL website and installed it. I then downloaded MySQL Control Center, which came zipped in a folder called mysqlcc-0.9.2-win32. I have installed both applications and I have a MySQL database which I have acquired from elsewhere. I copy/pasted it into my C:Program FilesMySQLMySQL Server 5.0data directory, but when I try to add a new database in MySQL CC it doesnt allow me. I have also installed the ODBC for MySQL (called mysql-connector-odbc-3.51.12-win32). However, when I try to add a new data source in the Control Panel I get this error: [MySQL][ODBC 3.51 Driver]Access denied for user 'versiontwo'@'localhost' (using password: YES) versiontwo is the name of the database. the database has a password.
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/**************/"; ?>
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.
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.
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?
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.
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?
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.
Remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server from another windows box using ODBC?
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.
Database Synchronisation On Two Remote Sites
I am considering the possibility of trying to keep a user table synchronised on two different sites. This is not something i've done before so i'm looking for any tips that might help me on my way. Basically I was thinking of: - scheduling php script to connect to both databases via cron to update the table at regular intervals - generating an xml feed and doing the same thing Both methods would potentially involve storing a pointer to only read and write the new rows, although perhaps I could use DATETIME to also copy accounts that have been updated since last run. Probably biggest concern is: - security... operating in a way that the data is private. The most sensitive data is hashed passwords and postal addresses, I don't think it would be appropriate to not somehow protect this info during transfers. I'm not sure whether SSL is an option (should be) but possibly I was thinking of creating some kind of token system. - bandwidth. both sites should be fine resource wise but due to my lack of experience in these matters I don't really know what the performance hit will be, and I would like to run the script very often As far as I know alot of big sites (for example hotel booking engines) use xml in the background to share info but I really have no idea how it all works.
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?
Downloading A Database From Remote Server Using Ssh?
I need to copy a database from a remote server where I have ssh access to my local computer. Can anyone tell me how to do this? I was thinking something like this: - login to ssh $mysql_admin database_name | local_pc (very simplified)
Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new. i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?
VB6 Controls Not Populating From Remote MySQL Database
I have created a VB6 app that connects to a web hosted MySQL database. I have created the connection string in my app and used the Port number required by the Web Host. All my data comes back to my VB forms when I run my app from my Win XP development machine, but here is my problem... I have installed the app using InnoSetup wizard on a Win2K pc at SP4, and it connects successfully to the databases, but my textboxes, labels, comboboxes and datagrids show no data. For example, one of my forms has textboxes and a datagrid, and a statusbar. The textboxes and datagrid are bound to ADO controls which pass SQL statements to MySQL to create the recordset. The statusbar shows the RecordCount from the resulting recordset. The statusbar shows the correct recordset count, but the textboxes and datagrid are empty. This doesn't happen on my development machine. In my installer, I have installed all the VB Runtime files to the target machines WindowsSystem32 directory, and have installed the OCX files the app uses to the application's directory. I am at a complete loss to know why I can connect to the database, successfully open a recordset but not populate my forms' controls with the resulting data.
|
TRACKER
