Skip to content

Latest commit

 

History

History
18 lines (10 loc) · 471 Bytes

mysql.md

File metadata and controls

18 lines (10 loc) · 471 Bytes

Reset password

  1. sudo mysql

  2. use mysql

  3. SELECT user,authentication_string,plugin,host FROM mysql.user;

  4. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

  5. FLUSH PRIVILEGES;

Grant privileges

  1. mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
  2. mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;

note that default user with host = localhost cannot be granted to access with host = %