[FIX] phpmyadmin some feature/controluser

[Sanity]

i have the same problem. Im using Ubuntu 16.10 , php7 and phpmyadmin 4.5.4.1

Is the script compatible?

[mehargags]

hi Skurudo
could you please upgrade your 'fix' script for Debian 9 please.

Thanks a ton

[Teo]

I applied the centos fix but i still have this issue:
what should i do now?

What was not ok? All or some tables?

i did what you wrote but i still have this issue. what is missing please?

Do you have mysql root pass for database in /root/.my.cnf?

yes i have it in .my.cfg

and the error says i have to create a database called phpmyadmin and set the config storage phpMyAdmin there... something like that.

thanks.

[someuser]

hi Skurudo
could you please upgrade your 'fix' script for Debian 9 please.

Thanks a ton

+

We definitely need this fix for Debian 9

[teledigital]

Thaks, this work for me in Ubuntu 16.0.4

[mikhailnov]

Pavel, bolshoe spasibo to you for this script. Слава опенсорсу!
Worked in Ubuntu 18.04 (bionic).

[mrluisiko99]

hi Skurudo
could you please upgrade your 'fix' script for Debian 9 please.

Thanks a ton

+

We definitely need this fix for Debian 9

+1 for Debian 9!

[huloza]

hi Skurudo
could you please upgrade your 'fix' script for Debian 9 please.

Thanks a ton

+

We definitely need this fix for Debian 9

+1 for Debian 9!

+1 Debian 9 please!

[dpeca]

in SSH as root run:

Code: Select all

dpkg-reconfigure -plow phpmyadmin

(choose to reinstall database, choose 'unix socket', left blank pass for phpmyadmin, choose to configure Apache2 at end)

and in /etc/phpmyadmin/config.inc.php part around 77 line should looks like:

Code: Select all

    /* Optional: Advanced phpMyAdmin features */
    $cfg['Servers'][$i]['pmadb'] = $dbname;
    $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]['designer_coords'] = 'pma__designer_coords';
    $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
    $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
    $cfg['Servers'][$i]['recent'] = 'pma__recent';
    $cfg['Servers'][$i]['users'] = 'pma__users';
    $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
    $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
    $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
    $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
    $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
    $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
    $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

[mrluisiko99]

in SSH as root run:

Code: Select all

dpkg-reconfigure -plow phpmyadmin

(choose to reinstall database, choose 'unix socket', left blank pass for phpmyadmin, choose to configure Apache2 at end)

Does it work for Nginx + php-fpm?