Debian Question posted in
The oficial documentation can be found here.

What does "mysql -uroot" mean? – Debian

I am very new to MySQL Maria DB which is installed on a Debian 10 system
I am following a set of instructions on setup of Froxlor Control Panel on a VPS and have run into a problem.
I got the following error:

Checking MySQL-root access...   SQLSTATE[HY000] [1524] Plugin 'My company' is not loaded

When I go into my server and type mysql -uroot I got the following message from the system:

ERROR 1524 (HY000): Plugin 'My company' is not loaded

What does mysql -uroot actually do and what does this error tell me ?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I used this document to solve my problem:


  2. 0

    To answer the question:

    mysql -uroot

    Is the same as:

    mysql -u root

    Which is the shorthand for:

    mysql --user root

    Which starts up the mysql command line tool and logs in as ‘root’ mysql user.

    Regarding the error you’re getting, it appears to be underlying customizations of your mysql server instance, you should check with your hosting provider, as in a normal vanilla instance that wouldn’t appear.

    In a normal instance, you would see a prompt like that:

    # mysql -uroot
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 41
Server version: 10.3.29-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

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)]>

    And you would be able to issue SQL instructions on that prompt.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search