PhpMyadmin 3.4.4 errors

Discussion in 'General' started by neobcn, Aug 26, 2011.

  1. neobcn

    neobcn New Member

    Hi i upload the new version of Phpmyadmmin, i reupload de

    all ok but appear this errors, please see the attach capture.

  2. ande

    ande Member HowtoForge Supporter

    Looks like phpMyAdmin works fine, it complains only that you'll have to create the "Linked Tables Infrastructure" if you want to use SQL-History, Relations manager etc.


    As far as I remember, you'll have to

    - create a database mostly called "phpmyadmin" . There is a SQL file for that that you may import.
    - create an underpriviledged user and give it (him?) only rights to that database, and SELECT rights on teh database "mysql".
    - write user / password / database in the

    It was always not very intuitive, but after RTFM it works mostly..

    New phpMyAdmin version looks nice, BTW.
  3. neobcn

    neobcn New Member

    Very Thx ande but my novice in Linux, please is possible put a guide????

    thx a new

    i create user "pma" and "pass" the rights i select all in the columm "data"

    i import the script create_tables.sql

    i edit in : /etc/phpmyadmin/

    * Debian local configuration file
    * This file overrides the settings made by phpMyAdmin interactive setup
    * utility.
    * For example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz
    * NOTE: do not add security sensitive data to this file (like passwords)
    * unless you really know what you're doing. If you do, any user that can
    * run PHP or CGI on your webserver will be able to read them. If you still
    * want to do this, make sure to properly secure the access to this file
    * (also on the filesystem level).

    $i = 0;
    // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
    // You can disable a server config entry by setting host to ''.

    * Read configuration from dbconfig-common
    * You can regenerate it using: dpkg-reconfigure -plow phpmyadmin

    if (is_readable('/etc/phpmyadmin/config-db.php')) {

    /* Configure according to dbconfig-common if enabled */
    if (!empty($dbname)) {
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    if (empty($dbserver)) $dbserver = 'localhost';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport)) {
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['port'] = $dbport;
    //$cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    /* Optional: User for advanced features */
    $cfg['Servers'][$i]['controluser'] = $dbuser;
    $cfg['Servers'][$i]['controlpass'] = $dbpass;
    /* 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]['designer_coords'] = 'pma_designer_coords';
    $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

    /* Uncomment the following to enable logging in to passwordless accounts,
    * after taking note of the associated security risks. */
    // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

    /* Advance to next server for rest of config */

    how to add the new valors???

    Last edited: Aug 26, 2011
  4. ande

    ande Member HowtoForge Supporter

    Dear Barcelona guy :)

    That is fine as long as you use a much better password than "pass"!

    No, not necessary to select columns.

    1. Create a user with NO rights at all, but password and host = localhost (not "%"!)

    2. Grant that user SELECT, INSERT, DELETE, UPDATE permissions only for the database "pma".

    That should already resolve most of the problems.

    3. Grant that user SELECT permissions for database "mysql".

    Very good, You've seen those tables have been created I assume.

    Yes, but you see that with Debian, it points to another file:

    and as I have Debian as wll, I saw that even the other file is empty. So I have no idea right now where phpMyAdmin sits. :-/ Maybe inside /var/local/ispconfig - but please dont tinker there.. might break things.

  5. neobcn

    neobcn New Member

    Yes my install is dedian 6 , and i install ispconfig 3 , see the guide in howtooforge

    any solution for solve this??

Share This Page