Problem with php when installing vesta panel

@Zachary_DuBois - phpMyAdmin always has to be the one script that has the most complicated and well…over-complicated configuration setup. I really wish they’d revamp the project and slim things down. It’s configuration like this that makes it a nightmare :-).

@alexandrepjh

First, for simplicity, I would recommend Adminer over phpMyAdmin. It’s slimmer, a single file (over hundreds) and IMO, much faster while providing the same options. If you find that something isn’t there that you need, look at the available plugins.

All you need to do with Adminer is download the file, upload it to your web server and access it (i.e. there is no installation process). You’ll then enter in your hostname, database name and database password and click login. Simple and easy.

Of course, you do want to restrict access to this file and I would also rename it something obscure (i.e. not adminer.php) as scanners are run and that file name is commonly included in such scanners (which are run by hackers looking to break in to your DB).

Hello, thanks for the help, then I searched in all directories and not found the create_tables.sql file. I have no idea how to do this, I had already installed the OS and various vestacp before and never had this problem, but now all that I try to install OS have this problem.

So what it looks like is you never added a user/database for phpMyAdmin to use. When you install phpMyAdmin, there is a file in the directory sql called create_tables.sql. You want to create an empty database for phpMyAdmin. Then import that sql file using cat /path/to/create_tables.sql | mysql -u <mysql user> -p <database> or you can upload it through phpMyAdmin assuming you can login with a user that can create/edit databases.

After doing that, you’ll want to create a phpMyAdmin user in your database instance. Make sure to only give this user permissions on the phpMyAdmin database you created. After, edit your phpMyAdmin config.inc.php with the following:

$cfg['Servers'][$i]['pmadb'] = 'phpMyAdmin DB name';
$cfg['Servers'][$i]['controlhost'] = '<DB Hostname/IP>';
$cfg['Servers'][$i]['controlport'] = '3306';
$cfg['Servers'][$i]['controluser'] = '<phpMyAdmin User>';
$cfg['Servers'][$i]['controlpass'] = '<DB Password>';

And you should be good. @jtittle has a good find too so take a look at his answer. I am taking a look at that right now :)