[MDEV-26449] Unable to access mysql Created: 2021-08-20  Updated: 2021-08-24  Resolved: 2021-08-24

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Istiak Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: 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



 Comments   
Comment by Sergei Golubchik [ 2021-08-24 ]

As far as I can see, there is no bug here.

If you want help, please see https://mariadb.org/contribute/ for the better media for asking question (e.g. Zulip or mailing lists).

Generated at Thu Feb 08 09:45:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.