Run mysql portable win 10

run-mysql.text

Download mariabd zip for win 10
https://mariadb.org/download/?t=mariadb&p=mariadb&r=11.3.2&os=windows&cpu=x86_64&pkg=zip&m=bkns


Installing MariaDB Windows ZIP Packages
Users need to run mysql_install_db.exe, without parameters to create a data directory, e.g

C:\zip_unpack\directory> bin\mysqld_install_db.exe 
Then you can start server like this

C:\zip_unpack\directory> bin\mysqld.exe --console
For very old distributions (10.3 and earlier), a prebuilt data directory is already provided.


Config port
Run mysql.exe port 3307
C:\zip_unpack\directory\data\my.ini>
[mysqld]
port=3307



C:\zip_unpack\directory\bin\>
mysql.exe -u root -p -h 127.0.0.1 -P 3307

show databases;

mysql show process is run
show full processlist;

use mysql;
select Host, User from user;

FLUSH PRIVILEGES;

Create new user
select password('123456'); (will copy has password for after)
create user 'chau'@'127.0.0.1' IDENTIFIED BY PASSWORD "*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9";
create user 'chau'@'::1' IDENTIFIED BY PASSWORD "*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9";

Phan quyen user co databases
GRANT ALL PRIVILEGES ON *.* TO 'chau'@'127.0.0.1'  WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'chau'@'::1'  WITH GRANT OPTION;


Run
mysqld.exe --console