Urtech.id

Learning By Doing


Create new user in MySQL and give it access to database

This article describes how to do common MySQL database administration tasks from the command line using the mysql program. Try this to create new user in MySQL and give it access to database: CREATE USER 'username'@'hostname'; set password for 'username'@'localhost' = PASSWORD('password');  Try this to give it access to the database dbname : GRANT ALL PRIVILEGES ON dbname.* To 'username'@'hostname' IDENTIFIED BY 'password'; or with grant option :GRANT SELECT, INSERT, UPDATE, DELETE,...

Tito Santana