MySQL: Creating a user account

This entry is part 1 of 26 in the series Learn MySQL

Here in this series, we create a series of topics related to MySQL.

Mostly they are common tasks that we need to do if we have a system that uses MySQL.

In our earlier posts, we have created some series related to MySQL.  We will continue from those series.

If you have downloaded and installed WAMP server, the only MySQL user created is root when you first started it.

Say now we want to create a new user called dbuser.

To create the new user, we will first have to login using root.



From the command line,we first login using:

mysql -h localhost -u root -p

Now we set up the user dbuser with privilleges for accessing the database allartist.

The command use is as follow and the password is set by using identified by ‘dbuser’.

create user ‘dbuser’@’localhost’ identified by ‘dbuser’;

grant all on allartist.* to ‘dbuser’@’localhost’;





Series Navigation
MySQL: Connect using Toad >>