mysqli::real_connect(): (hy000/1045): access denied for user 'root'@'localhost' (using password: yes)

Comment

4

#1- Explorer C:\xampp\phpMyAdmin\config.inc 

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'YourPassword';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

#2- change mysql password
> mysqladmin -u root password
Enter password
> mysql -u root -p
> enter password: 
> GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost'  IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
> FLUSH PRIVILEGES;

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: access-denied sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 04 2023

Snippets

0 Answers Avg Quality 2/10

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

Comment

11

In terminal, log into MySQL as root. You may have created a root password when you installed MySQL for the first time or the password could be blank, in which case you can just press ENTER when prompted for a password.

sudo mysql -p -u root

Now add a new MySQL user with the username of your choice. In this example we are calling it pmauser (for phpmyadmin user). Make sure to replace password_here with your own. You can generate a password here. The % symbol here tells MySQL to allow this user to log in from anywhere remotely. If you wanted heightened security, you could replace this with an IP address.

CREATE USER 'pmauser'@'%' IDENTIFIED BY 'password_here';

Now we will grant superuser privilege to our new user.

GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;

Then go to config.inc.php ( in ubuntu, /etc/phpmyadmin/config.inc.php )

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pmauser'; 
$cfg['Servers'][$i]['controlpass'] = 'password_here';

Popularity 10/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: access-denied ac

Share

Link to this answer
Share Copy Link

Contributed on Mar 03 2022

Delights JP

0 Answers Avg Quality 2/10

mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

Comment

0

ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: access-denied ac

Share

Link to this answer
Share Copy Link

Contributed on Jan 03 2021

Snippets

0 Answers Avg Quality 2/10

mysqli::real_connect(): (HY000/1045): Access denied for user 'phpma'@'localhost' (using password: YES)

Comment

1

https://stackoverflow.com/a/54176422

Popularity 10/10 Helpfulness 3/10 Language whatever

Source: stackoverflow.com

Tags: access-denied ac

Share

Link to this answer
Share Copy Link

Contributed on Mar 19 2023

Shadow

0 Answers Avg Quality 2/10

mysqli::real_connect(): (HY000/1045): Access denied for user 'diana '@'localhost' (using password: YES)

Comment

1

'root'@' localhost' BY 'mysql';

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: access-denied ac

Share

Link to this answer
Share Copy Link

Contributed on Mar 29 2022

Jittery Jaguar

0 Answers Avg Quality 2/10

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Comment

-1

$cfg['Servers'][$i]['port'] = '3307';

Popularity 10/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: php

Share

Link to this answer
Share Copy Link

Contributed on Mar 19 2020

Real Rat

0 Answers Avg Quality 2/10

uncaught mysqli_sql_exception: access denied for user 'root'@'localhost' (using password: no)

Comment

-1

Check that the root user is allowed to be used in phpmyadmin or if root user is allowed on your actual database.

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: access-denied ac

Share

Link to this answer
Share Copy Link

Contributed on Apr 27 2022

Adrian Vignolo

0 Answers Avg Quality 2/10

mysqli::real_connect(): (hy000/1045): access denied for user 'root'@'localhost' (using password: yes)

Contents

More Related Answers