I am having trouble to install, and therefore connect, a phpmyadmin in a Ubuntu 18 droplet, to my managed mysql db cluster.
Somehow during phpmyadmin installation, through instructions given in this DO tutorial: https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04
I cannot finish installation. Its some trouble with mysql users
I have tried everything, also using command: dpkg-reconfigure phpmyadmin
It always fail because some error from mysql rejecting the user and password.
I am creating two new users under DO control panel, using instructions given in: https://www.digitalocean.com/docs/databases/mysql/how-to/modify-user-privileges/
Therefore I have created a new database for phpmyadmin, created one user with all privieleges and grant option (as superadmin for that database), and a second user with all privileges (as a user for that database), but always ends failing the installation.
Both users can access mysql through command line from ssh from the Ubuntu 18 droplet, which means I am missing something in the config file for phpmyadmin, but dont know what
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $100 of credit to try our products over 60 days!