mysql windows snippets zip noinstall portable offline

How to download - windows interactive.md

option 1

• go to https://dev.mysql.com/downloads/mysql/
• choose the version, os and type

• login and download it

option 2

Download the mysql database for windows https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.25-winx64.zip

Start mysql on windows without installer - PRO USERS.md

With these steps you can start the latest version mysql database without the need to install the database, or the mysql workbench, wamp, xamp, or anything similar

• Download it following https://gist.github.com/jrichardsz/d4fce9b45ca5ac27921610b11221965b#file-how-to-download-windows-interactive-md
• Unzip it anywhere on the disk
• Create the folder C:\mysql\ data
• Inside create a file called root.txt with the following content

ALTER USER 'root' @ 'localhost' IDENTIFIED BY 'changeme';

• Open a cmd window with administrator permissions
• Using the open cmd, go to the unzipped folder. Enter the /bin folder and run

mysqld --initialize
mysqld --init-file=C:\mysql\data\root.txt --console

• Load a bit and in the log you should see a message like:

mysql-x-winx64\bin\mysqld.exe: ready for connections. Version: '8.0.25' socket: '' port: 3306 MySQL Community Server - GPL.

• If there is an error related to an already used port, it is because another instance of mysql is already running. Enter services.msc and stop the mysql service or use the netstat command to locate the process that is using port 3306 and execute a kill

• If there are no errors, you could connect to this mysql using the following parameters

• host

  • localhost

• port

  • 3306

• user

  • root

• password

  • changeme

• You can use the dbeaver or sqlyog ide

• It should be possible to create databases and tables normally