For me everything works as usually but maybe I'm doing something wrong. And I only tested command line usage on same device - LibreELEC (official): 9.2.0 (Generic.x86_64) on VMware Workstaton 12.
So tell me what I'm doing wrong so I can fix it.
![]()
LibreELEC:~ # mysql -uroot -pAq4gXPhl
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.3.14-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.001 sec)
MariaDB [(none)]> SELECT User FROM mysql.user;
+------+
| User |
+------+
| kodi |
| root |
| root |
| |
| root |
| |
| kodi |
| root |
+------+
8 rows in set (0.000 sec)
MariaDB [(none)]> Bye
LibreELEC:~ #
LibreELEC:~ # mysql -ukodi -pjg7PtiU6
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.3.14-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.000 sec)
MariaDB [(none)]> SELECT User FROM mysql.user;
+------+
| User |
+------+
| kodi |
| root |
| root |
| |
| root |
| |
| kodi |
| root |
+------+
8 rows in set (0.000 sec)
MariaDB [(none)]> select * from episode_view;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> Bye
LibreELEC:~ #
Display More
![]()
LibreELEC:~ # mysql -ukodi -pjg7PtiU6
ERROR 1045 (28000): Access denied for user 'kodi'@'localhost' (using password: YES)
LibreELEC:~ # mysql -ukodi -ptest2
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.3.14-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.001 sec)
MariaDB [(none)]> Bye
LibreELEC:~ # mysql -uroot -pAq4gXPhl
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
LibreELEC:~ # mysql -uroot -ptest1
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.3.14-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.000 sec)
MariaDB [(none)]> Bye
LibreELEC:~ #
Display More