Table of Contents

SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: YES) (SQL: select * from information_schema.tables where table_schema = jobbersconnect and table_name = migrations and table_type=”BASE TABLE”)

Comment

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=dbname DB_USERNAME=”xyz” DB_PASSWORD=”123″

Popularity
9/10 Helpfulness
2/10
Language
sql

Source: stackoverflow.com

Tags: sql

Link to this answer

Share

Cheerful Cheetah

Contributed on Feb 26 2020

Cheerful Cheetah

0 Answers Avg Quality 2/10

Closely Related Answers

SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’ (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type=”BASE TABLE”)

Comment

There is two reasons for this , wrong root password or no root password with this option disabled in the mysql settings , this is a workaround for the second issue : sudo mysql -u root -p Now you can alter root user password using the following cmd ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘password’ Remeber to change ‘password’ with your password and update it in the .env file of your application

Popularity
10/10 Helpfulness
5/10
Language
sql

Source: WorldLinkAnswers

Tags: access-denied
ac

Link to this answer

Share

egyleader

Contributed on Nov 25 2021

egyleader

0 Answers Avg Quality 2/10

SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: YES) (SQL: SHOW FULL TABLES WHERE table_type=”BASE TABLE”)

Comment

SQLSTATE[HY000] [1045] Access denied for user ‘(root)’@’localhost’ (using password: YES) (SQL: select * from information_schema.tables where table_schema = (first_project) and table_name = migrations and table_type=”BASE TABLE”)

Popularity
1/10 Helpfulness
1/10
Language
sql

Source: WorldLinkAnswers

Tags: access-denied
show
sql
where

Link to this answer

Share

Khaled Jelassi

Contributed on Feb 26 2022

Khaled Jelassi

0 Answers Avg Quality 2/10

wordlinkanswers

SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: YES) (SQL: select * from information_schema.tables where table_schema = jobbersconnect and table_name = migrations and table_type=”BASE TABLE”)

Closely Related Answers

SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’ (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type=”BASE TABLE”)

SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: YES) (SQL: SHOW FULL TABLES WHERE table_type=”BASE TABLE”)

Leave a Comment Cancel reply