phpMyAdmin : password and user (Help)
| From: | Iguider | Date: | Sun, 01 Dec 2002 21:21:39 +0000 |
| Subject: | phpMyAdmin : password and user (Help) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-126633@lists.php.net to get a copy of this message | ||
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'] = '';