Results 1 to 3 of 3

Thread: phpMyAdmin config file question

  1. #1
    Join Date
    Jul 2011
    Location
    Čačak, Serbia
    Posts
    148

    Post phpMyAdmin config file question

    Hello,

    I wanted to install LAMP. I did everything you wrote in LAMP tutorial, but it is totally mess in my head when I started to setting up phpMyadmin configuration file config.inc.php . Where to change things you are suggested (: in those comented parts, or before? If it is one of comented parts, tell me first or second?) What about Storrage settings? I work on OpenSuSE 13.1. Thank you for answer my question.

    Vladimir,
    Serbia

    This is my config.inc.php file

    <?php
    /* vim: set expandtab sw=4 ts=4 sts=4: */
    /*
    * phpMyAdmin sample configuration, you can use it as base for
    * manual configuration. For easier setup you can use setup/
    *
    * All directives are explained in Documentation.html and on phpMyAdmin
    * wiki <http://wiki.phpmyadmin.net>.
    *
    * @package PhpMyAdmin
    */

    /*
    * Your phpMyAdmin url
    *
    * Complete the variable below with the full url ie
    * https://www.your_web.net/path_to_you...min_directory/
    *
    * It must contain characters that are valid for a URL, and the path is
    * case sensitive on some Web servers, for example Unix-based servers.
    *
    * In most cases you can leave this variable empty, as the correct value
    * will be detected automatically. However, we recommend that you do
    * test to see that the auto-detection code works in your system. A good
    * test is to browse a table, then edit a row and save it. There will be
    * an error message if phpMyAdmin cannot auto-detect the correct value.
    *
    * If the auto-detection code does work properly, you can set to true the
    * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
    */
    $cfg['PmaAbsoluteUri'] = '';

    /*
    * This is needed for cookie based authentication to encrypt password in
    * cookie
    * YOU MUST FILL IN THIS FOR COOKIE AUTH!
    */
    $cfg['blowfish_secret'] = '';

    /*
    * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
    * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
    * works perfectly.
    */
    $cfg['PmaAbsoluteUri_DisableWarning'] = false;

    /*
    * Disable the default warning that is displayed on the DB Details Structure page if
    * any of the required Tables for the relationfeatures could not be found
    */
    $cfg['PmaNoRelation_DisableWarning'] = false;

    /*
    * Disable the default warning that is displayed if Suhosin is detected
    *
    * @global boolean $cfg['SuhosinDisableWarning']
    */
    $cfg['SuhosinDisableWarning'] = true;

    /*
    * Servers configuration
    */
    $i = 0;

    /***************************************
    * First server
    */
    $i++;
    // MySQL hostname or IP address
    $cfg['Servers'][$i]['host'] = 'localhost';

    // MySQL port - leave blank for default port
    $cfg['Servers'][$i]['port'] = '';

    // Path to the socket - leave blank for default socket
    $cfg['Servers'][$i]['socket'] = '';

    // Use SSL for connecting to MySQL server?
    $cfg['Servers'][$i]['ssl'] = false;

    // How to connect to MySQL server ('tcp' or 'socket')
    $cfg['Servers'][$i]['connect_type'] = 'socket';

    // The PHP MySQL extension to use ('mysql' or 'mysqli')
    $cfg['Servers'][$i]['extension'] = 'mysqli';

    // Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
    $cfg['Servers'][$i]['compress'] = false;

    // Authentication method (config, http or cookie based)?
    $cfg['Servers'][$i]['auth_type'] = 'cookie';

    // MySQL user
    $cfg['Servers'][$i]['user'] = 'root';

    // MySQL password (only needed with 'config' auth_type)
    $cfg['Servers'][$i]['password'] = '';

    // Allow access without password
    $cfg['Servers'][$i]['AllowNoPassword'] = false;

    // whether to allow root login
    $cfg['Servers'][$i]['AllowRoot'] = true;

    // Session to use for 'signon' authentication method
    $cfg['Servers'][$i]['SignonSession'] = '';

    // URL where to redirect user to login for 'signon' authentication method
    $cfg['Servers'][$i]['SignonURL'] = '';

    // URL where to redirect user after logout
    $cfg['Servers'][$i]['LogoutURL'] = '';

    // If set to a db-name, only this db is displayed in left frame
    // It may also be an array of db-names, where sorting order is relevant.
    $cfg['Servers'][$i]['only_db'] = '';

    // Verbose name for this host - leave blank to show the hostname
    $cfg['Servers'][$i]['verbose'] = '';

    // set to false if you know that your pma_* tables
    // are up to date. This prevents compatibility
    // checks and thereby increases performance.
    $cfg['Servers'][$i]['verbose_check'] = true;

    // Host authentication order, leave blank to not use
    $cfg['Servers'][$i]['AllowDeny']['order'] = '';

    // Host authentication rules, leave blank for defaults
    $cfg['Servers'][$i]['AllowDeny']['rules'] = array();

    /*
    * phpMyAdmin configuration storage settings.
    */

    $cfg['Servers'][$i]['controlhost'] = '';

    // MySQL control user settings (this user must have read-only
    // access to the "mysql/user" and "mysql/db" tables).
    // The controluser is also used for all relational features (pmadb)
    $cfg['Servers'][$i]['controluser'] = 'pma';

    // The password needed for the controluser to login
    // (see $cfg['Servers'][$i]['controluser'])
    $cfg['Servers'][$i]['controlpass'] = 'my-password';

    // Database used for Relation, Bookmark and PDF Features
    // (see _docdir/examples/create_tables.sql)
    // - leave blank for no support
    // DEFAULT: 'phpmyadmin'
    $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

    // Bookmark table
    // - leave blank for no bookmark support
    // DEFAULT: 'pma_bookmark'
    $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

    // table to describe the relation between links (see doc)
    // - leave blank for no relation-links support
    // DEFAULT: 'pma_relation'
    $cfg['Servers'][$i]['relation'] = 'pma_relation';

    // table to describe the display fields
    // - leave blank for no display fields support
    // DEFAULT: 'pma_table_info'
    $cfg['Servers'][$i]['table_info'] = 'pma_table_info';

    // table to describe the tables position for the PDF schema
    // - leave blank for no PDF schema support
    // DEFAULT: 'pma_table_coords'
    $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';

    // table to describe pages of relationpdf
    // - leave blank if you don't want to use this
    // DEFAULT: 'pma_pdf_pages'
    $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';

    // table to store column information
    // - leave blank for no column comments/mime types
    // DEFAULT: 'pma_column_info'
    $cfg['Servers'][$i]['column_info'] = 'pma_column_info';

    // table to store SQL history
    // - leave blank for no SQL query history
    // DEFAULT: 'pma_history'
    $cfg['Servers'][$i]['history'] = 'pma_history';

    // Table to store user interface enhancement data.
    // - Leave blank to disable.
    // DEFAULT: 'pma_table_uiprefs'
    $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';

    // Table to store version/change tracking data
    // - leave blank to disable
    // DEFAULT: 'pma_tracking'
    $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

    // Table in which to store information for the designer feature.
    // DEFAULT: 'pma_designer_coords'
    $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

    // Table to store user preferences -- allows users to set most
    // preferences by themselves and store them in the phpMyAdmin
    // configuration storage database.
    // If you don't allow for storing preferences in pmadb, users can
    // still personalize phpMyAdmin, but settings will be saved in
    // browser's local storage, or, it is is unavailable, until the end
    // of session.
    // DEFAULT: 'pma_userconfig'
    $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

    // Table to store a list of recently used tables to be shown in the
    // left navigation frame. It helps you to jump across table directly,
    // without the need to select the database, and then select the table.
    // Using $cfg['LeftRecentTable'] you can configure the maximum number
    // of recent tables shown.
    // Without configuring the storage, you can still access the recently
    // used tables, but it will disappear after you logout.
    // DEFAULT: 'pma_recent'
    $cfg['Servers'][$i]['recent'] = 'pma_recent';

    /* Contrib / Swekey authentication */
    // The name of the file containing Swekey ids and login names for
    // hardware authentication. Leave the string empty to deactivate this
    // feature.
    // see _docdir/examples/swekey.sample.conf
    //$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/phpMyAdmin/swekey-pma.conf';


    /***************************************
    * Second Server
    */

    /*
    $i++;
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['port'] = '';
    $cfg['Servers'][$i]['socket'] = '';
    $cfg['Servers'][$i]['ssl'] = false;
    $cfg['Servers'][$i]['connect_type'] = 'socket';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '';
    $cfg['Servers'][$i]['AllowNoPassword'] = false;
    $cfg['Servers'][$i]['AllowRoot'] = true;
    $cfg['Servers'][$i]['SignonSession'] = '';
    $cfg['Servers'][$i]['SignonURL'] = '';
    $cfg['Servers'][$i]['LogoutURL'] = '';
    $cfg['Servers'][$i]['only_db'] = '';
    $cfg['Servers'][$i]['verbose'] = '';
    $cfg['Servers'][$i]['verbose_check'] = true;
    $cfg['Servers'][$i]['AllowDeny']['order'] = '';
    $cfg['Servers'][$i]['AllowDeny']['rules'] = array();

    /*
    * phpMyAdmin configuration storage settings.
    */

    /*
    $cfg['Servers'][$i]['controlhost'] = '';
    $cfg['Servers'][$i]['controluser'] = '';
    $cfg['Servers'][$i]['controlpass'] = '';
    $cfg['Servers'][$i]['pmadb'] = '';
    $cfg['Servers'][$i]['bookmarktable'] = '';
    $cfg['Servers'][$i]['relation'] = '';
    $cfg['Servers'][$i]['table_info'] = '';
    $cfg['Servers'][$i]['table_coords'] = '';
    $cfg['Servers'][$i]['pdf_pages'] = '';
    $cfg['Servers'][$i]['column_info'] = '';
    $cfg['Servers'][$i]['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]['recent'] = 'pma_recent';
    $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/phpMyAdmin/swekey-pma_02.conf';
    */

    // If you have more than one server configured, you can set $cfg['ServerDefault']
    // to any one of them to autoconnect to that server when phpMyAdmin is started,
    // or set it to 0 to be given a list of servers without logging in
    // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
    // set to that server.

    // Default server (0 = no default server)
    $cfg['ServerDefault'] = 1;
    $cfg['Server'] = '0';
    unset($cfg['Servers'][0]);

    /***************************************
    * End of servers configuration
    */

    /*
    * Directories for saving/loading files from server
    */
    $cfg['UploadDir'] = '';
    $cfg['SaveDir'] = '';

    /**
    * Defines whether a user should be displayed a "show all (records)"
    * button in browse mode or not.
    * default = false
    */
    //$cfg['ShowAll'] = true;

    /**
    * Number of rows displayed when browsing a result set. If the result
    * set contains more rows, "Previous" and "Next".
    * default = 30
    */
    //$cfg['MaxRows'] = 50;

    /**
    * Use graphically less intense menu tabs
    * default = false
    */
    //$cfg['LightTabs'] = true;

    /**
    * disallow editing of binary fields
    * valid values are:
    * false allow editing
    * 'blob' allow editing except for BLOB fields
    * 'all' disallow editing
    * default = blob
    */
    //$cfg['ProtectBinary'] = 'false';

    /**
    * Default language to use, if not browser-defined or user-defined
    * (you find all languages in the locale folder)
    * uncomment the desired line:
    * default = 'en'
    */
    //$cfg['DefaultLang'] = 'en';
    //$cfg['DefaultLang'] = 'de';

    /**
    * default display direction (horizontal|vertical|horizontalflipped)
    */
    //$cfg['DefaultDisplay'] = 'vertical';


    /**
    * How many columns should be used for table display of a database?
    * (a value larger than 1 results in some information being hidden)
    * default = 1
    */
    //$cfg['PropertiesNumColumns'] = 2;

    /**
    * Set to true if you want DB-based query history.If false, this utilizes
    * JS-routines to display query history (lost by window close)
    *
    * This requires configuration storage enabled, see above.
    * default = false
    */
    //$cfg['QueryHistoryDB'] = true;

    /**
    * When using DB-based query history, how many entries should be kept?
    *
    * default = 25
    */
    //$cfg['QueryHistoryMax'] = 100;

    /*
    * You can find more configuration options in Documentation.html
    * or here: http://wiki.phpmyadmin.net/pma/Config
    */
    ?>

  2. #2
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    17,317

    Default Re: phpMyAdmin config file question

    On Sun, 19 Jan 2014 11:36:01 +0000, Vajcek wrote:

    > I wanted to install LAMP. I did everything you wrote in 'LAMP tutorial'
    > (http://en.opensuse.org/SDB:LAMP_setup), but it is totally mess in my
    > head when I started to setting up phpMyadmin configuration file
    > config.inc.php . Where to change things you are suggested (: in those
    > comented parts, or before? If it is one of comented parts, tell me first
    > or second?) What about Storrage settings? I work on OpenSuSE 13.1. Thank
    > you for answer my question.


    As I look at the information on the wiki page you referenced, it seems to
    indicate that you should just search for the information in each line in
    your config file and replace the values (and uncomment it). PHP doesn't
    care about the order, so you could also just add it to the end of the
    file, as long as the values aren't set earlier in the file (and actually,
    PHP may not care about that either, since the new value would just be
    replaced by the old value).

    I've found phpMyAdmin to work really well on openSUSE, though I haven't
    used this specific tutorial myself.

    Perhaps someone else who has can comment as well?

    Jim



    --
    Jim Henderson
    openSUSE Forums Administrator
    Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

  3. #3
    Join Date
    Apr 2013
    Location
    Modra, Slovakia
    Posts
    265

    Default Re: phpMyAdmin config file question

    Jim is right it doesn't matter where the oparticular variable as long is haven't been set twice, but I'd preffer the beggining of the file up to the section second server, (I suppose you've one mysql server.)
    13.2 KDE 64bit tumbleweed
    Lenovo G500s, Thinkpad R500

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •