1045-Access denied for user 'root'@'localhost' (using password: NO) (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

Question

I am working with laravel 7 and after clone my existing repo which was created via windows operating system and right now i am using macOS. After cloning I copy .env.example and converted into .env file and then run the below commands,

composer install
npm install && npm run dev
php artisan key:generate

All of the above commands run perfectly and then i run the 4 number commands to seed the database.

php artisan migrate:fresh --seed

After run the php artisan migrate:fresh --seed, I have faced an error [1045] Access denied for user 'root'@'localhost' (using password: NO) (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

Then I checked the php version and it showed php version: 8 and that's why I downgrade the php version from version 8 to 7.4 and right now the requires version are given below,

PHP Version: 7.4.30
Composer Version: 2.4.1

then I clone again and run the same commands 1,2,3 and 4 but iot's sorrow that I have faced same error again. Please check the attached file and check the error and help me to solve the error.

migrate related issues in laravel 71

score 2 · Answer 1 · answered Sep 12 '22 at 06:15

2

That indicates a problem with your database connection. Your Laravel application is not able to connect to the MySQL database. Check that mysql is running and that you have the correct database name, port, user, and password for your mysql client, or try connecting to mysql outside of the application.

Once you have completed the preceding steps and are able to connect to MySQL from outside of the application, you can run:

php artisan optimize:clear
php artisan cache:clear
php artisan config:cache
php artisan migrate:fresh --seed

answered Sep 12 '22 at 06:15

Hari Upreti

71
3

Already I did it @HariUpreti – Imdadul Haque Sep 12 '22 at 06:22
1

Are you able to connect with MySql outside from laravel application ? – Hari Upreti Sep 12 '22 at 06:27
Yea, but i don't know why I didn't solve this issue and that's why I am uninstalling and want re install it – Imdadul Haque Sep 12 '22 at 06:29
Are you using MAMP on mac ? try adding root as your db password once Ex: DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=databaseName DB_USERNAME=root DB_PASSWORD=root – Hari Upreti Sep 12 '22 at 06:35
No, I am using XAMPP.. – Imdadul Haque Sep 12 '22 at 06:36
1

Does your XMPP show mysql is running or it shows some issue while running MySql ? It is for sure that you are having issue with mysql connection. – Hari Upreti Sep 12 '22 at 06:41
Thanks for your response. I solved these issues reinstalling XAMPP. – Imdadul Haque Sep 12 '22 at 09:53

Wasib Hussain · Answer 2 · 2023-01-30T05:44:58.977

0

There maybe 2 problems with your database connection.

Try to write correct database username and password at your .env file, in case you have created manually,

OR

If you are working on existing database, then try to create new user for your my sql database, Open your mysql database go to privileges, add new user for your database and set password, then rewrite the username and password at .env file.

edited Jan 30 '23 at 05:44

answered Jan 30 '23 at 05:28

Wasib Hussain

166
1
8

1045-Access denied for user 'root'@'localhost' (using password: NO) (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

2 Answers2