database connection error while connecting database in live server error 1045

Question

my .env file setup like this on the live server. but while I am

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=onlyaruv_notepad-apps
DB_USERNAME=onlyaruv_notepad
DB_PASSWORD=mypassword

the error was

SQLSTATE[28000] [1045] Access denied for user 'onlyaruv_notepad'@'127.0.0.1' (using password: YES) (SQL: select * from `users` where `email` = [email protected] limit 1)

I access my ssh via putty using this host and password http://5.100.156.10:2082 I am confused .

did try to run your mysql on visual database design tool like workbech or phpmyadmin — Gaurav Gupta
– Gaurav Gupta, Commented Jul 12, 2017 at 7:18
try to connect from putty Access remote database from command line. Disregard "remote", you can put your 127.0.0.1 — ljubadr
– ljubadr, Commented Oct 18, 2017 at 13:05
mysql -u onlyaruv_notepad -pmypassword -h 127.0.0.1 "onlyaruv_notepad-apps" Note that -p needs to be "glued" to your pass (no spaces) — ljubadr
– ljubadr, Commented Oct 18, 2017 at 13:08

Jigar · Accepted Answer · 2017-07-12 05:54:32Z

0

Have you given All privileges to onlyaruv_notepad this user? if you not please give all privileges to the user. still, The problem not solved check host is correct or not. (change DB_HOST=127.0.0.1 to DB_HOST=localhost

answered Jul 12, 2017 at 5:54

Jigar

3,2833 gold badges36 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jigar Over a year ago

@Sharifur Have you given All privileges to onlyaruv_notepad this user?

Sharifur Robin Over a year ago

yes, I do but still the same error what can I do for this?

Sharifur Robin Over a year ago

SQLSTATE[28000] [1045] Access denied for user 'onlyaruv_napps'@'127.0.0.1' (using password: YES) (SQL: select * from users where email = [email protected] limit 1)

Nazmul Hasan · Accepted Answer · 2017-07-12 07:41:30Z

0

Check your database connection carefully. If it does not work then Run the following artisan command and try again

php artisan config:clear
php artisan cache:clear
php artisan view:clear

answered Jul 12, 2017 at 7:41

Nazmul Hasan

1,99716 silver badges21 bronze badges

1 Comment

Sharifur Robin Over a year ago

did every thing whatever you say. but no result

Collectives™ on Stack Overflow

database connection error while connecting database in live server error 1045

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related