IPGraySpace: MYSQL - How to download and install mysql 5.7 noinstall archive in windows 10

IPGraySpace: MYSQL - How to download and install MySQL 5.7 no install archive in windows 10

This video shows How to download and install MySQL 5.7 no install archive in windows 10

1. Download MySQL 5.7 zip archive
2. Extract the zip file
3. Copy the extracted folder to the directory where you want to run MySQL
4. Open command prompt go to MySQL bin directory
5. Create a my-init.txt file to change the root password
6. run mysqld initiation (create data folder manually)
mysqld --initialize

7. run mysqld with port 3307 (only if you want to change the default port) with the my-init.txt file

mysqld --port=3307 --init-file=C:\\mysql\\mysql-5.7.19-winx64\\mysql-init.txt

8. open new command prompt go to MySQL bin directory run MySQL with root user

MySQL started now

8.a. successfully logged in using MySQL browser GUI

9. open MySQL workbench login as the root user
10. create new schema 'test' and new user credentials 'test'
11. open MySQL browser and log in as user 'test'

FYI: if you notice I am running two MySQL
one in port 3306 and another one in port 3307 and connect to both the database
successfully

Follow more IPGraySpace videos
-----------------
thank you for watching the IPGraySpace video
please share, subscribe, and comment

visit
www.ipgray.com
www.ipgrayspace.com
for more IT articles, documents, and videos