I don't know whether this is the right Stack Exchange Q+A for this...
I just installed MariaDB in Linux Mint Cinnamon (18.1).
mysql --version gives:
mysql Ver 15.1 Distrib 10.0.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
During this installation, using these commands
sudo apt-get update sudo apt-get install mariadb-server mariadb-client
... I was not asked for a root password.
Going here I found a recipe to set the password:
sudo -s service mysqld stop mysqld_safe ‐‐skip-grant-tables & mysql -u root
use mysql; update user set password=PASSWORD("root") where User='root'; flush privileges;
... things depart from the script at line
Database changed MariaDB [mysql]> update user set password=PASSWORD( "root" ) where User='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.00 sec)
i.e. "0 rows affected" and "Changed: 0". And when I then run a
SELECT query on the
users table I see that the default password "*81F5E21E35... E1B" has not changed.
Any idea what's going wrong?