Accessing MySQL By A Client-side Application
I'm going to start an application that runs in a desktop computer but access data on a MySQL server in a remote computer (internet).
View Complete Forum Thread with Replies
Related Forum Messages:
Going From Client Side, To Server Side.
I was wondering: if i install MySQL, and the PhP egine on my computer, does this mean, i will have to connect my domain name, or URL, to my machine? I am having a hard time figuring out in my head the process by which i go from having something on the client side end of things, and the server/host side of things. I know that PHP is pretty much a language that you basically have as files, much like an actual HTML page. To this end then, i realise i will simply have to load my PHP scripts onto the server in which they are supposed to work. I am not however sure how i would do the same with MySQL. I do not know enough about the latter to know how its transferrable. So far, from what i read, i use a Console to test certain commands, like the creation of a Table, or the deletion of a Table. But how do i actually connect MySQL to a server that is not my own machine?
View Replies !
MySQL Client Side
Does mySQL have lite version? Similar to ms sql express, where it can be distributed without a full server version. I have program with many clients and i'm wanting to move away from access if i can.
View Replies !
VB + MySQL Client Server Application
I would like to know about what the most important things to be installed in every workstation if I will used VB and MySQL using the ODBC driver. Is there a need to install VB, MySQL, ODBC Driver in all computers? If possible can you give simple snippets in configuring MySQL and ODBC in VB code.
View Replies !
Client Side Report
i hav a few reports that generate at server side i would like to copy the tables needed for the report to client's temp file, and perform the calculation and filtering there. may i know is this way possible? for 1 table, there's .frm, .myd and .myi files, which files should i copy? and how should the connection string looks like when connecting to client's own temp file?
View Replies !
Requery Or Client-side Code
I have a query that outputs 3 columns: 'Name', 'Size' and 'Count'. The query can return a couple thousand records. My default query returns the result in order by name. If I want to have a sortable table on my website, does it make more sense to requery and let mySQL do the sorting, or do some sort of javascript/other thing? (As you can probably see , I'm more comfortable with the mySQL solution but I'm wondering which solution would scale better.
View Replies !
Client Side Connection Error
I'm getting this error message: "Cannot connect to database. Client does not support authentication protocol requested by server; consider upgrading MySQL client" When attempting to connect with: $mysql = mysql_connect( 'localhost', 'root', 'password' ); MySQL Version: 4.1.8-nt via TCP/IP Client: 5.0.11 OS: Windows XP I believe that I have the latest client. What should I do and how should I ensure that none of the visitors to my site has the same problem?
View Replies !
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error. Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?
View Replies !
MySQL A Server-Side Technology
I have a MySQL database and php scripts on a Linux server. When I do simple DB connects, queries and results in MSIE 6.0.SP2 everything runs perfectly. Yet when I access the same exact HTML Page in Firefox 1.0.1 I get absolutely no results. When I hit the same page in Netscape 7.2, sometimes I get the results to appear and sometimes I don't. Isn't MySQL a server tool that has nothing to do with the browser?
View Replies !
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
View Replies !
Using Mysql In An C++ Application
i am using mysql in my c++ application and when compileing i get the following linker errors (mysql.h, winsock2.h includen AND linked): mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegCloseKey@4 referenced in function _my_win_init mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegEnumValueA@32 referenced in function _my_win_init mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegOpenKeyExA@20 referenced in function _my_win_init mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptReleaseContext@8 referenced in function "public: __thiscall TaoCrypt::OS_Seed::~OS_Seed(void)" (??1OS_Seed@TaoCrypt@@QAE@XZ) mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptAcquireContextA@20 referenced in function "public: __thiscall TaoCrypt::OS_Seed::OS_Seed(void)" (??0OS_Seed@TaoCrypt@@QAE@XZ) mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptGenRandom@12 referenced in function "public: void __thiscall TaoCrypt::OS_Seed::GenerateSeed(unsigned char *,unsigned int)" (?GenerateSeed@OS_Seed@TaoCrypt@@QAEXPAEI@Z).
View Replies !
Side Menu Item Invisible Unless MySQL Contains Item
I have a menu attached to a MySQL DB that has various items stored and are called with PHP when a user clicks on the link. (I included the menu code below) I want to add a menu item that is only visible if there is something stored in the DB. I bolded the area below as to the part of the menu I want the field. Can someone please show me how to incorporate this in that general area with PHP? I have scoured the Web and Googled but could not find a way to do this. Code:
View Replies !
Distributing MySQL With An Application
we have developed many applications in Access where we end up writing a VB or VBA front end and distributing the Access data repository with the app, where the app is hard coded to talk to the repository. I was wondering if there is any way to distribute a MySQL database along with an application (.exe or whatever) so that the app could talk to it and/or "run" MySQL when it is started (without requiring the end user to really know or care about MySQL). What I don't want is for the end-user to have to: - Install MySQL separately from my app, or - Manually run and stop MySQL to use my app I'd be okay with my APP installing MySQL alongside, and starting and stopping it as needed?
View Replies !
MySQL With StandAlone Application
I was doing a search on databases, when I discovered this site. I am trying to creat a test application, where people are asked questions, the responses are saved in a database, along with thier profile. The end users will be dumb computer users, they just need to install the app and take the test. Is MySQL right for this job ?
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 !
Using MySQL As A Backend For A Commercial Application
I've read the MySQL licensing material and what I've found online, but I'm still unclear about when I have to pay MySQL for a license. Scenario: I've created an application that stores some data in MySQL 5.0 (InnoDB table types). It connects to MySQL 5.0 via MyODBC. 1.) If I include MySQL 5.0 and MyODBC in the installer, do I have to buy a separate MySQL license for every copy of the installer I sell? 2.) If I include MySQL 5.0 and MyODBC in the installer but allow the user to use their own licensed copy of MySQL 5.0, do I have to buy a license for the unused MySQL? 3.) If I include MySQL 5.0 and MyODBC in the installer but allow the user to use SQL Express (a non-MySQL product) instead, do I still have to buy a license for the unused MySQL? 4.) Does not including MySQL 5.0 and MyODBC in the installer change anything for any of these scenarios? I would like to support MySQL as the backend for my product, but not if I have to pay ~$600 for every copy just to allow a user to use MySQL (not require).
View Replies !
Converting MS Access Application To MySQL
I have several MS Access databases that I need to scale up (need to support more users, speed things up and make it more reliable that a JET database). I have experience of developing Access databases, MSSQL 2000 and MSQL 2005 databases and some experience of MySQL databases. I'd like to migrate to using MySQL for all our databases both for cost reasons and possibly being platform independent. Converting/migrating/re-designing the database structure in MySQL doesn't worry me but I'm unsure about which way to go in developing the front end application for the databases. I do like MS Access, even as a front end to MSSQL due to the speed with which I can develop and modify forms, reports etc. into a complete desktop application and know I could probably still use Access as a front end to MySQL but I just wondered if anyone has any advice on alternatives for the front end application - is the only other real option a browser based app using something like PHP for the logic?
View Replies !
MySQL Dump Is Not Allowing Application To Run
I am creating a backup once per day automatically. The current size of the file is around 4.1 Gig uncompressed. The command that I use is as follows: mysqldump --opt -q -R -u username-p'passwd' dbname | gzip > /filepath/$(date +%F).sql.gz This takes around 25 - 30 minutes to fully backup the database. The problem that I have seen is that while this backup is occurring I cannot access my JBoss application. Oddly enough, I tried to access the database directly and everything is working fine, but any other remote user cannot access the database. I want to know a couple of things: 1) Is my backup command optimized or is there something else I can add to make it faster. Now I do need to backup the data, table structure, stored procedures, etc. 2) How can I conduct a backup that is more efficient where it does not interfere with the remote users?
View Replies !
Delayed Response From MySQL To VB 6.0 Application
I have developed a system using Visual Basic 6.0 connecting to a MySQL database. The system inserts new records, updates existing records and views all records in the database. When I do an insert record and save the record to the database,I have a Flex Grid that I use to view all records from the table in the database,even the newely added record I just added. However, when i do add a new record, it takes at least half a minute to see the record in my Flex Grid. This confuses the user and he/she thinks that the record did not save, where in fact it did.I had already put an feature to update the Flex Grid and I don't think that Visual Basic is the problem. I think the problem may be the delay in response from the MySQL database to the VB application. This is the only problem I am having with MySQL, but it's a lot better to manage and easier to use than Microsoft SQL Server or Oracle.
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 !
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 !
Writing Multi-threaded Mysql Application
What I'm trying to do is to rewrite mysql client application (which calculates ISP dial-up customers' billing)into multi-threaded version. I'm looking for some resources on multi-threaded mysql application programming and it will be great if somebody knows some tutorials, samples and howto documentations on the web. I searched the web and didn't find anything related to mysql multi-threaded programming.
View Replies !
Mysql 4.0.13 Error Code 1064 In Another Application
I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as been okay until I tried creating moderators to my forum and then I got the following 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 '' at line 1 My intuition is that because I start mysql as a service in win2k and so each time I log onto my Win2k Server, mysql is running already. I however log into win2k with username Administrator, while mysql root user has been changed to my name ola, I believe that user Ola has all the rights with the following setup string: Code:
View Replies !
How To Get An Application To Register A User With The MySQL Server
I am making a mail user agent, with Java and MySQL server, that is supposed to work on a LAN. I am a little confused. If a user has to sign up, its the root account that will have to grant the user privileges, for which connecting to the server as root is required (?) So I initially thought of writing a class which connects to the server as root and then creates the user as per the request. Is it wise, or is there any ohter better method, through which the Java program can connect to the server. I mean to ask if its correct to write a program which has in it the main root password(a program that is a part of the Java application). There could be problems, such as, a change in the root password..
View Replies !
Rapid Web Application Development Framework For MySQL
I am searching for a rapid web application development framework for the MySQL database. In particular I am searching for an equivalent to the Application Express framework of Oracle (http://apex.oracle.com/i/index.html) for the MySQL database. I need to create an interface that allows users to simply create records in the database (e.g. through forms) and must be able to support more elaborate functionalities such as creating wizards or providing different and customized views to the database. Ideally all this works in a web browser.
View Replies !
Local Application Connection To Remote MySQL
I have managed to set it up on a remote server, I would like to know what' the best way to write an application, pref. in C++, that can connect to the remote DB over the internet. Basically, I hope to have a program running on a local computer collecting information and dumping it into an online MySQL database.
View Replies !
Server Side Question
i have created a php based website and have created a user/password form. I also have created the database to connect to this form. I upload all data and info to my webserver, but when i go to do the test it tells me it cannot connect to MySQL database. Do i need a server side version of mysql to make this work or is it something i could be coding wrong?
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 !
C# Console (exe) Application Crashes On Open Command (MySql)
I have problem opening an MySql connection from an win console application. I am using SharpDevelop as IDE. Previously I've been working with MySql through C# aspx and am new to writing exe programs in C#, so I assume that I might be missing something in the IDE / project configuration. I am successfully opening a connection and reading data from the table using adapter (window panel application binding to a grid), but when trying the code below in an console application the program crashes when calling the MyConn.Open(); function. The error message being: Exception MySql.Data.MySqlClient.MySqlException was thrown in debuggee: Unable to connect to any of the specified MySQL hosts. Open() If I break before the MyConn.Open(); function is called, the MyConn variable is filled with lot's of info looking ok to me, though I am not capable of knowing if any of it can tell me what leads to the crash in the next function call. Ive added the MySql.Data.dll to the project from the GAC list in the add reference panel. Further, in addition to the references, I only have an AssemblyInfo.cs file and the Main.cs file with the code below in the project I've reinstalled the MySql database trying different configurations etc, but whatever I have tried does not work. Has anybody else encountered this problem and or know the solution?
View Replies !
MySQL Open Source Application Components/plug-ins/add-ons
Perhaps someone might be able to tell me if there is a place to find MySQL opensource community application components/add-ons/plug-ins/contributions (whatever one might call them) which developers can reuse and modify to deliver MySQL applications faster? eg. something like a community download repository, or something to that effect. Would likely contain database definitions, queries, performance analysis tools, etc. Many open source products have this, I'm sure MySQL must, just feel silly that I can't find it.
View Replies !
SQL Way Of Avoiding Server-side Scripting?
I am running a query that produces a resultset with the following column structure: idrow, idcol and booked. This resultset represents seats and their booked status. For every row (referenced by idrow) there can be any number (variable) of columns (referenced by idcol) and these can be booked or not, as given by: Code:
View Replies !
|
TRACKER
