MySQL managing password modification and Management permission setting (zz)

Mysqladmin-uroot-Password ab12

Modify again

Mysqladmin-uroot-P ab12 password ad12b

Manage permission settings

Database operations can be performed 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 operations

Show databaes;

Show tables;

Display the data table structure

Decribe indicates

Create Table Name

Drop database Database Name

Displays records in a table.

Select * From indicates