MySQL 5.7 zip version (zip version) installation and configuration steps detailed

# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = .....

C:\Users\donald>cd D:\tools\developer\MySQL\mysql-5.7.17-winx64\binC:\Users\donald>d:D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld -installService successfully installed. //Successful installation of the service

D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld --initialize D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>

D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld.exe -nt --skip-grant-tables

mysql> update user set authtication_string=Password('admin') where user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql>flush privileges; 0 rows affected (0.01 sec)

C:\Users\donald>net start mysql

C:\Users\donald>mysql -u root -p //Enter admin