Thursday, September 5, 2019

How to install portable MySql

1. Download mysql version 5.7.57 zip or what ever
2. Extract to folder for example D:\MySql57
3. Open terminal and run command D:\MySql57\bin>mysqld --initialize for initialize folder data.
4. Create file init.txt in folder D:\MySql57 with content ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
5. Now we can start mysql by command: D:\MySql57\bin>mysqld --init-file=D:\MySql57\init.txt --console
Now we can download mysql client tool to connect to Mysql server and enjoy.

No comments:

Post a Comment