We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
mysql databases
mysql databases
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 Vestacp.com "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.
Thanks
Systop
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 Vestacp.com "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.
Thanks
Systop
Re: mysql databases
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!
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!