Author Topic: phpMyadmin Error Any user ?  (Read 17944 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
phpMyadmin Error Any user ?
« on: February 21, 2016, 09:27:18 PM »
Hi;

phpMyAdmin it gives each user the same error ?
Why is he doing this ?
What is the solution ?

Thx...


Code: [Select]
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
      Or alternately go to 'Operations' tab of any database to set it up there.

Offline
*
Re: phpMyadmin Error Any user ?
« Reply #1 on: February 21, 2016, 10:36:11 PM »
I take care of the problem :)

phpMyAdmin problem can not find the place settings to register.

Make phpMyAdmin login with root account.
"PhpMyAdmin" fully authorized users assign to the database.
and enter this information in the following locations

phpmyadmin/config.inc.php


The following existing code beginning "//" removing active AVAILABILITY.


Replace them

Code: [Select]
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
$cfg['Servers'][$i]['controlpass'] = 'PWD-in-phpymadin-db';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

Offline
***
Re: phpMyadmin Error Any user ?
« Reply #2 on: February 22, 2016, 05:15:19 AM »
Hi!

Why do we need this?

venty

Offline
*
Re: phpMyadmin Error Any user ?
« Reply #3 on: February 22, 2016, 12:11:46 PM »
I mentioned above gives error in phpMyAdmin opening.

User settings for that section will be recorded.

Each user can not create tables for should hardly have full authority.

I did manually fix the problem completely.

Offline
***
Re: phpMyadmin Error Any user ?
« Reply #4 on: February 22, 2016, 12:28:20 PM »
I ask because...

I want to install PRSTASHOP, but during my installation returns an error


Populate database tables error
An error occurred during installation...
You can use the links on the left column to go back to the previous steps, or restart the installation process by clicking here.

I looked server logs and is filled with rows of type:

[Mon Feb 22 12:08:59 2016] [error] [client 213.16.32.22] PHP Warning:  Error while sending QUERY packet. PID=25623 in /home/ven/public_html/cmarket.eu/classes/db/DbPDO.php on line 134, referer: http://www.cmarket.eu/install/index.php?restart=true


BR
Venty

Offline
*
Re: phpMyadmin Error Any user ?
« Reply #5 on: February 22, 2016, 06:54:23 PM »
Your problem is not related to it.

but typing on your high value here.

max_allowed_packet =

Try.

respects..

Offline
***
Re: phpMyadmin Error Any user ?
« Reply #6 on: February 23, 2016, 08:00:39 AM »
I'm sorry, but I did not understand ...

Offline
*
Re: phpMyadmin Error Any user ?
« Reply #7 on: February 04, 2020, 10:19:31 AM »
sorry for reply old thread but this thread is what i need. i do not want to reopen such as thread again..

hi, this is fixed my issue about server side.

I take care of the problem :)

phpMyAdmin problem can not find the place settings to register.

Make phpMyAdmin login with root account.
"PhpMyAdmin" fully authorized users assign to the database.
and enter this information in the following locations

phpmyadmin/config.inc.php


The following existing code beginning "//" removing active AVAILABILITY.


Replace them

Code: [Select]
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
$cfg['Servers'][$i]['controlpass'] = 'PWD-in-phpymadin-db';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

but issue remain with created new website.

there is only one config.inc.php file...

"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.
"

so, what should i do?


thanks in advance
« Last Edit: February 04, 2020, 10:22:35 AM by kerim92 »