MariaDB 10.4 Ubuntu 18.04 issue

G. G.

7/21/23, 5:01 PM

I installed with success MariaDB 10.4 in our ubuntu 18.04.

Root user created with success and another local user for controlling only one database.

Although I notice that with command in ssh:

service mysql status

Mar 21 17:49:11 fresco systemd[1]: Started MariaDB 10.4.24 database server.
Mar 21 17:49:11 fresco /etc/mysql/debian-start[10798]: Upgrading MySQL tables if necessary.
Mar 21 17:49:11 fresco mysqld[10757]: 2022-03-21 17:49:11 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Mar 21 17:49:11 fresco /etc/mysql/debian-start[10801]: Looking for 'mysql' as: /usr/bin/mysql
Mar 21 17:49:11 fresco /etc/mysql/debian-start[10801]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
Mar 21 17:49:11 fresco /etc/mysql/debian-start[10801]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Mar 21 17:49:11 fresco /etc/mysql/debian-start[10801]: FATAL ERROR: Upgrade failed
Mar 21 17:49:11 fresco /etc/mysql/debian-start[10807]: Checking for insecure root accounts.
Mar 21 17:49:11 fresco mysqld[10757]: 2022-03-21 17:49:11 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Mar 21 17:49:11 fresco mysqld[10757]: 2022-03-21 17:49:11 0 [Note] InnoDB: Buffer pool(s) load completed at 220321 17:49:11

Fresco is a local user also.

Why I get these errors in mysql for root?

It is not making sense as when I login in mysql with root everything seems fine, all permissions are granted.

Any help please because I am confused?

112

0 + 0

mysql

mariadb

ubuntu-18.04

djdomi

7/21/23, 5:52 PM

as stated, the user root seems to have on localhost an password set, which is not the default for mariadb on debian/Ubuntu

G. G.

7/21/23, 6:06 PM

@djdomi what you mean root is not default user? I didn't catch this

djdomi

7/22/23, 2:25 PM

you don't read correctly what I've written, root has by default not a password

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: MariaDB 10.4 Ubuntu 18.04 issue

TH: ปัญหา MariaDB 10.4 Ubuntu 18.04

RO: Problemă MariaDB 10.4 Ubuntu 18.04

RU: Проблема с MariaDB 10.4 Ubuntu 18.04

VI: Sự cố MariaDB 10.4 Ubuntu 18.04

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.