This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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.
