Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
Description
I had deleted all databases from mysql. Some problem have arisen. I can't access mysql properly. I had created a mysql database manually.
~ mysql -u root ✔ 9s
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 8
|
Server version: 10.6.3-MariaDB Arch Linux
|
|
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 |
|
+--------------------+
|
2 rows in set (0.001 sec)
|
|
MariaDB [(none)]> use databases;
|
ERROR 1049 (42000): Unknown database 'databases'
|
MariaDB [(none)]> use mysql;
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
Database changed
|
MariaDB [mysql]> show tables;
|
+-----------------+
|
| Tables_in_mysql |
|
+-----------------+
|
| general_log |
|
+-----------------+
|
1 row in set (0.000 sec)
|
I am using --skip-grant-tables. I had deleted MariaDB multiple times. I had deleted from Add/Remove Software also. But, whenever I install again I just get what I had earlier. Everything isn't removing properly. Or, I can't reinstall everything properly. I wanted to hard remove MariaDB. But, I can't find any other way to remove. I usually use pacman -R.
You can find further information here : https://forum.manjaro.org/t/unable-to-access-mysql/77490