MariaDB Root PWD

Rarou · 2021-04-04 12:04:07

Good day lads,

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

Any idea ?

rbh · 2021-04-04 12:33:47

This guide works ok: https://linuxize.com/post/how-to-reset- … t-password

Rarou · 2021-04-04 12:41:15

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)

rbh · 2021-04-04 13:00:29

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?

Rarou · 2021-04-04 13:02:42

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

rbh · 2021-04-04 13:45:01

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)

Rarou · 2021-04-04 14:20:43

New error after purge and reinstall of mysql and phpmyadmin.

Trying to find solutions and i will reply.

Rarou · 2021-04-04 14:54:06

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.

rbh · 2021-04-04 16:38:16

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?

Rarou · 2021-04-04 17:01:23

@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.

rbh · 2021-04-04 18:32:23

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.

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

MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

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

Re: MariaDB Root PWD

Board footer