User Tools

no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


—unix_socket [2021/09/21 05:41] (current) – created norman
Line 1: Line 1:
 +====== Plugin 'unix_socket' is not loaded  ======
  
 +The "unix_socket" has been called by mysql authentication process (maybe related to a partial migration of database to mariadb, now removed). To get all stuff back working go su:
 +
 +
 +then follow:
 +
 +<code>/etc/init.d/mysql stop
 +mysqld_safe --skip-grant-tables &
 +mysql -uroot</code>
 +This will completely stop mysql, bypass user authentication (no password needed) and connect to mysql with user "root".
 +
 +Now, in mysql console, go using mysql administrative db:
 +
 +<code>use mysql;</code>
 +To reset root password to mynewpassword (change it at your wish), just to be sure of it:
 +
 +<code>update user set password=PASSWORD("mynewpassword") where User='root';</code>
 +And this one will overwrite authentication method, remove the unix_socket request (and everything else), restoring a normal and working password method:
 +
 +<code>update user set plugin="mysql_native_password";</code>
 +Exit mysql console:
 +
 +<code>quit;</code>
 +Stop and start everything related to mysql:
 +
 +<code>/etc/init.d/mysql stop
 +kill -9 $(pgrep mysql)
 +/etc/init.d/mysql start</code>
 +
 +
 +
 +
 +That's it.