MySQL How to set a password

MySQL How to set a password

The newly installed MySQL default is no password, below we direct root user to enter MySQL

There are many ways: 1. After you enter MySQL with root mysql>set password =password (' your password '); Mysql>flush privileges;2. Use the statement mysql> all on *. * to ' Root ' @ ' localhost ' identified ' your password ' with option; Mysql>flush privileges;3. Enter MySQL library to modify the user table Mysql>use Mysql;mysql >update user Set Password=password (' Your password ') where user= ' root '; Mysql>flush privileges;

Java Technology Exchange Group: 251303758

MySQL How to set a password