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:
Post a Comment