Questions tagged [auth-socket]

Tag for questions related to MySQL's socket authentication plugin.

The auth_socket is MySQL's authentication plugin that authenticates clients that connect from the local host through the Unix socket file.

3 questions
174
votes
12 answers

MySQL fails on: mysql "ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded"

My local environment is: fresh Ubuntu 16.04 with PHP 7 with installed MySQL 5.7 sudo apt-get install mysql-common mysql-server When I tried to login to MySQL (via CLI): mysql -u root -p I came across an cyclic issue with 3 steps. 1) First was…
Tomas Votruba
  • 23,240
  • 9
  • 79
  • 115
1
vote
1 answer

Homebrew and mysql unix_socket

I have installed mysql on my Mac with homebrew brew install mysql I would like to login to mysql as a root with no password trough auth_socket plugin. The problem is that there is no auth_socket plugin in plugin_dir directory. I have tried to add in…
yieChug1
  • 85
  • 7
0
votes
1 answer

Connection to remote mysql server through ssh using python mysqldb connector passwordless

Python 3.8 Mysql 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) Hi, I want to connect to a distant mysql server using python's mysqldb connector and paramiko's sshtunnelforwarder. I can connect to the database remotely without any problems…
Antezo
  • 63
  • 2
  • 7