mysql database installation manually on windows server

Manually Install Mysql Database Service using ZIP file on Windows Server

Here we are going to install Mysql 5.5 on windows machine manually. you can install mysql on

windows two different way one using MSI insttaler and other one is you need to download zip file and install mysql manully. here i m going to install mysql using zip file.

2. Extract Folder in D: or any other drive.

3. Setup MY.INI

Prepare my.ini file change the value of buffer cache, port number and other parameter as per your system ram or environment.

4. Start Mysql Service

After give the my.ini file path to -- defaults file Go to bin path and then execute all command.

bin> mysqld --defaults-file="D:\SOFTWARE\MYSQL1\mysql-advanced-5.5.53-winx64\my.ini"
or
bin> mysqld --initialize --defaults-file="D:\SOFTWARE\MYSQL1\mysql-advanced-5.5.53winx64\my.ini"
or
bin> mysqld --initialize-insecure --defaults-file="D:\SOFTWARE\MYSQL1\mysql-advanced-5.5.53winx64\my.ini"

After executing above command leave the command prompt as it is coz it run mysqld services manually.

5. Installing Mysql Service on widnows.

You can skip step 4 and install mysql services on windows ,so you can see mysql services in windows service.

mysqld --install --defaults-file="D:\SOFTWARE\MYSQL1\mysql-advanced-5.5.53-winx64\my.ini"

6. Set Root Password.
cmd> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql123'); mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('mysql123'); mysql> SET PASSWORD FOR 'root'@'::1' = PASSWORD('mysql123');

7. Now you can logging in mysql using password.

cmd/bin> mysql -u root -p -P 3312

Share your comment and view on this post.