Hi, Earlier, I forgot to CCed the reply to the list and, accidentally, posted a blank reply instead. So, here is the copy of the reply that I sent to the original poster - in case, someone else has the same problem.
Additionally, I have found that the MySQL ODBC driver installs best when you do it manually - that is, hand-copy files into the Windows System32 directory. In addition, as I have found, it complains that some MSVCR7.dll is missing. When I searched for the file on Google, the search engine led me to some DllFiles.com (or some similar webpage) where I got the file, downloaded the same to my computer and everything worked like a cinch! -- Good luck, Asif On 8/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
.................................................................... I can't get MySQL v5.0 to work on my system.
I got MySQL 5.0.22 running successfully on Win-XP-SP2 as follows: 1) Download the no-install zip package of MySQL-5.0.22 from the website. 2) Unpack it in the directory of your choice (C:\mysql5 - for example) 3) Create a top-level folder - C:\mysql5Data for the data directory. 4) Cut the contents of C:\mysql5\data directory and paste the same into C:\mysql5Data. 5) Delete C:\mysql5\data directory. 6) Create a copy of an appropriate mysql-xxx.ini file and rename it to MY.INI. 7) Change the value of the data-dir variable to C:/mysql5Data - NOTE FORWARD INSTEAD OF BACK-SLASHES. 8) Create another top-level C:\InnoDBData folder. 9) Change appropriate InnoDB data-directory variables in C:\my.ini (with forward slashes!) 10) Right-click MY COMPUTER icon on the desktop and select properties from the shortcut menu. Goto the Advanced tab and select Environment [Variables]. Select PATH in the \ system variables and add C:\mysql5\bin; at the beginning of it. Apply and OK. 11) Select RUN from the start menu, type CMD and press ENTER. 12) Right click the C:\InnoDBData folder, select Properties from the shortcut menu and add "LOCAL SERVICE" user-account in the security tab and give it "Full Control" access. 13) Do the same as in 12) with the C:/mysql5Data folder. 12) type mysqld-nt --install YourServiceName --defaults-file=C:\mysql5\my.ini --local-service and press ENTER. 13) type NET START YourServiceName AND PRESS ENTER. Now you have MYSQL-5.0.22 installed on WinXP-Pro-SP2. Forget about the automatic installer. I got similar errors like yours. -- HTH, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]