MySQL Database common operations

Environment variables

Create a new mysql_home system variable and set the value to (path) D:\Program Files\mysql\mysql Server 5.7

Edit the path system variable: In the system variable, find the path variable, click the "Edit" button, we will;%mysql_home%\bin added to the path variable (usually put on the last side), note that if there are other configurations, be sure to precede the English semicolon (half-width).

Basic operations

If we use root login, we have all the permissions, we first create a database or a new user, and then the database to the new user, to what new users can use what

log in to MySQL-----> mysql-u user name-p password

Modify password------>mysqladmin-u user name-p password Password new password

Create DATABASE----->create databases XXX character set UTF8;

Create a database user----->create user XXX identified by ' XXXXXX ';

Authorize the new user----->grant all on xxx.* to XXX;

sign in with a new user MySQL----->mysql-uxxx-pxxxxxx

MySQL Database common operations