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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
Cannot Connect To MySQL DB Remotely
Through Java, I am attempting to connect to a MySQL 4.12 server on a remote computer. I can connect fine via php. I cann connect fine via Java, through a servlet, when the servlet is on the same machine (localhost) as the MySQL DB. However, when they are on different machines with different IPs, calling across the Internet (and there are no firewall issues -- I can connect fine to the remote MySQL DB via php from the same machine, not are there connection issues, it is the same db name, password and username, just a different IP) the MySQL driver is choking on me with the following stack trace: (btw max_connections in the MySQL DB is set to 100) java.sql.SQLException: Server connection failure during transaction. Attempted reconnect 3 times. Giving up. at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1704) at com.mysql.jdbc.Connection.(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:346) at java.sql.DriverManager.getConnection(DriverManager .java:525) at java.sql.DriverManager.getConnection(DriverManager .java:171) Does anyone have any idea why this would be happening? Ive been looking at this for days and cannot gain any insight into my problem here.
View Replies !
Connect To MySQL Remotely
I host files on two different servers for different people. Can a script on one server connect to a MySQL database on the other (they are different hosting companies). Is this possible, and is it dependant on MySQL configuration?
View Replies !
How To Access A MySQL DB Remotely
There are some interactions with a MySQL DB that is stored remotely on a web server. I know I have to change the connect function to reflect the fact that the DB is not local, thereby replacing "localhost" in the connect function with something else.. Question is, what is that something else? IP? IP+Port? How do I get this config info?
View Replies !
Clear MySQL History - Remotely
I was wondering if it's possible to Clear MySQL's History Remotely. Considering that you only have root access to the database but no access to the linux box. I found something in Goggle to do this, but you need to have access to the linux box: cat /dev/null ~/.mysql_history How can you do this remotely with only root access to the database and not to the linux box?
View Replies !
Unable To Connect To Mysql Remotely
I just setup my RedHat 9.0 server and have it preconfigured for MySQL, Apache and PHP. I am able to connect to mySQL using a GUI client from my my LAN (192.168.1.xx), but unable to connect from a remote site. I have my linksys router configured to forward any requests for port 3306 to my redhat linux IP. I thought it would be also important to mention that I am able to connect to my Apache webpage remotely. "Cant connect to MySQL server on 'starfire.homelinux.net'" Error 10060 when trying to test from my ODBC drivers. I have also tried granting a connection for a user@%, but I still am having the same problem.
View Replies !
Connect To MySQL Database Remotely
Im trying to connect to my MySQL database from a remote server. Im using the below asp srcipt but im having no luck. Im getting this error: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '83.146.35.143' (10060) Can anyone tell me what i need to download to get the connection working or what settings i need to change? Im happy to change the driver im using. Im using Unbunu Server with MySQL 4.1.1 . Code:
View Replies !
Can't Remotely Connect To MySQL Database
I am trying to connect to a MySQL database remotely. I have two ubuntu machines 192.168.0.3 (ubuntu 8.10) and 192.168.0.6 (ubuntu 8.04). I have edited each of their /etc/mysql/my.cnf and changed them to include bind-address = 192.168.0.3 and bind-address = 192.168.0.6 respectively. Neither has the line skip-networking. I have logged into mysql locally on each machine and entered the following command: grant all on mythconverg.* to 'mythtv'@'%' identified by 'mythtv'; When I run mysql -u mythtv -h 192.168.0.3 -p on the 192.168.0.6 machine I get the following error: glen@glen-desktop:~$ mysql -u mythtv -h 192.168.0.3 -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.3' (113) When I run mysql -u mythtv -h 192.168.0.6 -p on the 192.168.0.6 machine I get the following error: glen@glen-desktop:~$ mysql -u mythtv -h 192.168.0.6 -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.6' (111)
View Replies !
Backup MYSQL Database Remotely
I have a couple of MySQL Databases that store forum data on a number of servers.....and recently had an issue where the serve crashed and i lost a load of data...i want to prevent this from happening in the future and limit the amount of data lost....... is there a way to backup or mirror the data in my mysql dtabases to a copy which i plan to store locally on my PC, purely for backup purposes?
View Replies !
Cannot Connect Remotely To Mysql Server.
I am haing trouble connecting to my mysql server, from a computer on the same network. I successfully connected yesterday and it was all working fine, but this morning this is no longer the case and it just gives me Access Denied message, furthermore i cant even log in remotley as root, which i was able to the day before?? I have made no changes to the configuration of the mysql server, i have bascially came in today and it just doesnt allow me to connect remotley anymore? I have tried re-booting, granting global privileges, creating a user, specific to that computer, all to no avail, I would be extremly grateful if someone could just let me know what im doing wrong as the case may be. mysql server version : 5.0.13-rc-nt os : xp professional Have also got Mysql administartor 1.1.3 installed but sill tend to solely use the cmd line.
View Replies !
How To Connect Remotely To Linux/MySQL Using MySQL Query Browser
http://dev.mysql.com/doc/query-brows...onnection.html I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system. I type server host and port 3306 user name admin + password and default schema and I get access denied message. I use putty to connect to the server using IP and port 22 and it connects to the server. What settings do I need to use to connect to MySQL using query browser?
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 !
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 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 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 !
Error 1130 When Accessing MySQL From Another IP??
I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the following error: MySQL Error Number 1130 #HY000Host '192.168.0.5' is not allowed to this MySQL server Ping works fine. On searching the internet, I find reference to "allow list" hidden somewhere in the guts of MySQL. Can anyone provide me hints on how to add to this list?
View Replies !
Accessing Mysql After Fresh Installation
I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message " Access denied for user root@local host .......using password yes" i have tried all the options like #mysql -u root -h localhost #mysql -u root -h localhost -p #mysql -u root -h localhost -p mysql #mysql -u root -h localhost test -p #mysql -u root -h localhost test #mysql -u root #mysql -u root mysql but none of the option is working at all. Please any idea how i can change the root password or enter the mysql after fresh installation.
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 !
Accessing Mysql From Command Prompt
The path to my mysql installation is "C:Program Filesxamppmysqlin". I want to run myisamchk - to do this I think I have to access it via the command prompt. A stupid question - I kmow - but how do I get to the directory in a DOS window??
View Replies !
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
View Replies !
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 !
Accessing MySQL BLOB Columns Using Visual C#
I am trying to write an image file to a remote MySQL Database. The following code show the section I try to save the ImageArragy into the MySQL BLOB column. The error that I am getting is : Can someone tell me where I am going wrong and how I can fix this problem?
View Replies !
Accessing Data On An SQL-Server By Using MySQL-Select
is it possible to access data located in a SQL-Server-Database by using a MySQL SELECT-Statement? I know that on an I can use a qurey like the following SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:Financeaccount.xls";User ID=Admin;Password=;Extended properties=Excel 5.0') on an MS-SQL-Server and search for something similar in MySQL.
View Replies !
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 MySql Thru Coldfusion - Password Problem
I have downloaded MySql 5.0 for Windows (XP) and MySqlCC so I can interact with it. When I installed MySQl I created a username and password which I can see in "my ini" file. I don't remember creating any passwords through mysqlcc. I am building a database driven website using "macromedia studio MX" and am experiencing problems accessing my Mysql database through that software - I keep getting asked for a login ID and password, and for the life of me, have no idea what they are. 1. When I originally added my database as a 'data source' in Cold Fusion (MX 6.1 administrator) it would not let me create a password. I kept getting error messages like "The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'martin'@'localhost' (Using password: YES)" etc etc etc variations on that theme. (adding the database without a password wasn't a problem) 2. Now I am trying to create a dynamic page in Dreamweaver (using Coldfusion) to display my data – there is a 6 point process in the ‘server behaviors’ tab and I’m up to the last one “press the (+) plus button and choose ‘Recordset (Query). WHEN I SELECT MY DATABASE AS A DATA SOURCE IT ASKS ME FOR A "LOGIN ID" AND "PASSWORD." I've tried all the passwords I can think of that I used and nothing works, the error message I get is: "-1:Syntax error or access violation: 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 'wine like '%' at line 1. this is then followed by about 27 lines of commands like "at org.gjt.mm.mysql..".bladedblahdeblah " (I am creating a database of wine tasting notes)
View Replies !
Accessing Mysql On Win2003 Server From A Station
I have installed Mysql on a Win2003 server and it is running as a service. I created a database and it works ok on the server logged on as root. I then tried to access the database from a station on the network using PHP code and I get the error - Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in G:InetpubWWWrootIntranetookingacc.php on line 10. Do I need Mysql Client on the station or does it run on the Server by default?
View Replies !
Error Accessing MS Access Table Linked To MySQL
I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked. Code:
View Replies !
Connecting Remotely
I can connect from my local network using the computer name of the computer where the MySQL database is hosted in, but when I try connecting using my hostname (I created it with dyndns) I get error 2003.I'm pretty sure my router is forwarding port 3306 correctly because I configured it the same way as for port 80 for a webpage and that worked fine.
View Replies !
Can Only Connect Remotely, But Not Locally
The issue I'm having is that I can only connect to my database as the root user when I'm connecting remotely. In other words, only the user 'root'@'%' is able to connect. I believe this because I'm able to query databases using MySQL Query Browser (which would use the 'root'@'%' user to connect, as it's being run from a computer that is not the same computer that the database is running on). However, when I use any connection that connects as 'root'@'localhost' (for instance, a Python script run on the server), it gives me the following error: 2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" I was able to connect earlier. However, after losing ssh connection in the middle of having a script running on the server, I started having this issue. I've restarted the server twice now, with no results. Oddly enough, the script works if I connect as '(the server's name)' instead of 'localhost'. Additionally, I can't run /bin/mysql anymore either. I assume that it's trying to connect through 'root'@'localhost' as well, because I get the same error.
View Replies !
Remotely Connecting On Windows Server 2003
This is probably answered somewhere but I can't find it. I have MySql 5.0 installed on a Windows Server 2003 box and it's working fine. I can connect to it via MySqlAdministrator, MySqlFront and Helm Control Panel which are all installed on the same box. When I try to connect via a remote machine I get an access denied error. What can I do to connect remotely?
View Replies !
Accessing Data With In It
I have a problem selecting records with in any values. For example: SELECT * FROM ADDRESS WHERE STREET = "A" will give an error: If I replace with then it works. Eg. SELECT * FROM ADDRESS WHERE STREET = "A" Is there any setting in MySQL that can overcome this?
View Replies !
Accessing DBMS
Some of our customers have remote offices. I was wondering if it'd be safe to have a DBMS running at their central office, and have our client application running on hosts in the branches connect to it through a VPN via the Net? What happens if the connection goes south while a branch office was making changes? Does the DBMS just rollbacks changes automatically after a time-out? Should we set up some kind of replication instead? Also, are there compeling reasons to go for Firebird instead of MySQL? I don't know enough about the capabilities of each DBMS today to make an educated choice.
View Replies !
Accessing Phpmyadmin
ive been trying to figure this out for a while and heres my problem...I go to security and change my password, and then i go to config.inc.php file and change my controlluser and user to root well its like that already, but then i change my passwords to match... and it still wont let me in. please someone help. And am i suppose to change both controll user and controllpassword .and user and pasword?
View Replies !
Accessing Tables
I am writing a php ui for admin of Jabber2 user information. Looks like most user info is stored in a MySQL db. However the table names have some '-' in them. For example, I am trying to run the following command: desc roster-groups; and I get: ERROR 1064: 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 '-groups' at line 1
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 !
Accessing All Databases
I have a problem everybody who has a username and password can access to all databases even mysql database (the one which user details are in it) and able to delete or edit any data. I thought mysql is on skip grant tables mode but I did reload or flush-privileges nothing changes.I manualy go there any set all privileges to that user N but that user still able to access only mysql database and this is very dangerous because they can edit or delete any user. I tried to delete user and any user can delete any user yes. In that case I need your help what command I need to write to fix this problem.
View Replies !
Accessing MS-SQL Server
I need to integrate some data of a system that uses MySQL 5.0 with one system that uses MS-SQL Serve Express Edition. How can I do this? Is it possible call a SP in the SQL Server database from a SP/Trigger in the MySQL database?
View Replies !
|
TRACKER
