Ubuntu 15.04 is no more supported and fix has been released.
https://www.ubuntu.com/info/release-end-of-life
** Changed in: mariadb-10.0 (Ubuntu)
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ub
The version 10.0.23-1 uploaded to Debian and soon synced to Ubuntu has
now a reworked auth_socket configuration, where auth_socket is used by
default only on new installs and on upgrades the existing mysqld root
accounts are kept as-is.
Therefore marking 'fix committed'.
** Changed in: mariadb-10
Another change required having done the above is to alter
/etc/mysql/debian.cnf to have user = debian-sys-maint, instead of root,
with a new random password that's put into the existing row for that
user. Otherwise, /etc/cron.daily/logrotate generates an email because
it has problems rotating /va
Upgrade from 14.10 to 15.04 broke programs' access to MariaDB because
they were all expecting to give a username of root and the appropriate
password. To repair, I set user.plugin back to empty for user='root'
and *also* had to set user.password as the upgrade had cleared it.
It's not nice to
Workaround/fix:
http://www.versatilewebsolutions.com/blog/2015/05/dealing-with-mariadb-plugin-unixsocket-is-not-loaded.html
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447808
Title:
Access denied
Can you log in from command line with simply running 'sudo mysql' ?
Do that and create yourself your own MySQL/MariaDB user account, give it
the neeeded permissions and use it. For security reasons it is not
advised to use the root account all the time and in particular not
remotely.
--
You rece
The new MariaDB 10.0 do no longer require users to set a root password.
This is a security feature. You don't need root passwords (or debian-
maint-user passwords) simply to run and maintain your database anymore.
If you have root on the system you will get in as root to the database
(or using sudo
I think, this problem is because the root mysql account is now setup to
aunthenticate via unix_socket instead of a password:
https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/
So, you can enter to mysql as root user if you are logged in to the
system using the root unix user (or
I am not able to connect using python too
import MySQLdb
db = MySQLdb.connect("localhost","alok","alok","messages")
is giving error
OperationalError: (1698, "Access denied for user 'root'@'localhost'")
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subs
I am also facing the same problem after freshly installing mariadb in
Kubuntu 15.04. I am able to get mysql shell with root account but not
with my user account.
root@alok-PORTEGE-R30-A:~# mysql -u root -proot #is owrking
alok@alok-PORTEGE-R30-A:~$ mysql -u root -proot #not wokring
ERROR 1698 (28
I found that the root user are now set up to login using unix_socket
authentication plugin instead of a password, so one can login as root
when using sudo command:
sudo mysql -u root
Also, what I did to solve my problem was to create another user, with
log in via password and grant all permission
I can also verify that this is an issue. Except mine is a fresh install
of Ubuntu-Gnome 15.04.
I have also reset the password and flushed permission. I can only login
if skip-grant-tables flag is given.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subsc
Status changed to 'Confirmed' because the bug affects multiple users.
** Changed in: mariadb-10.0 (Ubuntu)
Status: New => Confirmed
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447808
Title:
13 matches
Mail list logo
