mysql|odbc| problem
After installing MySQL 5.0, start winmysqladmin
The following information appears in the Environment column
--myodbc--------------------------------------
Not Found
Driver Version
Driver C:\Windows Ystem32\myodbc3.dll
API level
Setup C:\Windows Ystem32\myodbc3.dll
SQL level
----------------------------------------------
See map:
"Small picture" Small.gif[/url
"Big picture" big.gif
Start MySQL service times wrong, unable to start MySQL
The question bothered me for two days. I have been looking for N for a long time on Google, there is no solution to search.
1. Operating system WinXP Pro SP2
2. Database MySQL 4.17 and MySQL 5.0 have been tried
3. Myodbc 3.51.06 and the latest MYODBC 3.51.9 have been installed, adding data sources to the ODBC Administrator to connect to the remote MySQL server's data source and then testing is successful.
4. I used the MYODBC 3.51.06 and MySQL4.01 are normal operation. I later installed MYODBC 3.51.9 without uninstalling the MYODBC 3.51.06, then uninstalled MYODBC 3.51.06, then installed MySQL 5.0, and then found the problem.
5. Then I thought maybe Myodbc 3.51.9 is the same as the MYODBC 3.51.06 driver file, uninstall Myodbc 3.51.06 will delete myodbc files; so I uninstall all 3.51.9 and reinstall MYODBC 3.51.9.
6. But the problem remains.
Headache.
------------------------------------------------------------
I have successfully started MySQL.
Although it is still the hint of the not Found in Winmysqladmin.
But MySQL is already functioning properly. The main problem is mysql.ini.
Winmysqladmin the Basedir in the default generated Mysql.ini is incorrect.
------------------------------------------------------------
My MySQL is installed in the
Attached Mysql.ini file d:/mysql/servers directory, not the default c:\mysql.
Winmysqladmin The default generated Mysql.ini Basedir=d:/mysql instead of d:/mysql/servers
This causes MySQL to not start.
----------------------------------------------------------------
[Mysqld]
Basedir=d:/mysql/servers
#bind-address=192.168.10.55
Datadir=d:/mysql/servers/data
#language =d:/mysql/servers/share/your Language Directory
#slow Query log#=
#tmpdir #=
#port =3306
#set-variable=key_buffer=16m
[Winmysqladmin]
Server=d:/mysql/servers/bin/mysqld-nt.exe
----------------------------------------------------------------
Winmysqladmin the problem with the Myodbc not Found, it is estimated that the client version of MySQL does not have to worry about it.
Or you can install MySQL Administrator 1.0 instead of it.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.