MariaDB 10.1.25 openSUSE package - unable to set root password even with "skip-grant-tables" and "FLUSH PRIVILEGES;" --- Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 10.1.25-MariaDB openSUSE package Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use mysql; Database changed MariaDB [mysql]> update user set password=PASSWORD("Andre@Verwijs1969") where User='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 3 Changed: 0 Warnings: 0 MariaDB [mysql]> SELECT User, Host, HEX(authentication_string) FROM mysql.user; +------+------------+-------------------------------------------+ | User | Host | HEX(authentication_string) | +------+------------+-------------------------------------------+ | root | localhost | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | linux-rd8q | | +------+------------+-------------------------------------------+ 5 rows in set (0.00 sec) root password authentication_string doesn't get updated within mysql database.... tips are welcome... ----- ____________________________________________________ Dank U.. Thank You.. My Twitter Page: http://twitter.com/OpenSimFan My Facebook page (be my friend, please ) http://www.facebook.com/andre.verwijs My Google+ page (follow me please ) André Verwijs - Google+ . -- View this message in context: http://opensuse.14.x6.nabble.com/MariaDB-10-1-25-openSUSE-package-unable-to-... Sent from the opensuse-factory mailing list archive at Nabble.com. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org