I've tried it both ways using the default root and no password and root with
my assigned password. Either way returns an error. Here's a part of my
config.inc.php file:
// 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 ''.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP
address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave
blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket -
leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to
MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed
protocol for the MySQL connection
// (requires PHP >=
4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user
settings
// (this user must have
read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the
"mysql/user"
// and "mysql/db"
tables).
// The controluser is
also
// used for all
relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'HTTP'; // Authentication method
(config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only
needed
// with 'config'
auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // 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]['verbose'] = ''; // Verbose name for this
host - leave blank to show the hostname
Again I've tried it with 'config' and 'HTTP' as the 'auth_type' with and
without a password. I'm sure I'm missing something.
Thanks again
-----Original Message-----
From: Kenny Phipps [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 03, 2004 11:38 PM
To: Marvin Cummings
Subject: RE: Unable to connect to mysql with phpmyadmin
Are you using the username and password in the config file? or the
username and password for sql? For phpmyadmin, you use the username
and password in the config file.
> Ok. I'm using the default config.inc.php file which has 'config' as
the
> 'auth_type'. I change this to HTTP and I'm prompted to enter a
username and
> password. I try root and its password and get "You are not authorized
to
> view this page". This happens regardless of the account I use. I know
I'm
> missing something here and it's driving me crazy.
>
> Thanks for the help.
>
> -----Original Message-----
> From: Eve Atley [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 03, 2004 9:54 PM
> To: Marvin Cummings
> Subject: Re: Unable to connect to mysql with phpmyadmin
>
> > I see $cfg all over the place and no mention of HTTP. Where should
I be
> > looking for this?
> >
> > Thanks
>
>
> Hi,
>
> Sent you a screenshot to give you an idea of how I'm running mine
with root.
> You can set it to HTTP (which prompts you) or to 'Config'. Try
leaving out
> the password and just put root as the username.
>
> - Eve
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
