mysql databases
Posted: Thu Feb 06, 2020 11:32 am
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