Vesta Control Panel - Forum

Posted: **Wed Dec 09, 2015 5:21 pm**

Hi. I have a fresh installation of VESTACP and MYSQL... But I can not properly load the user configuration file ("The combination of user-defined control in the configuration file failed."). Many of the functions is OFF. The following screenshots:

http://prntscr.com/9c7d86
http://prntscr.com/9c7dl8

Debian 7 x64

Posted: **Thu Dec 10, 2015 4:45 pm**

Nobody has a problem with phpmyadmin after installing VESTACP?

Posted: **Sat Dec 12, 2015 5:35 pm**

Already I solved this problem.

Posted: **Mon Jan 04, 2016 9:05 pm**

Hello my friend can tell me how you can solve this problem?

Posted: **Mon Jan 04, 2016 11:51 pm**

xandehenrique wrote:Hello my friend can tell me how you can solve this problem?

1) Look at /usr/share/doc/phpmyadmin/examples

2) Copy file "config.sample.inc.php" mv ./config.sample.inc.php /etc/phpmyadmin/config.inc.php

3) Open phpMyAdmin in a browser and log in as root.

4) Create a database called phpmyadmin

5) Create a user called pma and set the "host" to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant the new user full control over the phpmyadmin database. It is recommended that this user does not have access to anything other than this database.

6) Go to the phpMyAdmin installation directory, where you should find a sub-directory called examples ( /usr/share/doc/phpmyadmin/examples ).

7) In examples you will find a file called create_tables.sql. Open it in a text editor.

8) In phpMyAdmin, select the phpmyadmin database and click on the "SQL" tab.

9) Copy/paste the entire text from create_tables.sql into the text box, and run the query.

10) Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines (or change the existing settings if they are already there):

Code: Select all

cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
cfg['Servers'][1]['controluser'] = 'pma';
cfg['Servers'][1]['controlpass'] = '<your password>';

cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark';
cfg['Servers'][1]['relation'] = 'pma_relation';
cfg['Servers'][1]['userconfig'] = 'pma_userconfig';
cfg['Servers'][1]['table_info'] = 'pma_table_info';
cfg['Servers'][1]['column_info'] = 'pma_column_info';
cfg['Servers'][1]['history'] = 'pma_history';
cfg['Servers'][1]['recent'] = 'pma_recent';
cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs';
cfg['Servers'][1]['tracking'] = 'pma_tracking';
cfg['Servers'][1]['table_coords'] = 'pma_table_coords';
cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages';
cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';

Save and close the file.

Log out of phpMyAdmin. Solved.

Another problem that I had (blowfish):

Edit file config.inc.php and add a blowfishcode

https://www.question-defense.com/tools/ ... -generator

You need to paste the generated code in the appropriate place.

(Guidance is not by me. I copy it from two places and I modified it slightly).

Posted: **Wed Jan 13, 2016 6:15 am**

But if I try to access to mysql with : "mysql -u root -p", I can connect to the database with the original root password.????

Ali

Posted: **Wed Jan 13, 2016 1:54 pm**

Aliraza521 wrote:But if I try to access to mysql with : "mysql -u root -p", I can connect to the database with the original root password.????

Ali

Do not log in the root of machine to mysql ... Log in VESTA ROOT and his password.

Posted: **Thu Jan 14, 2016 11:46 am**

Deireadh wrote:
Aliraza521 wrote:But if I try to access to mysql with : "mysql -u root -p", I can connect to the database with the original root password.????

Ali
Do not log in the root of machine to mysql ... Log in VESTA ROOT and his password.

You can find root password in /usr/local/vesta/conf/mysql.conf

Posted: **Fri Jan 15, 2016 8:15 pm**

Autofix for functions and controluser:
viewtopic.php?f=14&t=10307

Vesta Control Panel - Forum

MYSQL/PHPMYADMIN - Problem with functions

MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions

Re: MYSQL/PHPMYADMIN - Problem with functions