MySQL isn't internally strict with the empty root password; auth socket
is enabled by packaging to make it more secure by default, not by the
server itself, so just running ALTER USER 'root'@'localhost' IDENTIFIED
WITH 'mysql_native_password' BY ''; will work
--
You received this bug notification
There is a solution to fix this here:
https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/
After setting the password using mysql_native_password, you can set it
to be empty again.
--
You received this bug notification because you are a member of Ubu
On Wed, Apr 20, 2016 at 04:49:09PM -, Dario Bertini wrote:
> My solution is to simply not use 5.7, and manually install mysql-
> server-5.6...
Note that Xenial will ship MySQL 5.7 only. 5.6 will be removed shortly.
--
You received this bug notification because you are a member of Ubuntu
Bugs
Hi,
What you need is:
ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY
'somepass';
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1571668
Title:
Mysql upgrade locks out its
For those who are wondering:
My solution is to simply not use 5.7, and manually install mysql-
server-5.6 (after all, the application that I'm working on still needs a
bunch of changes to be able to work with 5.7's new stricter defaults)
--
You received this bug notification because you are a me
Ok, at the very least this needs some documentation though. Since
neither Mysql's own documentation nor Ubuntu's community wiki have any
working solution.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/
So the original bug report is behaviour by design, so I'll mark this
Won't Fix. If there's an issue with setting the root password afterwards
though, then we can reopen this bug and change the title to track that,
or file another one or something.
** Changed in: mysql-5.7 (Ubuntu)
Status: N
> I did already attempt the dpkg-reconfigure, but that's not useful (You
can select the password only when creating a new datadir with empty
config, and thus a dpkg-reconfigure does not suffice).
I thought this is supposed to work, but perhaps I'm mistaken.
> ALTER USER 'root'@'localhost' IDENTIF
Thank you, indeed I had the suspicion that some kind of local socket
authentication might've been disabled, instead of changing the password.
> I think it's something else - please see below. Based on this, you
should be able to change the root password to something non-empty with
"sudo dpkg-recon
I was going to add this to NEWS.Debian but missed it in my last upload -
sorry.
> The problem is the new feature of mysql-server that generates a
temporary password.
I think it's something else - please see below. Based on this, you
should be able to change the root password to something non-empt
I just realized that not even the
mysqld_safe --skip-grant-tables --skip-networking
solution will work, since after logging in
ALTER USER 'root'@'localhost' IDENTIFIED BY '';
will fail with
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
(the same applies for the old command: `SET PAS
11 matches
Mail list logo
