How to work with MySQL portable on Windows

MySQL_Portable.txt

mysqld.exe --skip-grant-tables

mysql
UPDATE mysql.user SET Password=PASSWORD('TopSecret') WHERE User='root';
FLUSH PRIVILEGES;


"D:\Programme\mariadb-10.0.12-winx64\bin\mysqld.exe"

"D:\Programme\mariadb-10.0.12-winx64\bin\mysqladmin" -u root -p shutdo
mysql -u root -p


GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;


use mysql;

update user set host='%' where host='localhost'


The easiest way is to comment out the line in your my.cnf file:
#bind-address = 127.0.0.1 

CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;


 CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> CREATE USER 'dummy'@'localhost';


http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

To run it on a different port:
mysqld --port=port_num



http://www.debian-tutorials.com/how-to-fix-error-unknownunsupported-storage-engine-innodb

How to Fix [ERROR] Unknown/unsupported storage engine: InnoDB
Remove the ib_logfile0 and ib_logfile1 files located in /var/lib/mysql.

rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1

resp. 
D:\Programme\mariadb-10.0.21-winx64\data\ib_logfile0
D:\Programme\mariadb-10.0.21-winx64\data\ib_logfile1

To Shutdown:
mysqladmin shutdown  -u root -p