Page 1 of 1

mysql databases

Posted: Thu Feb 06, 2020 11:32 am
by systop
Hi Guys,
So, I am slightly confused here. I have setup Vesta CP on a fresh install of Ubuntu 18.04. I also installed Softaculous. The problem is that I used Softaculous to install phpmyadmin, (not realizing that you can set it up within Vesta CP) the problem though is that I can not get phpmyadmin to access any database but the admin_default database, regardless of the fact that I have set the privileges for the root@localhost for all databases to all. While I can login via the SSH terminal using

mysql -u root -p and if I show databases

mysql> show databases;
| Database |
| information_schema |
| admin_default |
| mysql |
| performance_schema |
| phpmyadmin |
| roundcube |
| sys |
7 rows in set (0.00 sec)

However, no matter what I do, I can only get phpmyadmin to login to admin_default db, but I can't log in with root to access all the databases. I am guessing this is a configuration issue, however, and this is no offense to anyone who wrote Vesta CP, or the docs, but I find the documentation very lacking in details, of course it's all possible, I am looking in the wrong place for the docs, but from the "docs" link, none of the documents really help me understand how to set things up.

Im guessing that Vesta was design with someone with far more experience than I however, I have almost 2 decades as a systems admin, and I feel like it's my first day on the job trying to get everything working :( Out of all the Open Source Control Panels I looked at, Vesta CP is the more professional, and easy to use CP, but the setup just has me scratching my head.

If someone could please help me here, I would greatly appreciate it. To be honest, I am not 100% sure I even needed to install a Control Panel, bu I wanted to install Softaculous and have a Softaculous setup for each user, which I figured it would help me create users, and web server slices for each user, which would allow me to setup mini web hosting plans for my clients but I don't think I have all the pieces to do that.

If someone could please help me figure out how to get phpmyadmin working for all databases, I would appreciate it.



Re: mysql databases

Posted: Thu Feb 06, 2020 11:55 am
by systop
I figured out the problem...... Turns out that the /etc/phpmyadmin/config-db.php  which gets it''s populated from /etc/dbconfig-common/phpmyadmin.conf had some weird password in it. One that I did not set at any time either in the install of Vesta CP nor phpmyadmin. 

I was able to login to phpmyadmin with this weird password, I found that root was setup with Password "NO" and Login with No Password was turned off (as it should be), so Iogged into phpmyadmin, changed the password for root to what I wanted it to be, set the "GRANT" privilege for root to access ALL databases, and now I am able to login with no problem and access all 7 databases, and make what ever modifications I may need to!