Remote ODBC Connections To MYSQL
I have a requirement to do some standard table work with existing online survey software (PHP based- using MYSQL). I would like to test the ability to do this work from desktop clients such as access or open office.
I have set up an ODBC connection on my machine with appropriate passwords etc. When I run the test in the WinXP ODBC diaglog, it is says that connection is succesfull.
However, when I try to use the same DSN in ACCESS or the database component of Open Office, it is that it is unable to make the connection. For example in ACCESS, trying to link tables, the message comes that the ODBC call fails.]
In OPEN OFFICE when I do the test connection, I get "ACCESS DENIED" for user... which is the user account and password that I use in the web based projects.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL Max Connections Remote And Local
My website runs on two servers. One is mean't for PHP and the other is the database MySQL. Whenever a request is made, the PHP attempts to connect to the MySQL via a remove host variable in the mysql_pconnect() function. This works fine, however when it comes down to having lots of connections in the my.cnf file, which one do I edit? max_connections = 1000 Now do I set this in the MySQL only, or do I set it in the PHP server as well?
Remote MySQL Connections, Still Not Working
I've read, and done all the tutorials, forum posts, and comments I could find regarding setting up a mysql server access for remote connections, but I still seem to have problems. I have a LAMP server running behind a closed router connection. A dynamic DNS is masking the connection, and I have the appropriate ports open for HTTP, SSH, VNC, FTP, and I thought MySQL (3306). But for some reason I still cannot get MySQL to connect from a foreign host. The I have port forwarding (3306) to the correct system behind the router, and I can access the server just fine via http/ftp. The MySQL server is happily running PHP MyAdmin with the localhost connection too. I've set a (actually a couple now) user to have the ip access of "%", and granted all permissions to that user, flushed the permissions, even restarted the server. I still can't get the remote connection to work.
Remote ODBC Tables Via MySQL
I've been using MySQL as a db engine behind a PHP application, and it has worked very well so far. Now I need to access some data held in a remote Oracle database and the only access I'm likely to get is via ODBC. I know the federated engine only works with MySQL, but is there a way of viewing these tables through MySQL? It would be much simpler (and more portable in the long run) to maintain an illusion for the app that it is looking at only one database. If there's no way to do this, will I need to set up a script that dumps data into the local database?
Detecting ODBC Connections
This probably isnt meant to go in this section but i didnt know where else to put it I have a MYSQL database sat on my Host's Web servers. Now i beleive i have around 5 Accessible ODBC connections to this database that i have been provided with. I was wondering if anyone knew of a way i could find out dynamically. e.g. using code! to find out how many are currently active The host has currently got MYSQL installed with the web based PHPAdmin frontend and CPANEL
Enabling Remote Connections
Can someone tell me how to set up the mysql server to accept remote connections? Im using mysql 4.1 on Linux Ubuntu 5.10 I have tried editing my.cnf and changing the bind-address from 127.0.0.1 to the server's IP address, but this just results in the server failing to restart with the following error: Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! What do I have to do to get it to accept local and remote connections? Code:
Enable Remote Connections
When we connect to the database server on the same PC, we give the server as "localhost" When I tried to connect to the database on another PC by giving the hostname as server it gives the error as Access denied for user 'root'@'hostnmae' Can someone tell me how do I make sure remote connections are open for this mysql database and how can I identify it from another PC?
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?
Odbc 3.51, Visual Studio 2003, Odbc DataAdapter
one Question. Is here anybody who had success in accessing a mySQL database via the ODBCDataAdapter in the Visual Studio design view? I get always Errors after creating the select Statement in the ODBCDataAdapter Configurartion wizard. The error-Message tells me, that the user has no permissons. If I do the access in Code, it works. But I want to Create a Dataset in the Desing View. ---- in German: mal ne Frage. Hat es hier schon mal jemand geschafft mit dem odbc Dataadapter auf eine MySQL Datenbank zuzugreifen und zwar in der Design-View vom VS? Bei mir klappt das nur im VS 2003, und dann habe ich aber nachdem ich den Select-Querie zusammengestellt habe Probleme mit dem Zugriff. Wenn ich das ganze über Code probiere, klappt der Zugriff wunderbar. Aber nicht über den Wizard. Im alten VS geht das sowieso nicht. da kann man den ODBC DataAdapter nicht konfigurieren.
# Of Mysql Connections
I was wondering what you guys thought about this. How many mysql connections do you think is to many on a php page?
Mysql Connections
I am currently running MySQL 5.0 on RHE3. I would like to know if someone can tell me how can I get the total number of connections/session to the mysql server via the console or command line?
MySQL Connections
A shared hosting provider allows to setup 10 MySQL databases. The only thing is that each database is forced into having its own username and password, which means a separate connection has got to be made to each database. Is there a way to join tables over the two connections
How Do You Open Mysql To Outside Connections?
I have a DB server and an APP server. I am trying to open MySQL on the DB server so the APP server can connect to it. I did the command: GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PW' WITH GRANT OPTION; However, it still won't connect.
Closing MySQL Connections
Here's a question for you, my hosts have told me that that one my pages, php, was causing their server to reboot because there were too many open connections and that they should be closed. Now, correct me if I am wrong but I thought that the connections were closed after a minute of inactivity. Does this sound right? Could open connections cause their server to reboot a lot, say 3 times in 15 minutes? If so, what can I do about it?
How Do You Stop All The Connections To MySQL?
I don't want any application accessing my databases while performing the recovery operations. In Oracle, you can stop the TNS listener on the server side. What is the equivalent of this in MySQL?
Managing MySQL Connections...
MySQL is currently reaching its limit of connections, and is not responding to new ones. What would prevent against this? Would closing the connection through PHP at the end of every page help with mysqli_close(); Or should I set my max_connections in the my.ini configuration file to a higher number? What other ways can lower the amount of connections?
Best Practices For Php/mysql Connections
I'm working on a data intensive project right now and though I'm able to write code I'm by no means a php or mysql guru, to say I know 'just enough' would be a good statement. So I'd like to ask those who know better... Without going into specifics; users will be searching the database, and/or adding data to the database. I would estimate that there will be far more searches than additions/edits. One of my main concerns is managing the connection to the database for each user. What would the most efficient method be, generally speaking? I would think that I do not want them to establish a connection for each request.
Getting Mysql Error Too Many Connections
I have limited controll of the server settings for MySQL all I can do is create a database, a database user and delete database. I can also use myPhP admin to manage the tables and stuff but as far as controlling the sql server thats all on the hosting company. I recently set up a forum boards (SMF forums its great) all of a sudden one day I went to optimize the tables and whammo the whole board stopped working. When I went to log into plesk and go into My Php admin it keeps giving me this error "Welcome to phpMyAdmin 2.6.0-pl3 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. MySQL said: #1040 - Too many connections What exactly is this error and how do I fix it. I am a noobie with My Sql is this a problem with my hosting companys server or is this an issue I can fix? My hosting support said my database is corrupt (figured that much) but I can't restore untill I can overcome this error..
Several /tmp/mysql.sock Connections
I did a netstat -an and I saw around 80 lines like this: c41cd9d8 stream 0 0 0 c41cd230 0 0 /tmp/mysql.sock Is the server holding too many connections and then cant handle anymore? What can I do to fix this? I am running Mysql 3.23.49 with persistant connections off.
Netstat And 500 MySQL Connections
I was performing some benchmarking on my app and discovered that it opens 400-500 MySQL connections show by the netstat command: tcp 0 0 enssbos:36185 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36184 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36191 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36190 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36189 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36188 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36179 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36177 enssbos:mysql TIME_WAIT tcp 0 0 enssbos:36176 enssbos:mysql TIME_WAIT . Does this look right? Why are there so many tcp network connections for one script? I do use ajax with multiple updates, but I feel as if I am going to run into problems here.
Closing Persistent Connections In Mysql
it might be a stupid question,but I just want to know how can we close persistent connection in mysql (using php). what are the advantages and disadvantages for using persistent connection?
Tracking MySQL Outgoing Connections
I currently have this serious issue where a bunch of mysql connections are being sent from one of my servers to another. I think its a virus or some sort of hole in my scripting but my main server keeps on sending fake logins to my database server. I do not know how this is happening, but IS THERE A WAY for the mysql client (not the database server) to track all of the outgoing connections that are being made?
Mysql Too Many Connections Performance Issues
I have a website running on a linux/apache/mysql/php server. I receive about 8,000-10,000 visitors a day with about 200,000 to 300,000 page views. The server is a RedHat Linux server running PHP 5.x, MySQL 5.x, Apache 2.x We have been suffering from a number of performance issues. Our hosting company has set our max connections to 100, and we are using persistent connections in PHP. At times the mysqld process takes 100% of the CPU. We have also been suffering from mysql_pconnect(): Too many connections errors. What can I do to fix these issues? When I run a top on the server I see this ... PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 5567 mysql 16 0 169m 42m 4236 S 81.2 4.2 3078:09 mysqld 32539 apache 15 0 42676 25m 7708 S 1.0 2.5 0:03.40 httpd 32572 apache 15 0 42680 25m 7708 S 1.0 2.5 0:02.98 httpd 32608 apache 15 0 42680 25m 7704 S 1.0 2.5 0:00.72 httpd 32542 apache 15 0 42704 25m 7712 S 0.7 2.5 0:03.38 httpd 32561 apache 15 0 42732 25m 7712 S 0.7 2.5 0:02.61 httpd 32567 apache 15 0 42680 25m 7708 S 0.7 2.5 0:02.60 httpd 32591 apache ...................................................
External MySQL Connections Error
I'm trying to connect from my computer to my server. I add my computer to the allowed access hosts. And I'm able to logon correctly. But when I try to select the database I get this error: Access denied for user 'USER'@'%' to database 'DATABASE' Any ideas?
MySQL 4.0 Refusing Local Connections
I am hardly an expert on MySQL. I have limited knowlege on how MySQL 4.0 works. I have used MySQL 4.0 nearly half a dozen times, using these steps, and everything working flawlessly. Download MySQL 4.0 without installer, Extract it to c:mysql. go to c:mysqlin, run winmysqladmin.exe, it will prompt for a username and pass. I type in a fresh combonation. It will start up. I will install the service, and then add the service using the systray icon that appears from winmysqladmin.exe. Now i am capable of logging in with root, set permissions, build databases, etc... etc... For some reason, I cannot figure out why. It is now refusing all local connections. The server is running windows 2000 advanced server. When i install it i do it with the remote desktop connection. simply because the server itself is 1300 miles away.
Webserver Leaving Many Unauthened Connections On Mysql
MySQL 4.0.24_Debian-10sarge2-log I have a seperate mysql server and several webservers. One of them recently had an upgrade from debian 3.2 to 4 . Also many things like apache and php got upgraded. This webserver works, but its going slow sometimes. When I check mtop on the mysql server, I mostly see something like this : ID User Host Command State 8606722 unauthen ip:422 Connect login 8606729 unauthen ip:422 Connect login 8606733 unauthen ip:422 Connect login 8606734 unauthen ip:422 Connect login there are usually about 20-40 of those lines, with ip being that of the updated webserver. The only other lines are about 20 waiting 'Delayed, waiting for' lines for delayed inserts (wich is normal), and now and then a real mysql query. All the other webservers do not seem te behave like this, so I'm not sure if this really is a mysql problem. But what I want to know is : what can I do to avoid those hanging connections ? Sometimes there are so many of them, that mysql is running out of connections and is blocking access from other webservers. I can raise this value ofcourse, but that is not a real solution of the core problem.
Mysql Heavy Load On Databases And Connections?
I'm preparing for a lot of potential traffic to a web app. My question is. Is there any restriction on the amount of databases you have on a single mysql installation on a linux server. Could there be any performance issue if for example I had 100,000 databases all being connected to at different times? What is the upper limits of a standard LAMP dedicated server? What i mean is how many simultaneous connection can it handle before it starts to slow down for the users?
Cleaning Up MySQL Connections To Avoid 1040
Well, I'm trying to run PHP $result = mysql_query("SHOW FULL PROCESSLIST"); while ($row=mysql_fetch_array($result)) { $process_id=$row["Id"]; if ($row["Time"] > 200 ) { $sql="KILL $process_id"; mysql_query($sql); } } To clean up my connections, as I'm getting a 1040 error "too many connections". Of course, I can't run this until I can actually connect, unless there is a way around somehow. I don't have any admin rights, I just have a web-based "php my-admin" module to run the db. Every page people access opens a mysql connection, and then it is closed with PHP mysql_close($connection); . Would putting in PHP <?php mysql_close($connection); $NASI_connection = null;?>
MySQL Persistent Connections, Stored Procedures
We have a PHP/MySQL based website. It's our first project where the DB work is being handled my someone else the client hired. They are having us use a lot of stored procedures they created. We've found that in order to run the procedures we have to use a persistent (mysql_pconnect) connection in our PHP scripts. Otherwise, using mysql_connect, ALL the stored procedures generate a mysql error. If we use pconnect they don't. Is this normal to have to use pconnect with stored procedures and if not, what could be the cause? The second problem we are now running into is we are unable to connect to the database because we are exceeding the max connections. Even on our development server which uses a separate database on a separate server with maybe only has 5 or 6 different people that know about the website and use it. The production site is maxed out, getting a too many connections error message. We are still invetigating but I believe they said there were 40 connections to the database. The website is inaccessible because it can't connect. I guess another thing I'm curious about is on a website that is very DB intensive and has maybe a max of 50 simultaneous users at a time, what would a reasonable setting be for max connections on MySQL considering we have to use persistent connections?
MySQL Redhat Slow Responding To Connections
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box connects almost immediately. The fast box has standard install of 7.3 with tomcat added. The 9.0 box is straight RH9.0 standard install. I can't find anything in common between the slow boxes, but not on the fast one.
Shouldn't Mysql_pconnect Force Reuse Of Mysql Connections?
I have this function I call everytime I need to make a query from within my php-scripts: function db_connect ($user, $pwd, $db, $debug = 0) { $link = @mysql_pconnect("localhost", "$user", "$pwd"); if($link && mysql_select_db("$db")) if($debug == 1) { printf("Connection OK!"); } Return ($link); if($debug == 1) { printf("Connection not ok!"); } Return (FALSE); } I thought that making another or a third call to db_connect would reuse the same connection to the database, since I use mysql_pconnect() to connect. But listing the active processes indicates something else: Code:
MySQL Server Initialize Broken Connections
I'm working on program that acts as MySQL client. After successful connection program send queries for a long time. When I stop server mysql_query return error (no surprise). But when I start server my program recieve information again without connection reinitialization. I suppose MySQL server track connections somehow but I didn't find any info about it in documentation. Can somebody point me to docs or explain this behaviour?
Using MySQL From ADO.NET And ASP.NET Via ODBC
I have the following problem when I try and connect to MySQL - REGDB_E_CLASSNOTREG(0x80040154) - (MySQL ODBC 3.51 Driver). I have used this driver via VB6 using ADO and ODBC without a problem. The connection string I'm using in ASP.NET and using .NET Framework 1.1 and MDAC 2.8 RTM is: MyConnectionString = "Provider=(MySQL ODBC 3.51 Driver);Data Source=localhost;uid=;initial catalog=property;password="
Mysql + Odbc
What are the advantages / disadvantages of using odbc to connecting to a (mysql) database???
MySQL ODBC
I downloaded the MySQL 3.51 ODBC driver and it is hanging on connection for some reason. Is there a fix? I just want to get data from my web tables via VBA
MySQL 5.0 And ODBC
Tried the ODBC 5 connector that MySQL provides - it is an Alpha product and is really not ready for prime time. Does anyone know of any 3rd party ODBC connectors - even commercial ones - that are ready for MySQL 5.0 and support the new stpred proc with parameters functionality in MySQL 5?
Mysql Odbc
i am using Access 2003 connecting to mysql 4. and newest odbc driver, and i set a checkbox form control bound to a unsigned integer field in my database. if its intially set to 0, or 1. it will be checked in my access form. if i uncheck it, it will update my mysql database accordingly to 0. but if i check an unchcked box, it will not let me do it. it seems to send -1 to the field whoever at microsft made (-1 == yes) should die lol. anyone know a way to make access recognize it, or fix odbc driver so it knows if microsoft uses the driver to convert -1 to 0? my best solution is make a trigger on update, and if that new value is -1 set it to , hoping it wont spit back error back to Access for the inital -1 being wrong. any other ideas? wish i knew what event to override to do my own insertion. if checked, UPDATE with 1, if unchcked, UPDATE with 0.
Mysql ODBC Connection +VC+Win
Want to create Mysql ODBC connection with visual C under Windows. I do not want to use DSN. Any ideas? I know there is ODBCconnection class under .NET, but how about visual C?
MySQL ODBC Driver 3.51
The table it is selecting on contains 64 rows. here is an example piece of code: strSQL = SELECT DISTINCT id from table where id = 10 set conn = CreateObject("ADODB.Connection") conn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=as3;Database=name","user","password" set rs = conn.execute(strSQL) 'next line of code' It takes 5 seconds plus to get the the next line of code from "set rs = conn.exec......."
ODBC To Connect Mysql
I would link to use VB to connect mysql using ODBC, but the mysql database is outside my OS. I'm sure that the setting of ODBC is done, but when I connect the ODBC, it prompt me the error message " Host 192.168.xxx.xxx is not allow to connect to mySQL server" What wrong with it?
Mysql Access Through ODBC
I have a Mysql table which has over 40000 records. If i want to access from VB using ODBC connection. will that be good choice related to performance wise. or any other options there.
Create ODBC To MySQL
I have programed PHP appliction using apache and IBM DB2 database using ODBC connection. Is there any simple way to specify ODBC connection to MySQL database and use the same PHP program which is using DB2 as datasource without need to change PHP program code?
MySQL ODBC Connection
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
Win XP Missing MySQL ODBC 3.51
Windows XP sp2, Installed MyODBC 3.51 and the driver. It does not appear in the User/System DSN ODBC control panel. Does not appear in the driver tab Is listed in the ODBCINST.INI and appears in the registry REGEDIT4 Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMySQ L ODBC 3.51 Driver] "UsageCount"=dword:0000000c "Driver"="C:WINDOWSsystem32myodbc3.dll" "Setup"="C:WINDOWSsystem32myodbc3S.dll" "APILevel"="2" "ConnectFunctions"="YYN"
Connecting To Mysql Vi ODBC
I'm trying to connect to a remote mysql database via odbc but for some reason I keep getting the following error in the odbc panel Code: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '69.65.107.209' (10060) I added access to % in mysql access host for now to see if it might just work this way... but for some reason I can't get it working.
MySQL ODBC Connection
I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL ODBC drivers. Each time I try to connect I get the following error: ***************************** ODBC --call failed. [TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130) *****************************
MYSQL ODBC Timeout
I have a simple MS access 2K form to update a MYSQL table. If it sits for about 5 minutes I assume it timesout and reports a ODBC Call failed then Object invalid no longer set..no current record.. If I close the form and re-open I'm back in business.. Can anyone tell me if there is a registry setting or something to get around this issue
MySQL, ODBC And MS Access
I am working with MS Access and mySQL via ODBC. The developer of the mySQL db as used "text" fields in several tables instead of Char/Varchar fields. This poses a problem in that the fields only contain 8 or 10 char and I cannot use them in MS access queries to Join tables since the come across as MEMO fields inthe ODBC linked table.. The developer stated to me that the ODBC driver sometimes does this to Char/Varchar fields. I have worked with ODBC drivers to other DB's including Postgres and Firebird and have never had this problem. I am going to recommend to my client that he have the developer create an empty datbase whereby he replaces the collumns defined as "text" with CHAR (x) of appropriate lengths. Fortunately the other tables in sysem are using integer fields for the keys. Is there a tool that can pump data from one mySQL database to another and deal with the fact that I am moving data from text to a char/varchar field?
|
TRACKER
