(1) MySQL Root Password

i. Stop the mysql service

ii. Create a text file called c:\resetpass.txt and place the following command within it on a single line:

SET PASSWORD FOR ‘root’@'localhost’ = PASSWORD(‘MyNewPassword’);

iii. At the DOS command prompt, (assuming that mysql is under c:\) execute this command:

C:\> C:\mysql\bin\mysqld –init-file=C:\\resetpass.txt

The contents of the file named by the –init-file option are executed at server startup, changing the root password. Note that there should be two backslashes after C: above.

(2) New User

Start the mysql interpreter by typing

C:\mysql\bin\mysql -h localhost -u root -p

Now you can type SQL commands into the interpreter. The one for creating a user called mydb_admin is (note that in the mysql interpreter you must put a semicolon at the end of a command)

CREATE USER 'mydb_admin'@'localhost' IDENTIFIED BY 'mypassword';

(3) Create a Database

CREATE DATABASE mydb;

(3.1) Show a List of the Databases

SHOW DATABASES;

(3.2) Select a Database

USE mydb;

(3.3) Delete a Database

DROP DATABASE mydb;

(4) Privileges

GRANT ALL ON mydb.* TO 'mydb_admin'@'localhost';

Useful Commands

SELECT USER FROM mysql.user;

To see all of the tables in a database

SHOW TABLES FROM mydb;

To see the columns from a table called teams

SHOW COLUMNS FROM mydb.teams;

To delete (drop) a table

DROP TABLE mydb.teams;

To delete a row from a table

DELETE FROM mydb.teams WHERE name='yankees';

Now in principle, you have a new database within which you can add tables, and a user who can manipulate the database.