******** How to Fix MySql Error 1045 : Acces denied ************
******** How to install phpmyadmin on *******************

all Linux based operating system
Fixing error 1045: Acces Denief on localhost using password(yes)

****************************************************

with this tutorial, you can setup phpmyadmin on any Linux system which has MariaDB installed.Some of you may also face error1045 access denied when trying to login to MySQL or install any services like WordPress, dvwa, bWAPP. with this installation method, you can also fix the issue of error 1045.

****************************************************
error 1045 fix:

• give root user full privileges.
• set a root password in MariaDB.
• Donot flush privileges when setting up a root password.

************************************************
*************instal mysql/mariadb*************i

$sudo apt update && apt upgrade
$sduo apt install dirmngr
$sudo apt update
$sudo apt install MariaDB-server
$sudo mysql -u root -p
[press enter if u not asked to enter any password during the installation ]

*************CREATE TEST USER & DATABASE*************
{in mariaDB }

CREATE DATABASE testdb;
CREATE USER ‘testuser’@’localhost’ IDENTIFIED BY ‘testpassword’;
GRANT ALL PRIVILEGES ON testdb.* TO testuser@localhost;
FLUSH PRIVILEGES;
quit

$sudo mysql -u testuser -p
[use password]

*************Set password on root account *************

$sudo mysql_secure_installation

*************install phpmyadmin ,php*************

$sudo apt -y install phpmyadmin php-mbstring php-gettext
[spacebar to select ,tab to switch, enter for confirm]

*************setup phpmyadmin with mysql*************

$sudo mysql -u root -p mysql

update user set plugin=” where user=’root’;
flush privileges;
exit

$sudo nano /etc/apache2/apache2.conf

(add this line at the bottom of apache2.conf)
Include /etc/phpmyadmin/apache.conf
[ctrl+x, Y, enter]

*************Restart services*************

$sudo service mysql restart
$sudo service apache2 restart
****************************************************

****************************************************
Music was provided by NCS

title of the track: Anikdote – Turn It Up [NCS Release]

track on NoCopyrightSounds:

Anikdote
•
•
•

Nguồn:https://danhnhan.vn/

https://danhnhan.vn/giai-tri