THE Wiki

Download zip file from http://www.mysql.com/downloads/mysql/ Unzip to c:/mysql Select an appropriate my.ini Initial configuration of my.ini add line: datadir = D:\mysqldata

Configure users set passwd for user root

 UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

create database

register user examples

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

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

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

mysql> CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS,CREATE,UPDATE ON database.table TO 'admin'@'localhost';

mysql> CREATE USER 'dummy'@'localhost';

set rights

FLUSH PRIVILEGES;