Mailinglist Archive: opensuse-factory (649 mails)

< Previous Next >
[opensuse-factory] MariaDB 10.1.25 openSUSE package - unable to set root password ..
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-set-root-password-tp5093379.html
Sent from the opensuse-factory mailing list archive at Nabble.com.
--
To unsubscribe, e-mail: opensuse-factory+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >
This Thread
Follow Ups