Author Topic: phpMyadmin Error Any user ?  (Read 11275 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 »

Offline
*
Re: phpMyadmin Error Any user ?
« Reply #8 on: December 24, 2020, 09:40:04 PM »
I had same error on fresh startup of phpMyAdmin, every time , on first start after fresh install, a complaint, of an error and some options being disabled, solution , install newer, reinstall same or whatever version from scratch, the problem is /tmp folder .. now to the solution, a fair warning i don't knw will this damage or erase or in any other way the already present database cluster, so backup .. :
Backup existing phpMyAdmin :
Code: [Select]
mv /usr/local/cwpsrv/var/services/pma /usr/local/cwpsrv/var/services/pma.baksLets go to .. :
Code: [Select]
cd /usr/local/cwpsrv/var/services/ .. and download :
Code: [Select]
wget https://files.phpmyadmin.net/phpMyAdmin/4.9.7/phpMyAdmin-4.9.7-all-languages.zip.. blahblahbla .. just execute them .. :
Code: [Select]
unzip phpMyAdmin-4.9.7-all-languages.zip
mv phpMyAdmin-4.9.7-all-languages pma
cd /usr/local/cwpsrv/var/services/pma
mv config.sample.inc.php config.inc.php
mkdir /usr/local/cwpsrv/var/services/pma/tmp
Now this one is important :
Code: [Select]
mysql -u root -ppISQpNih9ZqX < /usr/local/cwpsrv/var/services/pma/sql/create_tables.sql... just in case :
Code: [Select]
chown -R nobody:nobody /usr/local/cwpsrv/var/services/pma/
chmod 4744 tmp
Blowfish secret , at least 32 chars , here (i use nano as editor, personal choice) :
nano config.inc.php
Code: [Select]
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$cfg['blowfish_secret'] = '$2a$07$s4r2eS3qMvw1PdzMlUwYsdffyuftynfugu6erg68AuzH3I3gyoN7ncnSkblZ7iEfcx3Qm'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
... and here is the devil himself (still open  config.inc.php .. after blowfish key insertion) :
Code: [Select]
Navigate down few rows to this key $cfg['SaveDir'] = ''; and add this below > $cfg['TempDir'] = '/tmp/';(Control+o > Enter > Control+x) Save>Exit>Reboot (just in case)
start phpMyAdmin from the panel > Boooom login page (use user root and password generated at the end of installation of the panel)
and finally ... peace

Now im in a MMA fight with PHP selectors switchers, optional modules just give a hard fight .. ouch, ouch ..