Creating Mysql User Account

Let me show you on how to create new user account to your mysql. First you need to connect to server, follow these simple steps:

D:
D:\>cd mysql\bin

    D:\>mysqld –u root

   Note: You need to set the path from which your mysql is located.

Log in to regular "user" account before you to be able to create new user account. 



The image above shows on how to create new user(richard) account with the account password “wordpass”.

This image shows the newly created user account on the third row on  the list of the database “mysql”.

Take note:

You do not need to put semicolon after declaring your password. Example: mysql –u richard –pwordpass;  (You have encountered this prompt: “Error: Access denied to ‘richard’@’localhost’ using password(YES)).