Bonjour
je viens d'installer phpmyadmin et j'arrive sur l'ecran de connexion.
voici mon fichier de config :
*/
$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'] = 'aszerfdrty';
/*
* 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'] = '';
// The password needed for the controluser to login
// (see $cfg['Servers'][$i]['controluser'])
$cfg['Servers'][$i]['controlpass'] = '';
// 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'] = '';
// Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'pma_bookmark'
$cfg['Servers'][$i]['bookmarktable'] = '';
// table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['relation'] = '';
// table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['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'] = '';
// 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'] = '';
// table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['column_info'] = '';
// table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
$cfg['Servers'][$i]['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:
Config - PmaWiki */
?>
si je mets :
// Allow access without password
$cfg['Servers'][$i]['AllowNoPassword'] =true;
j'ai le message:
"La configuration interdit une connexion sans mot de passe (voir AllowNoPassword)"
si je laisse a false je ne sais pas quoi mettre comme mot de passe.
a la console je peux me connecter avec mysql -u root mais je ne sais pas quoi faire de plus.
Merci pour votre aide a tous
Thierry
No comments:
Post a Comment