MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Marvin Cummings Date:April 4 2004 10:20am
Subject:RE: Unable to connect to mysql with phpmyadmin
View as plain text  
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:kenny@stripped] 
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:eatley@stripped] 
> 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?
unsub=kenny@stripped
> 
> 
> 


Thread
Unable to connect to mysql with phpmyadminMarvin Cummings4 Apr
  • Re: Unable to connect to mysql with phpmyadminMichael Stassen4 Apr
RE: Unable to connect to mysql with phpmyadminMarvin Cummings4 Apr
RE: Unable to connect to mysql with phpmyadminMarvin Cummings4 Apr
RE: Unable to connect to mysql with phpmyadminMarvin Cummings4 Apr
  • Re: Unable to connect to mysql with phpmyadminMichael Stassen4 Apr
    • RE: Unable to connect to mysql with phpmyadminMarvin Cummings5 Apr
      • Re: Unable to connect to mysql with phpmyadminMichael Stassen5 Apr