You are not logged in.

#1 2021-04-04 12:04:07

Rarou
Member
Registered: 2021-04-04
Posts: 6

MariaDB Root PWD

Good day lads,

Trying to reset mysql root pwd without any luck. I tried every guide via search and still nothing.

Any idea ?

Screenshot-2021-04-04-15-02-49.png

Offline

#2 2021-04-04 12:33:47

rbh
Member
From: Sweden/Vasterbotten/Rusfors
Registered: 2016-08-11
Posts: 973

Re: MariaDB Root PWD


// Regards rbh

Offline

#3 2021-04-04 12:41:15

Rarou
Member
Registered: 2021-04-04
Posts: 6

Re: MariaDB Root PWD

Good day @rbh.

This guide is not working for me as in the Step #3 ( Login in to the mysql shell ) im getting the already above error.

Last edited by Rarou (2021-04-04 12:41:35)

Offline

#4 2021-04-04 13:00:29

rbh
Member
From: Sweden/Vasterbotten/Rusfors
Registered: 2016-08-11
Posts: 973

Re: MariaDB Root PWD

Rarou wrote:

This guide is not working for me as in the Step #3 ( Login in to the mysql shell ) im getting the already above error.

Worked for me, with MariaDB 10.3.27. What is the output of

mysql --version

Have you checked status after each step?


// Regards rbh

Offline

#5 2021-04-04 13:02:42

Rarou
Member
Registered: 2021-04-04
Posts: 6

Re: MariaDB Root PWD

I messed up somewhere at secure installation with the password.

Output of --version is:

mysql  Ver 15.1 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Offline

#6 2021-04-04 13:45:01

rbh
Member
From: Sweden/Vasterbotten/Rusfors
Registered: 2016-08-11
Posts: 973

Re: MariaDB Root PWD

Rarou wrote:

I messed up somewhere at secure installation with the password.

Ok, it is a new installation with new password setup before you issued

mysql_secure_installation

and messed up with the password? Maybe messed upp something more..

You do not have any database to take care of? Why not then purge the installation and reinstall?

Last edited by rbh (2021-04-04 13:46:05)


// Regards rbh

Offline

#7 2021-04-04 14:20:43

Rarou
Member
Registered: 2021-04-04
Posts: 6

Re: MariaDB Root PWD

New error after purge and reinstall of mysql and phpmyadmin.

php.png

Trying to find solutions and i will reply.

Offline

#8 2021-04-04 14:54:06

Rarou
Member
Registered: 2021-04-04
Posts: 6

Re: MariaDB Root PWD

Unfortunately i can not find solution to this.

Tried to reinstall php-mysql with

sudo apt-get install --reinstall php-mysql

and everything are ok.

php7.3-mysql/stable,stable,now 7.3.27-1~deb10u1 amd64 [installed] after

sudo apt list --installed | grep php

Trying to edit php.ini but i can not find mysqli.so extension anywhere.

Offline

#9 2021-04-04 16:38:16

rbh
Member
From: Sweden/Vasterbotten/Rusfors
Registered: 2016-08-11
Posts: 973

Re: MariaDB Root PWD

Rarou wrote:

Unfortunately i can not find solution to this.
Tried to reinstall php-mysql with

sudo apt-get install --reinstall php-mysql

and everything are ok.

php7.3-mysql/stable,stable,now 7.3.27-1~deb10u1 amd64 [installed] after

sudo apt list --installed | grep php

Trying to edit php.ini but i can not find mysqli.so extension anywhere.

So, you have reinstalled php-mysql, but the installation has failed as you are missing file mysqli.so? Or are you not sure if it is missing? You have not searched with file utils like locate?
Mine is located at /usr/lib/php/20180731/mysqli.so

I don't know what you are doing.. Have you installed lamp before?
You give so little information about your doing...

The original fault: password for mysql-user root, did you solve that with purging/installing?


// Regards rbh

Offline

#10 2021-04-04 17:01:23

Rarou
Member
Registered: 2021-04-04
Posts: 6

Re: MariaDB Root PWD

@rbh thank you for your reply.

The original error (password for mysql root) is fixed by reinstalling mysql and phpmyadmin.

After reinstall both of service im getting the above error in localhost/phpmyadmin.

I edit my php.ini which is located at /etch/php/7.3/apache2/php.ini and uncomment the line extension=mysqli.so with the correct path of mysqli.so. I restarted the apache2 and mysql but the error is still there.

As for your question no i've never installed LAMP before.

Offline

#11 2021-04-04 18:32:23

rbh
Member
From: Sweden/Vasterbotten/Rusfors
Registered: 2016-08-11
Posts: 973

Re: MariaDB Root PWD

If you newer installed lamp before, you have a lot of reading and working ahead.

Rarou wrote:

and uncomment the line extension=mysqli.so with the correct path of mysqli.so.

You did have file /usr/lib/php/20180731/mysqli.so, but could not find it, until I gave you the path? Install mlocate or the faster plocate, to crete an index of files, which gives you good tool to quick find files in your filessystem.

I think, and your errors, indicate that file mysqli.so, is essential.

During the years working with linux, I have learned that sometimes you have to reinstall from scratch. It is not allways easy to find out why a specific error occour.

When exploring LAMP. I would advise you t use a non-productive machine (vm or physical), that you start all over without hampering all other work.


// Regards rbh

Offline

Board footer

Powered by FluxBB