Posts

Showing posts from February 10, 2020

Mysql

Basically means that:  db_users using it, will be "auth" by  the system user credentias.  You can see if your  root  user is set up like this by doing the following: $ sudo mysql - u root # I had to use "sudo" since is new installation mysql > USE mysql ; mysql > SELECT User , Host , plugin FROM mysql . user ; + ------------------+-----------------------+ | User | plugin | + ------------------+-----------------------+ | root | auth_socket | | mysql . sys | mysql_native_password | | debian-sys-maint | mysql_native_password | + ------------------+-----------------------+ As you can see in the query, the  root  user is using the  auth_socket  plugin There are 2 ways to solve this: You can set the root user to use the  mysql_native_password  plugin You can create a new  db_user  with you  system_user  (recommended) Option 1: $ sudo mysql - u root # I had to use