Comments - impossible to set root user
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
To be honest I don't remember all the steps. But how can I grant all privileges to "root"? Because it seems that this is the necessary condition to have mariadb working, isn't it?
MariaDB usually comes with a root user with all privileges, so this has somehow been revoked. I can't help with your question unless you answer the other two parts of my response. Which version are you running, and are there other users with privileges?
Sorry, until tomorrow I can't give you a specific answer to what version I have on that PC. I know I have installed with KDE-Neon, and it seems to be a 10 release. No other users. I have only set
sudo mysql_secure_installation.
If these info are still too poor, please wait until tomorrow afternoon. Thank you!
Here you are:
mariadb Ver 15.1 Distrib 10.3.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
In 10.3, the mysql.user table can be updated directly with something like the following:
1) Start the server
--skip-grant-tables
.2) Connect and run the following SQL:
3) Run
FLUSH PRIVILEGES
4) Exit, and start the server normally
The above will not work from MariaDB 10.4, which introduced the mysql.global_priv table.