MYSQL :: Uninstall MyODBC

How To Uninstall MySQL 5.0
-- I downloaded MySQL 5.0 thinking it would only make things smoother for me, since updated versions include bug fixes, and smoother operation. I quickly found out that I shot my self in the foot by doing this. The book teaches you as if your only using the previous version, this isn't that big of a deal, but when I'm just starting out, I need to follow the book exactly word for word for *me* to learn it properly.

-- So far, I've tried the following to remove MySQL 5.0 so I can go back and install MySQL 4.0.20.

1. I moved my MySQL folder from C:Program filesMysqlMysql 5.0 serverin to C:MySQL (I had some DOS problems and had to move it in order to fix that problem).

2. It was after fixing this DOS problem that I realized I needed to remove 5.0 and get 4.0.20. I tried to do an add/remove programs, and it simply removed MySQL server 5.0 from my "add or remove programs" list, but all my MySQL files were still there (Most likely because I changed directories without knowing it would effect uninstallation).

3. Next, as more or less an experiment, I installed MySQL 5.0 again in the original directory (C:Program filesMysqlMysql 5.0 serverin). Then I went back to add/remove programs and removed it again. After a reboot, it removed all the files except for "data" folder, which leads to a "mysql" folder with a bunch of files, titled host, columns, tables, proc, time zones, e.t.c.

4. I've checked multiple tutorials on MySQL, including this site, and all I can get is how to *update* an already existing MySQL to a better version. Or how to remove MySQL as a service. All I want here is to completely remove MySQL 5.0 from my computer, so I can start fresh with MySQL 4.0.20.

-- So now for my question =P. I simply need to know how to completely remove MySQL 5.0 from my computer, thats it. The catch is, I kinda have two installed now. One with all the files, and one with only the "MySQL --> data folder --> MySQL folder" (Which I described earlier). If anyone can add some insight on this I would greatly appreciate it, I should have just installed the previous version from the start.

Uninstall MySQL On OS X
I have installed two different version of MySQL

- MySQL 4.0.24
- MySQL 4.1.11

After that I decided to uninstall them to perform a new clean install of 4.1.11

I have deleted both
- MySQL 4.0.24
- MySQL 4.1.11
in /usr/local/

But after a reboot ( and nothing in the Startupitems folder) MSQL.prefPane still says "The MySQL Server Instance is running" and I cannot use the "Stop MySQL server" buton as only the "Start MySQL server" is available... And if I use it, I have this message "Could not startup MySQL Server. Reason: Internal error".

Code:

Uninstall MySQL RPM
How to uninstall MySQL rpm package?

Uninstall Mysql
how to uninstall the binary version of mysql (4.1), I deleted the directory but when I went to reinstall mysql again I was getting new errors.

Uninstall MySql Server 4.1
I am trying to uninstall MySql Server 4.1. I have googled and used the serach engine but I can't seem to find a decent tutorial/article/explanation on how to do this. I have windows XP.

I tried to remove it from the services with mysql -k uninstall, like I did for Apache, but it didn't work. Any advice? Or could anyone point me to aggod link?

Uninstall MySQL To Start Over
I just want to uninstall it and start again from scratch. I tried following the cleanup instructions at entropy.ch but it was unable to run, outputting an error:

I was unable to find inforation on the old package, cannot continue.
Does anyone know some commands that will let me completey remove MySQL (current cersion) so that I can begin over from scratch with a new install?

Uninstall Old Mysql Completely Red Hat 9
I have been running phpbb for a couple years on this machine I have. It has run flawlessly until just recently. We were unablbe to access the webpage and all, though other services were still being hosted fine.

It seemed like a good time to upgrade apache/mysql/php. I am running red hat 9 on the box and I just downloaded the source files for each and compiled and installed. For whatever reason we can't seem to get the mysql to integrate back in correctly. What I would like to do is COMPLETELY remove every trace of the older mysql install and then reinstall.

Uninstall In Order To Restart
I installed mySQL on my Mac and it worked fine. But when I went to start up the mySQL monitor through the mySQL preferences pane it did not work. Then I installed it again which completely messed it up.

I then proceeded to delete all of the files located at /usr/local/ and tried to reinstall it. This did not help because when I tried to start up mySQL in system preferences I still got a message saying

"You cannot open mySQL preferences pane on this computer. Contact the developer of this software for a newer version."

I was hoping to simply completely uninstall mySQL and start from scratch or if anyone has another idea I am open to suggestions.

Can't Install / Uninstall MySQL
we have a server on which someone blew away the MySQL 4 progs directory
before installing MySQL 5. When installing MySQL 5 the installation
failed with an error stating that it was unable to create system tables
as the MySQL 4 directory did not exist.

We are now unable to uninstall MySQL 5:

[root@server1 local]# rpm -i
MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
warning: MySQL-server-standard-5.0.18-0.rhel3.i386.rpm: V3 DSA
signature: NOKEY, key ID 5072e1f5
package MySQL-server-standard-5.0.18-0.rhel3 is already
installed

[root@server1 local]# rpm -e
MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
error: package MySQL-server-standard-5.0.18-0.rhel3.i386.rpm is not
installed

How To Uninstall The Mysql Sevice?
First I installed mysql 4.0.20d on my winXP SP1 laptop. And then I wanted to install a new version and forgot to uninstall it in normal way. While the binaries of mysql was deleted, the mysql service still stayed there.

I installed the mysql 4.1.12a, but its sevice couldn't be launched by the Config Wizard. I supposed that the old version service caused it, but I don't know how to delete it.

Totally Uninstall MySQL
I have forgotten my password(s) for MySQL. I have uninstalled MySQL Server 5.0 and removed the directory. Upon reinstall, I gave it a root password. If I try to access via Query Browser or MySQL Admin it still defaults to my old user name. I have tried the command line prompt with the new root password but access is denied. I am just starting and I have no usefull data so I can wipe it clean and reinstall from scratch if anyone can tell me how to eliminate all traces of the prior installation.

MyODBC
I have a mySQL database hosted by a company. I installed the myODBC connector and need to connect to it in a vb6 program. I set up a user and password for the database i want to connect to. My string looks like this:

Dim conn As New ADODB.Connection

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=rentapar_System_Property;UID=rentapar_Client;PWD=password;"

it says it can't connect to mySQL server on 'localhost'
I am not getting where it is looking for the server. Do I need to set up a DSN? If so what do I use as server? Where do I point it to the hosted server? Please help!?? Do most hosting companies allow access from off the net like an application?

MyODBC
I have problem in using ODBC for Voice Guide (an IVR application). I can connect to MySQL database successfully. The only thing is that everytime the system tried to connect to MySQL database through ODBC the Connector/ODBC Configuration Windows Pops Up. I have tried to pass Option=16 and also tick "Don't Prompt Upon Connect" property on Flag 2 but the window still pops up.

Here is the details of my system:
OS: Windows XP Pro SP2
MySQL Server: version 4.1.11-log via TCP/IP
Client version: MySQL Client Version 5.0.11
ODBC version 3.51

I didn't have this problem before I reformat my harddrive and reinstall Windows.

MyODBC 3.51
I have a C# program which uses a remote MySQL database to store user information. It uses MyODBC 3.51. However, I find making people download and install MyODBC seperately from the application rather annoying. Is there any way I can package MyODBC with the installation package for my application

MyODBC To OpenOffice.org
I'm trying to connect OpenOffice.org to MySQL through MyODBC. MySQL is
set up, but I'm having problems setting up MyODBC. I checked the
documentation on the MySQL webpage, and tried to set it up that way, but
OpenOffice.org can't find MyODBC. It can't find the libodbc.so.1. I
tried to follow the set up PDF file on the OpenOffice.org webpage, but it
switches between MyODBC and UnixODBC.

I copied the libraries to /usr/lib, and made the link in /usr/local. I
set up the obdb.ini in /usr/etc. Is there something I'm missing to set up
the connection? Has anyone had luck with this?

Myodbc Error
------=_NextPart_000_000D_01C35CF0.20AC1200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

i get this msg:
Microsoft.Data.Odbc.OdbcException: NO_DATA - no error information =
available
at Microsoft.Data.Odbc.OdbcConnection.HandleError(Int Ptr hHandle, =
SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, =
Int32 cb)
at Microsoft.Data.Odbc.OdbcDataReader.internalGetStri ng(Int32 i)
at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap)
at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at Microsoft.Data.Odbc.DbCache.AccessIndex(Int32 i)
at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at Microsoft.Data.Odbc.OdbcDataReader.get_Item(String value)
at =
F=E6llesDialogbox.frmAddIngDialog.cboVaregruppe_Se lectedIndexChanged(Obje=
ct sender, EventArgs e) in C:Documents and SettingsAdministratorMy =
DocumentsVisual Studio =
ProjectsDatasystemKSF=E6llesDialogboxfrmAddIng Dialog.vb:line 357

then i try to get a row out fo the database mysql 3.23.54 run on redhat =
linux 9.0 i am acceessing it from vs.net via odbc.net.
i am using myodbc 3.51 and my code look like this:

Try
Dim plunr As Integer
Dim varenavn As String
Dim varegruppenr....................................................

MyODBC Driver
Trying to use MySql 5.0.27 with Dreamweaver MX & PHP & Apache

In "Inside Dreamweaver MX" the authors state 'If you're using MySQL as your DBMS, you need to use the MyODBC driver to create your DSN's See Appendix C for full coverage of obtaining & setting up MyODBC' Unfortunately Appendix C does not mention MyODBC although is does mention MySQL.

They are referring to an earlier version of MySQL (3.23) and show setting up the DSN in windows.

My problem is I cannot see the MyODBC driver. Is this a separate download?

MyODBC And Citrix
My client (and hence I!) need to install MyODBC on a Citrix server, but
when the MyODBC installation .exe is run, it fails. The .msi also fails.

Investigation on the web indicates that this might have something to do
with the Citrix environment not liking "hardcoded" paths in installation
programs, but naive fumbling with Orca on the .msi didn't really help.

Has anyone succeeded in installing MyODBC in a Citrix environment, and
if so, how?

MyODBC Time
recenlty I wanted to migrate my app from MySQL 3 to MySQL4.1.19, conector: MyODBC 3.51.06 into MyODBC 3.51.11-1win.

Now I have a problem with time values from my database. In a field I have the value '00:00:01'. When I retrieve this value in my app (via MyODBC) i get a null value. I don't want that null value, I vant my '00:00:01'.

Before the migration, I hadn't this problem ... everything worked fine. Is there a setting in MyODBC that I must check to solve this? If not, how can I solve this problem ... quick?

MyODBC Mapping
I have an VB frontend that can't be changed for various reasons, and have
been attempting to move the database (access) out to MySQL (for various
other reasons ;). I haven't been able to successfully read True/False
fields, and after much research it appears that I need to map any true/false
or yes/no to 1/0 in the MyODBC source code.

I've downloaded the source code, but I haven't been able to determine what
and how to change the mapping. Any assistance would be GREATLY appreciated!

FYI: I tried treating the MySQL side as an enum field, but the VB front end
won't accept the result.

MyODBC VB6 Problem
I have made a program that runs off the task scheduler. It connects to a web database using MyODBC. This works most of the time, but once in a while i'll get the MyODBC DSN connection window. I'm not sure why this pops up. should i upgrade the MyODBC from version 2.5 to the newest version? If this is not the case, is there a way to hide this in code or through settings.

MyODBC Driver
I have winxp as OS & my php folder is located in c:XXXXphp.

I am getting these errors while running a php code-

Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user 'ODBC'@'localhost' (using password: NO) in C:wampwwwprosenjitOODatabase.class on line 16

Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch mysqli in C:wampwwwprosenjitOODatabase.class on line 32
Database is not available. Try again later

Will installing 'MyODBC Driver' solve my problem? What other things should i ensure so as not to get these error.I have WAMP5 installed.

Connector MyODBC
Can I using MyODBC to connect to MySQL Server through A Proxy Server ?

MySQL / MyODBC
I installed MySQL v4.0.20d and MyODBC v2.50.39 on a Windows 2000 workstation SP4. When I go to StartProgramsAdministrative Tools I don't see the Data Sources menu option. When I installed the same software on a Windows 2000 Server, I do see the Data Sources menu option.

MyODBC And DB Access
I setup Apache, PHP, and Mysql on our internal server probably 5 years ago. It works so good I NEVER have to do anything so I've gotten really rusty. The problem is we use UPS through MyODBC to add shipping data to our DB. We recently got a new computer to run the UPS stuff. I can't get MyODBC to connect from the new computer to save my life.

I joined our domain restarted a bunch of time and still when I setup the system I get an error to the effect of "Matt@MASTER" password =yes access denied. Now here is the kicker. the computer name isn't master its been renamed. I removed the 3.5 MyODBC driver and installed the 2.5 like the old computer had just to be sure. It is doing the same thing. So I found a way thanks to google to grant access to that username in a range of IP addresses.

here it is: "GRANT ALL PRIVILEGES ON db.* TO matt@'192.168.0.0/255.255.255.0';

which has a result of 0 rows effected!?

I have tried a different user when using the mysql program on the server machine and been able to login with it and the matt user mentioned above. However still nothing at the MyODBC end with the UPS system.

Configuring MyODBC
I am using MyODBC 3.51 with Borland BDE, and was having a problem whereby Blob result fields were being restricted to a maximum size of 32k. Now, in the BDE control panel, I can set configuration variables for the MyODBC driver, and I was able to change the value of BLOB SIZE from 32 to 128, which solved the problem. However, there are many other configuration variables there (TRACE MODE, BATCH COUNT, BLOBS TO CACHE, ENABLE SCHEMA CACHE, ROWSET SIZE, etc.) for which I have not been able to find any documentation. Does anybody know where I can find documentation for these settings?

MyODBC Install
For the fourth day I'm trying to install MyODBC. I installed the old 2.5 ver as well as the newest 3.5.The install completes successfully but when I go to the ODBC admin and try to add a new DSN, mysql is not in the driver list. I checked the registry and it is there- but not in the list.

Please someone help, I've never been pushed this far back in development by something that seems so simple / are there any 3rd part MySQL drivers I can use?

MyODBC And Remote
I'm conected to server and my app works just fine, and I was connecting to MySQL over ODBC (my app is running on winXP)! It was good while I was using only USERNAME with blank PASSWORD in MySQL! But when I put password, I can't connect, and of course my USER/PASS combination is OK! I try to search for known MySQL bug in this version but with no results!

Views And MyODBC
well i just installed MySQL "5.0.1-alpha-nt-max" to play around with the new Features on my local PC.reating and accessing Views seems to work, but as it seems MyODBC 3.51.09 cant handle Views.
Are there any plans to support Views also via MyODBC ?
If so, is that Feature currently in the Bitkeeper-Repository of "MySQL Connector/ODBC 3.52" ?

MyODBC - Updating Joins
I am using MyODBC (35017) in VB and i get an error when I try and update a recordset which involves a join. Surely one isnt limited to only single tables?

Recordset.CursorLocation = adUseServer

Recordset.Open "SELECT pd.products_name 'Product Name', p.products_quantity 'Product Stock' FROM products p, products_description pd WHERE p.products_id = pd.products_id;", Connection, adOpenForwardOnly, adLockOptimistic

Recordset(1) = 5
Recordset.Update
Recordset.Close

Gives me the following error: "Query clause can not be updated because the FROM clause is not a single simple table name"

Retaining Control From MyODBC
I'm developing a system with an Excel front-end that uses ADODB and MyODBC to fire off instructions to a (local machine) MySQL server. As I step through my VBA code, it sends an instruction to MySQL (e.g. gconMySQL.Execute "DROP TABLE IF EXISTS MyData;" ), waits for the instruction to be executed, before returning control to the code and moving on to the next VBA statement. All well and good; this works fine for the majority of the processing.

However there is some initialisation of the MySQL database, particularly loading some data tables into MEMORY, that takes up to half a minute to complete. I'd rather fire off the instruction(s) to MySQL to do this so that MySQL initialises invisibly in the background, whilst the user continues playing around with the front-end themselves.

Linking MyODBC Drivers
Could someone please help me with the linker options for linking the MySQL ODBC drivers. I'm running on Redhat Linux, with gcc 3.4.6.

Myodbc 3.51 Connector Freezes
I just installed mysql server 5.0 and myodb driver 3.51. Now I'm trying to make a DSN on my system. When I enter the Data Source Name, Server, User and Password, then when I click the Database drop-down menu, the program freezes. It does not do anything, just sits there. I set up the database properly, and it is configured and ready to go but I cannot get past this.

Slow Performance Using MyODBC
I am creating a pair of applications that essentially transfer data from a remote client to a local server. The trick is that "remote" in this application means "way out in the mountains where it takes an hour by four wheel drive to reach the nearest paved road and don't even talk to me about a cell tower for another hour or so of driving".

Because of this, we are using shoe-leather-net to communicate between the client and the server. The client is collecting data into a MySQL table. Every so often, a person will use the client application to copy the data onto a thumb drive and carry it down the mountain to the server, where the partner application will copy the data into an identical MySQL table. These are distinctly non-technical people I am talking about here - typing a file name is a high-skill activity - so this needs to be a dead-simple user interface.

The data is sensitive, so it is encrypted going on to the thumb drive and decrypted coming off.

Here is the question: The copy process that I have programmed is very slow - on average 2 seconds per row - on both ends of the transaction and this does not seem right. What can I do to improve it?

When the process is running, Task Manager shows that mysqld-nt is using as much of the CPU as it can get and the actual application is only using CPU time once in a while.

The basic client task is this:
-- Read a row from the local table
-- Encrypt the row
-- Write the encrypted row to the file
-- Repeat until all of the unexported data has been copied

The basic server task is the inverse:
-- Read a line from the file
-- Decrypt the line and construct a corresponding INSERT statement
-- Execute the INSERT
-- Repeat until end-of-file

Other possibly pertinent information:
-- Windows XP Pro
-- Visual Basic.Net
-- MySQL 4.1.14-nt
-- MyODBC 3.51.13 Dave Gee

MyODBC Mapping Question
I have an VB frontend that can't be changed for various reasons, and have
been attempting to move the database (access) out to MySQL (for various
other reasons ;). I haven't been able to successfully read True/False
fields, and after much research it appears that I need to map any true/false
or yes/no to 1/0 in the MyODBC source code.

I've downloaded the source code, but I haven't been able to determine what
and how to change the mapping. Any assistance would be GREATLY appreciated!

FYI: I tried treating the MySQL side as an enum field, but the VB front end
won't accept the result.

MyODBC Command Syntax
I'm trying to do what I thought was a fairly simple thing, select a group of
records from a mySQL database.
I'm not much of an SQL guy. The syntax I would use for Microsoft SQL is
shown on the "query =" line.
A myODBC error message indicates this is not supported syntax.
Can anyone help me?

{ ADO Startup Values and Creation using the .Open method}

{Create a COM object reference to ADO Recordset.}
recordset = COM_CreateObject("ADODB.Recordset");

{ Open a Recordset }
query = "SELECT * FROM t_course_date
WHERE(modified>=CONVERT(DATETIME,'1999-07-31 00:00:00',102))";
("modified" field above is a mySQL field name)

recordset.Open(query, 'connection id', adOpenDynamic,adLockOptimistic); <--
This statement fails.

C++ Wrapper For UnixODBC/MyODBC

I used an odbc-wrapper connectting mysql with unixODBC.
But it didnt work well, often some exception occured.
So I need one new wrapper for unixODBC, it must run stably.

MS Access, MySQL & MyODBC .....
I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11
standard log.

I created my tables in MS Access, then exported them via ODBC to an
externally hosted MySQL database (fasthosts) . I then import-linked
them back into my MS Access database.
Before I import linked them back, I edited the tables in MySQL so that
the PK & Autonumber was set and added a timestamp field.

The problem I seem to have is that when I use the Timestamp field in
MySQL, I cannot seem to update current records on my Access forms
without getting the error 'Reserved Error (-7776)'. If I remove the
Timestamp field, the error goes away, but then I get the usual #Deleted
problem when adding records etc.

I know the timestamp is required, but I cannot seem to get arround this
unknown error ?

MyODBC 3.51 To MySQL 5.0 Alpha
I am recently testing out MySQL 5.0.0_2 Alpha on a FreeBSD 5.2 server.
Also, I am experimenting with MS Windows connectivity, and although the MySQL Administrator application works beautifully, I seem unable to establish an ODBC DSN to the database.
I installed MyODBC 3.51.06 but it fails upon authentication with the following message:
[MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client
And am I considering, but it doesn't help. Any good suggestions or is it not yet possible to connect through ODBC

MyODBC And Hierarchical Datasets
Has anyone tried (and succeded?) in specifying the appropriate connect
string for a hierarchical dataset using MyODBC?
It's where you specify MSDATASHAPE as your "Provider" but then need to
designate MyODBC as the "Data" Provider.

How To Set Multiple Statement In MyODBC Connectionstring
http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration-connection-parameters.html
If I want to set multiple command lines in "stmt" parameter, how to do that?

My current connection string
strConn = "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; CharSet=utf8; Port=3306; Option=0; Socket=; Stmt=SET names 'utf8' Database=yyy; Uid=xxx; Pwd=zzz;"

Need To Install MyODBC 3.51.14 On Windows Client
We have recently upgraded the MySQL client on a Windows machine to 5.0.38. In concert with that upgrade, we must ensure that MyODBC 3.51.14 is properly installed, as well.

After executing searches on the mysql.com website, I cannot locate guidance for the following issues:

1) To what link do I navigate to download the MyODBC 3.51.14 installation files?

2) What must I do to the client machine to prepare it for the 3.51.14 installation? (e.g. uninstall the old MyODBC driver?)

3) What specific steps do I follow to successfully install MyODBC 3.51.14 on the client machine?

MyODBC With Access Update Issue
I am having a problem with using MSAccess (2003) on the front end of a MySQL DB (4.1.10a). When I add a timestamp field, the Access table will allow me to add the record and provides a proper refresh without a #deleted# record. When I attempt to update the table in Access, I get an error of SQL data out of range error. If I delete the timestamp field, I can update the record, but then get the dreaded #deleted# record information. MyODBC version is 3.51. I have upgraded the MDAC to the latest version.

MyODBC 3.51 Executing Multiple SQL Statements
I am using MyODBC from VB and I want to submit a batch of insert statements
in one call from my App. This is more efficient than making multiple calls
from code because of the communication overhead.

If I send a batch multiple statements separated by ; or ; + newline I get
syntax errors pointing at the start of the next statement..
If I fire each statement one at a time with the ; at the end there's no
problem.

I cannot be the first person with this problem. Is it common practice to
make multiple calls from you application or is there a magic trick I am
missing? Code: