Hi Please I need a help, I used to work with asp and now I am migrating to php, my site web works perfectly on my PC (windows). I am runing phpMyAdmin 2.2.6, and easyphp on local machine . when my host give me a username and password, I want to change the file "phpMyAdmin/config.inc.php" from user="root" to user="username" and from password= "" to password="password", the phpMyAdmin show me "Host 'localhost' is not allowed to connect to this MySQL server" even if i setup the default values.
the phpMyAdmin/config.inc.php is : $cfgServers[$i]['host'] = 'localhost'; // MySQL hostname $cfgServers[$i]['port'] = ''; // MySQL port - leave blank for default port $cfgServers[$i]['socket'] = ''; // Path to the socket - leave blank for default socket $cfgServers[$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfgServers[$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfgServers[$i]['controlpass'] = ''; // access to the "mysql/user" // and "mysql/db" tables) $cfgServers[$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfgServers[$i]['user'] = 'root'; // MySQL user $cfgServers[$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfgServers[$i]['only_db'] = ''; // If set to a db-name, only // this db is displayed // at left frame // It may also be an array // of db-names $cfgServers[$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname $cfgServers[$i]['bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support $cfgServers[$i]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support $cfgServers[$i]['relation'] = ''; // table to describe the relation between links (see doc) // - leave blank for no relation-links support $i++; $cfgServers[$i]['host'] = ''; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket'] = ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = ''; $cfgServers[$i]['controlpass'] = ''; $cfgServers[$i]['auth_type'] = 'config'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb'] = ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = ''; $i++; $cfgServers[$i]['host'] = ''; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket'] = ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = ''; $cfgServers[$i]['controlpass'] = ''; $cfgServers[$i]['auth_type'] = 'config'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb'] = ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = '';