MYSQL/PHPMYADMIN - Problem with functions

[Deireadh]

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

[Deireadh]

Nobody has a problem with phpmyadmin after installing VESTACP?

[Deireadh]

Already I solved this problem.

[xandehenrique]

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

[Deireadh]

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).

[Aliraza521]

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

[Deireadh]

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.

[tjebbeke]

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

[skurudo]

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