[SOLVED] Mariadb root password

Janvanl · 05-18-2022, 09:41 AM

Hi,
using ubuntu 20.04 with mariadb 10.3

i wanted to run automysqlbackup which gave me an access error.

I wanted to give access for the root user to the databases but that gave the same access error.

Then i gave:
GRANT ALL PRIVILEGES ON *.* TO 'root'@localhost IDENTIFIED BY 'root';

After that i cannot login to mysql as root.

I know how to regain access to mariadb as root but my question is what did i do wrong?

Regards,
Jan

yancek · 05-18-2022, 11:16 AM

Did you use mysql_secure_installation when you first set up the server? If so, you should have had to set a mysql root password which is not the same as the OS passwords so that would mean there would be no reason to give root permission to the database, at least in my limited experience.

Quote:

After that i cannot login to mysql as root.

Mysql root user or the system root user?

What was that original message you refer to that got you into this trouble?

sundialsvcs · 05-18-2022, 11:54 AM

You neglect to give us the exact text of that "access error."

Janvanl · 05-18-2022, 11:56 AM

Hi Yancek,

i could log into mysql before this command.

Of course it is not the system root password.

when i started automysqlbackup manually i got:

error 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I need to get automysqlbackup running on the server, i had /etc/default/automysqlbackup.cnf
changed but still got the eror that is why i wanted to grant all privileges to root for all databases.

Regards,
Jan

Janvanl · 05-18-2022, 02:57 PM

Hi ifound this:

https://www.linuxquestions.org/quest...ng-4175602071/

i will do that this night.

Regards,
Jan

yancek · 05-18-2022, 06:17 PM

Quote:

Of course it is not the system root password.

Not of course, you would be surprised at the number of users who post here and other forums who are not aware of that. THere is no way of knowing a members knowledge/experience unless s/he tells us.

Janvanl · 05-19-2022, 02:37 AM

Hi,

i know, as a longtime linux-user since 1997 i know my way around.

I still have the problem that automysqlbackup tells me that that root cannot access the databases
because root cannot login to Mariadb.

Regards,
Jan