Public bug reported:
I have installed percona-xtradb-cluster-server-5.6 on my Xenial server
and try to set the root password with mysqladmin:
# mysqladmin --user=root --password='' password 'secure'
mysqladmin: [Warning] Using a password on the command line interface can be
insecure.
Warning: Since password will be sent to server in plain text, use ssl
connection to ensure password safety.
mysqladmin: unable to change password; error: 'You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near '() IDENTIFIED BY 'secure'' at line 1'
So it looks the version 5.7 of mysqladmin is not compatible with version
5.6 any more, but mysql-client-5.6 package has also been dropped from
Xenial shortly before release.
# apt policy mysql-client
mysql-client:
Installed: 5.7.11-0ubuntu6
Candidate: 5.7.11-0ubuntu6
# apt policy mysql-client-5.6
mysql-client-5.6:
Installed: (none)
Candidate: (none)
# apt policy percona-xtradb-cluster-server-5.6
percona-xtradb-cluster-server-5.6:
Installed: 5.6.21-25.8-0ubuntu3
Candidate: 5.6.21-25.8-0ubuntu3
The same command still worked on Xenial Beta with mysql-client-5.6
available.
** Affects: percona-xtradb-cluster-5.6 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1574509
Title:
mysqladmin-5.7 fails to set password for percona-xtradb-cluster-
server-5.6
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.6/+bug/1574509/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
