Issue persists for 10.1.23. The test cases and failures are the same as
originally described in this thread.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1561062
Title:
Password not required for my
This bug was fixed in the package mariadb-10.0 - 10.0.24-7
---
mariadb-10.0 (10.0.24-7) unstable; urgency=low
* Temporarily remove mariadb-plugin-cassandra as Debian FTP bot thinks
it wasn't there before 10.0.24-6 and put the package in the NEW queue.
-- Otto Kekäläinen Wed,
..but test suite part is still unfixed, should eventually be fixed in
the name of quality assurance.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1561062
Title:
Password not required for mysql root
I just realized I already fixed this in a separate branch way back, but
didn't push it forward due to regressions somewhere:
https://github.com/ottok/mariadb-10.0/commits/fix-extra-root-accounts-
break-tokudb-tests
--
You received this bug notification because you are a member of Ubuntu
Bugs, whi
This has been fixed for new installs in
https://github.com/ottok/mariadb-10.0/commit/0d01b853faade85e67cb7ec6f04a9d2556f9b501
To automatically fix old installs (manipulate the mysql database user
table) additional engineering is needed.
Development PPA is at
https://launchpad.net/~mysql-ubuntu/+a
The attachment "lp-1561062-passwordless-roots.patch" seems to be a
debdiff. The ubuntu-sponsors team has been subscribed to the bug report
so that they can review and hopefully sponsor the debdiff. If the
attachment isn't a patch, please remove the "patch" flag from the
attachment, remove the "pa
There is no password set due to use of unix_socket authentication.
I've attached a patch that removes the extra passwordless accounts, but
the test suite requires those credentials to run, so the attached patch
is not enough to fully solve this, but only a first step until somebody
figures out the
I've found a sneaky workaround so the IP-address matches work:
cat /etc/mysql/mariadb.conf.d/51-disable-reverse-dns.cnf
[mysqld]
skip-name-resolve
# su tj
$ mysql --protocol=TCP -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
I forgot to add that what makes this worse is connecting directly using
--host 127.0.0.1 (or if server is bound to IPv6 --host ::1) the same
error occurs. The mysql.user entries for root@127.0.0.1 and root@::1 are
never reached due to the reverse name lookup.
I tried to get around that one by edit
The issue here is that after running mysql_secure_installation which
sets a root password the user cannot log-in with the DB's root account
unless they're also root or sudo on the OS itself.
$ mysql --protocol=TCP --host localhost -u root -p
ERROR 1698 (28000): Access denied for user 'root'@'local
** Changed in: mariadb-10.0 (Ubuntu)
Status: New => Triaged
** Changed in: mariadb-10.0 (Ubuntu)
Importance: Undecided => High
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1561062
Title:
Hopefully Otto can comment, but i've got a few quick questions:
- I don't think the password is ever actually required to start the shell --
just to connect to databases
- The authentication and authorization of mysql/mariadb is complicated, it's
easy to have multiple accounts with same username
** Information type changed from Private Security to Public Security
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1561062
Title:
Password not required for mysql root user (MariaDB) even when set
T
13 matches
Mail list logo
