Friday, May 14, 2010

MySQL fast configuration

Creating User:

create user pron@192.168.1.13 identified by 'pass';

This will create an user called pron that could connect from the host 192.168.1.13 to the MySQL server.

If we want to create an user that could connect only from localhost, we won't espicify the IP address.

Creating DataBase:

create database mydb;

Adding user to DataBase:

grant all on mydb.* to pron@192.168.1.13;

No comments: