Amazon Lightsail Bitnami user mysql access denied at the time of new use creation

user_9689610 0
Viewed 1350

I have created Amazon Lightsail instance. And started a fresh wordpress site, now i connected phpmyadmin vie putty .ppk file its connected successfully with user bn_wordpress but if i want to create new database in this user it shows:

**

Access Denied for user bn_wordpress@localhost to database NEW_CREATED_DB

**

I just want to know how can i proceed to create new password. I am new to AWS Lightsail. Please provide answers.

amazon-lightsail bitnami
2 Answers

The bn_wordpress user doesn't have privileges to create databases. In this case, you will need to use the "root" user and the credentials we configure during the boot process to access phpMyAdmin and create that new database you want to create.

I hope this helps.

user_47096250

Complete setup was correct: 1. Download .pem file from lightsail instance 2. Convert it into .ppk extension vie puutygen 3. Connect 127.0.0.1 vie putty software and ppk key. 4. Access phpmyadmin vie http://127.0.0.1:8888/phpmyadmin/index.php 5. Login successfully with root credentials.

Thanks.

user_96896100
Related