MySQL Basic operation

1. Modify User Password

mysqladmin-uroot-p123456 Password 123 (description: 123456 is the old password, 123 is the new password) 2. Display the database (after logging into the database) show databases;

3. Use database using database name 4.select command 1). Displays the database that is currently connected select databases ();  2). Displays the current server version select version ();    3). Show Current Time Select Now ();   4). Use database Select Database name 5. Operation database 1). Create DATABASE name 2). Delete the database name of the drop databases database;

MySQL Basic operation