Not able to connect mysql

kingerdeepti123 · June 25, 2020, 8:51am

getting error
code: ‘ER_ACCESS_DENIED_ERROR’,
errno: 1045,
sqlState: ‘28000’,
sqlMessage:
“Access denied for user ‘socialusercb’@‘localhost’ (using password: NO)” } }

This is my readme.md file
mysql -u root -p
create database cbsocialmediadb;
create user socialusercb identified with mysql_native_password by ‘socialpasscb’;
grant all privileges on cbsocialmediadb.* to socialusercb;
flush privileges;
grant all privileges on cbsocialmediadb.* to ‘socialusercb’@’%’;
flush privileges;

Darsh-Pratap-325457197922299 · June 25, 2020, 9:12am

@kingerdeepti123 do two things, first send me the screen shot of the code you are using for connecting to mysql server, and second to follow these steps to set up your database

github.com

coding-blocks-archives/WebNodeLive2017Winter/blob/master/Webinar14/SequelizeExpressShoppingApp/PREPARE_DB.md

# Preparing the Database

Do the following as root

```sql
 create database shopdb;
 create user shopper identified by 'shoppass';
 use shopdb;
 grant all privileges on shopdb to shopper;
 grant all privileges on shopdb.* to shopper;
```

Darsh-Pratap-325457197922299 · July 3, 2020, 3:08pm

I hope I’ve cleared your doubt. I ask you to please rate your experience here
Your feedback is very important. It helps us improve our platform and hence provide you
the learning experience you deserve.

On the off chance, you still have some questions or not find the answers satisfactory, you may reopen
the doubt.