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/PHPMYADMIN - Problem with functions
MYSQL/PHPMYADMIN - Problem with functions
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
http://prntscr.com/9c7d86
http://prntscr.com/9c7dl8
Debian 7 x64
Re: MYSQL/PHPMYADMIN - Problem with functions
Nobody has a problem with phpmyadmin after installing VESTACP?
Re: MYSQL/PHPMYADMIN - Problem with functions
Already I solved this problem.
-
- Posts: 26
- Joined: Mon Jan 04, 2016 3:09 pm
Re: MYSQL/PHPMYADMIN - Problem with functions
Hello my friend can tell me how you can solve this problem?
Re: MYSQL/PHPMYADMIN - Problem with functions
1) Look at /usr/share/doc/phpmyadmin/examplesxandehenrique wrote:Hello my friend can tell me how you can solve this problem?
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';
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).
-
- Posts: 2
- Joined: Wed Jan 13, 2016 5:30 am
Re: MYSQL/PHPMYADMIN - Problem with functions
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
Ali
Re: MYSQL/PHPMYADMIN - Problem with functions
Do not log in the root of machine to mysql ... Log in VESTA ROOT and his password.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
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MYSQL/PHPMYADMIN - Problem with functions
You can find root password in /usr/local/vesta/conf/mysql.confDeireadh wrote:Do not log in the root of machine to mysql ... Log in VESTA ROOT and his password.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
Re: MYSQL/PHPMYADMIN - Problem with functions
Autofix for functions and controluser:
viewtopic.php?f=14&t=10307
viewtopic.php?f=14&t=10307