1
edit
Changes
no edit summary
GRANT CREATE, INSERT ON vyas.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD 'password hash';
You can give a plain text password but it's better to use hash if you know your password hash.
* Remove user rights: REVOKE ALL FROM 'user'@'localhost';* Create a table: CREATE DATABASE vyas; USE vyas; CREATE TABLE tmp (name VARCHAR(20), sex CHAR(1), bday DATE);* Insert a few records into the table you created: INSERT INTO tmp VALUES ('Abc','M','1900-01-02'); INSERT INTO tmp VALUES ('Xyz','M','NULL');
