Note that this is the default setup when installing mysql on ubuntu after having run the secure installation script.įirst create a mysql user for your account 'valerie': mysql> CREATE USER IDENTIFIED WITH auth_socket Įnable administrative privileges for the account: mysql> GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION If you are able to do this then the auth_socket plugin is enabled and the root account is authenticating using this plugin. Logon to mysql from a terminal session: $sudo mysql Note that this does not work for root connections to the mysql server. If you've attempted some other method to fix the issue, you'll want to make sure the "plugin" field in er is set to "auth_token", which may require using mysqld_safe to log in to MySQL in the event you've been tinketing with things, like I did.Ĭredit to Miguel Nieto's blog post for this solution.Ĭreate an user account with appropriate administrative privileges that can connect via mysql workbench using the auth_socket plugin. Which will revert back to the native (old default) password authentication. Once logged in: ALTER USER IDENTIFIED WITH mysql_native_password BY 'password' You can do this by logging in to MySQL using socket authentication by doing: The solution is to revert back to native password authentication. I tried using "Local Socket/Pipe" to connect in a number of different ways but to no avail. This means that a non-root user can't log in as theįor whatever reason, the MySQL Workbench that came with 16.04 doesn't work out of the box with MySQL server, at least for me. Packaging now enables socket authentication when the MySQL root Password behaviour when the MySQL root password is empty has changed. This important caveat is documented in the 16.04 release notes:
Mysql workbench logo upgrade#
The issue is likely due to socket authentication being enabled for the root user by default when no password is set, during the upgrade to 16.04.
0 kommentar(er)
