phpmyadmin Question posted in
The official documentation can be found here.

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

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.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    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.


  2. 0

    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.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search