MySQL Basic settings

1.root Password

MySQL just installed, root account is no password, for security, we must set a password

Run command mysql-u Root

There are two ways to change the password, one is to update the database directly, the user's password and authorization information in the database MySQL table user. We can use the UPDATE statement to change the password. Like what:

Update user set Password=password ("Yourpwd") where user= ' root '

where password ("Youpwd") is to encrypt your password for storage.

After the SQL statement is executed, flush privileges and the settings take effect.

2.root access Rights settings

MySQL Basic settings