MySQL 5: Install MYSQL 5 in Windows 7

* Download and extract mysql-noinstall-5.1.30-win32.zip to c:\prog directory
* Rename extracted folder from mysql-5.1.30-win32 to mysql
* Give full control of the folder to LOCAL_SERVICE

mysql51_1_permission_localsvc

* Change directory to c:\prog\mysql and copy my-medium.ini to my.ini
* Edit my.ini, append following lines to [mysqld] section:

basedir = c:\prog\mysql
datadir = c:\prog\mysql\data
# Also increase max_allowed_packet
max_allowed_packet = 64M
mysql51_2_myini

* Copy my.ini to c:\windows directory
* Install MySQL as a service by opening a privileged DOS command window and enter:

cd c:\prog\mysql\bin
mysqld.exe --install MySQL --defaults-file=c:\windows\my.ini --local-service
mysql51_3_installAsSvc

* Start service:

net start mysql

* Set root password:

mysqladmin.exe -u root password "Welcome1"
This entry was posted in mysql, win7 and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


*

This site uses Akismet to reduce spam. Learn how your comment data is processed.