MySQLADMIN -UROOT -PASSWORD AB12
Re-modify
MySQLADMIN -UROOT -P AB12 Password AD12B
Management permission setting
Databases can be operated on any host
Grant SELECT, INSERT, UPDATE, DELETE ON *. * TO
TEST2 @ "%" indentified by "abc";
Grant SELECT, INSERT, UPDATE, DELETE ON MYDB. * TO
TEST2 @ localhost indentified by "abc";
Grant SELECT, INSERT, UPDATE, DELETE TO MYDB. * To
Test2 @ localhost indentified by ""
MySQL database operation
SHOW DATABAES;
Show table;
Display data table structure
Decribe indicates
CREATE TABLE Name
DROP DATABASE Database Name
Display record in the table
SELECT * from FROM indicates
