[SOLVED] Can't access MariaDB/MySQL from terminal, only via phpmyadmin

byjove01 · 2022-03-29 12:58:17

The problem fits in the title. I want to export my SQL database to a portable format which I could use with SQLite but phpmyadmin, because of a recent bug, prevents me to do so. So, I decide to bypass it by using "mysqldump" but I got this error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

... And this even happens with "mysql", "mariadb" or any SQL-related function. I tried to add my user and the root user in the http group, to execute "mysql" in any way I could imagine, but nothing would solve the issue.
However, as I said before, I can however use phpmyadmin with no problem at all, but it could be due to Apache using its own permissions or something else I don't know.

That's all the info I can give for now, if you need more, just ask. Thanks in advance.

Last edited by byjove01 (2022-03-31 09:52:35)

Slithery · 2022-03-29 13:23:09

Please post the full command you are trying to run.
You need to use the username/password from a relevant mysql account, this is different to any system user accounts. You will have set this up when first configuring the database server.

byjove01 · 2022-03-29 13:30:19

sudo mysqldump [databasename]

I finally succeed to access MariaDB just by putting the " -p [database name] " after my username. But I still can't dump anything, and "mysqldump" returns me that error.

Last edited by byjove01 (2022-03-29 13:31:13)

Slithery · 2022-03-29 13:48:53

First off you shouldn't be using sudo for this.
The correct structure for the command should be...

mysqldump -u <username> -p <databasename>

Where <username> is the name of a mysql user with the appropriate rights.
Again, this isn't the name of a normal user on your system. It's a user that you had to specifically set up for mysql/mariadb when you first configured it.

byjove01 · 2022-03-31 09:52:20

Thanks you, it worked. Problem solved.

Arch Linux

#1 2022-03-29 12:58:17

[SOLVED] Can't access MariaDB/MySQL from terminal, only via phpmyadmin

#2 2022-03-29 13:23:09

Re: [SOLVED] Can't access MariaDB/MySQL from terminal, only via phpmyadmin

#3 2022-03-29 13:30:19

Re: [SOLVED] Can't access MariaDB/MySQL from terminal, only via phpmyadmin

#4 2022-03-29 13:48:53

Re: [SOLVED] Can't access MariaDB/MySQL from terminal, only via phpmyadmin

#5 2022-03-31 09:52:20

Re: [SOLVED] Can't access MariaDB/MySQL from terminal, only via phpmyadmin

Board footer