MySQL Install in Windows

MySQL.txt

Steps to be followed for installing MySQL
1. Download & Install MySQL.exe

2. Now its time to run as windows service 

https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html

3. Goto Command Prompt, C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" --install

4. Goto run -> services.msc -> MYSQL -> Right click start the services

5. Add the "C:\Program Files\MySQL\MySQL Server 5.7\bin" in PATH Environment Variables

6. Now, goto Command Prompt Open as a Administrator -> mysql -u root -p (No Password)

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

CREATE DATABASE BucketList;

CREATE TABLE BucketList.tbl_user (
user_id BIGINT NULL AUTO_INCREMENT,
user_name VARCHAR(45) NULL,
user_username VARCHAR(45) NULL,
user_password VARCHAR(45) NULL,
PRIMARY KEY (user_id));