[MySQL] Installing MySql on windows 7 no-installer

Getting the MySQL service to work

• Extract the file contents to desired directory.
• Create a 'my.ini' file in the root of the new directory.
• Copy the following info into my.ini:

[mysqld]
 basedir = C:/mysql
datadir = C:/mysql/data
port = 3306
socket = /tmp/mysql.sock

• In command line, run ' mysqld --install ' to add the MySQL service
• Run MySQL service 
• Then just run mysql to start mysqling. lol

Creating Users

• Run mysql
• Type in: create user 'username'@'localhost' identified by 'password'
• Grant privileges by using the following as guidelines:

GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';