Ever since MySQL 5.0.27, I have never been able to install the MySQL Service
either.
I think this has something to do with the way Microsoft compiles its OS
Services.
I use the "no installer" version now.
1. Go to a DOS Window and create a directory called C:\ MySQL_5.1.32
2. Click Start, Run, and type Open : C:\ MySQL_5.1.32. This will open a Windows
Explorer Window in that new empty Folder.
3. Download mysql-noinstall-5.1.32.zip to the Windows Desktop
4. Open the mysql-noinstall-5.1.32.zip and another Windows Explorer window
opens up containing the folder 'mysql-noinstall-5.1.32-win32'
5. Double click that 'mysql-noinstall-5.1.32-win32' folder and another window
shows the folders 'bin','data','Docs' and so forth.
6. Select all files and folders by hitting Ctrl-A
7. Drag and Drop those selected files and folders into the 'C:\ MySQL_5.1.32'
Window
8. Right-click on 'My Computer', and click on 'Properties'
9. Click on the Advanced Tab
10. Click the Environment Variables button
11. Scroll the bottom listbox to the PATH variable
12. Double Click the PATH variable
13. Append ';C:\MySQL_5.1.32' to the PATH variable
14. Click OK 3 times
15. In the 'C:\MySQL_5.1.32' Window, copy 'my-small' to 'my' (In other words,
copy mysql-small.ini to my.ini)
If you do not do this, you will be starting mysqld with all server
defaults
16. Create a DOS Batch File called start_mysqld.bat with the following lines
@echo off
set MYSQL_HOME=C:\MySQL_5.1.32
set MYSQL_BIN=%MYSQL_HOME%\bin
echo %MYSQL_BIN%
cd %MYSQL_BIN%
pause (This line is optional)
start mysqld
17. Create a DOS Batch File called stop_mysqld.bat with the following lines
@echo off
set MYSQL_HOME=C:\MySQL_5.1.32
set MYSQL_BIN=%MYSQL_HOME%\bin
%MYSQL_BIN%\mysqladmin -uroot shutdown
18. Create a ShortCut for both batch files and place them on the Desktop
19. Double Click the ShortCut for start_mysqld.bat
This should start up mysqld
Open the task manager and look for 'mysqld.exe'
20. Goto a new DOS Window and type 'mysql -uroot'
You should be mysql now.
If you got to this point successfully, have fun from here !!!
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype : RolandoLogicWorx
redwa...@logicworks.net
-----Original Message-----
From: Manish Gupta [mailto:manish.in....@gmail.com]
Sent: Tuesday, March 24, 2009 4:05 PM
To: mysql@lists.mysql.com
Subject: Installation Problems
I had MySQL 4.0.
Today i downloaded the recent version, mysql5.12.32-Win32 installer.
I deleted the older verison of mysql that i had. I didnt have any data there
and thus no upgrade was needed as such.
I used typical install option and after the install i used the standard
configuration for the server configuration wizard. i typed the password
required and the problems started.
1. It couldnot install mysql as a service, named MySQL, although there is no
service with that name. i checked with the service option in control panel.
2. I went back and installed it with the service name MySQL5. This time, it
installed the service, but could not apply the security setting and
terminated with the error, saying root doesnot have the permission to log on
from localhost.
3. I opened the command line clien from the start menu. It asked for the
password, i typed it in and the interface disappeared.
I uninstalled and then installed it again a couple of times, but one or the
other erroe kept reccuring. I'm still havent been able to use MySQL.
Please Help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
