![]() Sudo su cd /opt/bitnami/apps/phpmyadmin/htdocs cp Find the configuration file and take a backup.SSH to the LAMP stack with user bitnami.The configuration file is located at /opt/bitnami/apps/phpmyadmin/htdocs/įollowing is the steps that I took in my own lab environment to update the configuration file: You will need to update phpmyadmin configuration file in the LAMP stack, so it can point to lightsail database instead of localhost. ![]() How to update phpmyadmin to be able to connect to my dedicate lightsail database? The point here is that phpmyadmin pre-installed in the LAMP stack is connecting to the local mysql database inside the same OS.Īs for the lightsail database instance, it's actually a separate database instance outside the LAMP stack, and to access it via phpmyadmin from the LAMP instance, you will need to make a few configuration changes in phpmyadmin.ī. Also, the stack is pre-installed with phpmyadmin, to allow users to manage the local database via GUI. ![]() In your account, you have a lightsail LAMP instance "XXX", which is a complete application stack imaged by Bitnami, the stack contains these main components: Apache, php-fpm, mysql. Why phpmyadmin does not display database content in my lightsail database? I am sharing it here to help others who may encounter similar issue.Ī. I paid for Developer support, and AWS was able to solve my problem. If there's something that you're concerned about please do post here and we'll do our best to find out/clarify for you. I hope the above has provided some insight on the matter. Please refer below links to learn more about Granting User level access in mysql. > In order to achieve your use-case, what I can suggest you is 'check for the mysql-user 'dbmasteruser' privileges as I believe that it doesn't have required admin-permission to view the DB/tables of 'root' user. Regarding your concern about the 'dbmasteruser' user i.e you are not able to view any DBs created/imported by the root user from 'dbmasteruser'. Thank you for showing your interest in AWS Forums.Īs you mentioned that you are able to use/login phpmyadmin (from as a root via SSH tunneling which means everything is working fine as expected from AWS Infrastructure end. In the meantime, if anyone can help, I would appreciate it. Without help, I will kill my Lightsail instance and go with a different vendor who is more responsive. I would hope Amazon staff would look in on these occasionally. Wow, I guess these forums are mostly read, without many replies. How can I achieve both phpmyadmin AND mysql both seeing all the databases I create? On my previous webhost, they configured it and it worked fine - I never had to log into phpmyadmin as root. ![]() So I tried logging in to phpmyadmin as dbmasteruser (to create the DBs again), to no avail. But I don't want to do that - I want to connect as "dbmasteruser" as the Lightsail console tells me to.Ĭonnecting as dbmasteruser works OK too, but I have no visibility to DBs created as "root" in phpmyadmin. (Perhaps by design?) So any DBs that I import can be seen by my web php code as long as I connect to mysql as root. I set up the instance no problem, I have phpmyadmin access thru an SSH tunnel - no problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |