Jump to: navigation, search

SRA840 Lab7

315 bytes added, 20:42, 11 April 2009
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');

Navigation menu