Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26449

Unable to access mysql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: OTHER
    • 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

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            Istiak Istiak
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration