How To Install Phpmyadmin On Kali linux with MariaDB | Mysql Error 1045 FIX

7
29



******** 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

7 COMMENTS

  1. mine says Unable to locate package MariaDB-server
    UPDATE: after following your instructions, I am still getting this error.
    The mysqli extension is missing. Please check your PHP configuration. See [a@doc/html/faq.html#faqmysql@documentation]our documentation for more information.

LEAVE A REPLY

Please enter your comment!
Please enter your name here