RE: [cobalt-users] Problems With MySQL & PHPMyAdmin

[José Luis Chafardet Grimaldi <joseluis@xxxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx [mailto:cobalt-users-
> admin@xxxxxxxxxxxxxxx] On Behalf Of ISEE Multimedia
> Sent: Wednesday, March 05, 2003 1:11 AM
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: [cobalt-users] Problems With MySQL & PHPMyAdmin
> 
> Hi All,
> 
> Firstly, this is a clean RAQ4.
> 
> I have just installed the latest MySQL from pkgmaster.com and changed the
> default passwords successfully.
> 
> I have now installed phpMyAdmin 2.4 and set the config.inc.php file as
> follows.
> 
> $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
> $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']   = 'root';          // MySQL control
> user settings
>                                                     // (this user must
> have
> read-only
> $cfg['Servers'][$i]['controlpass']   = '**************';          //
> access
> to the "mysql/user"
>                                                     // and "mysql/db"
> tables)
> $cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method
> (config, http or cookie based)?
> $cfg['Servers'][$i]['user']          = '';      // MySQL user
> $cfg['Servers'][$i]['password']      = '';          // MySQL password
> (only
> needed
> 
> Both the passwords here and in MySQL match but when i open the phpMyAdmin
> directory, firstly im not asked for any http authentication (like other
> installs I have performed)
[José Luis Chafardet Grimaldi] 
You must .htaccess it
> 
> And it logs me straight in as MySQL 3.23.54 running on localhost as
> admin@localhost i thought this should be root@localhost
[José Luis Chafardet Grimaldi] 
You sould try from the shell creating another account as far as logging as
root is really insecure.

did you setup
$cfg['PmaAbsoluteUri'] = 'http://www.yourdomain.com/phpMyAdmin';

> 
> and i cannot view anything within phpMyAdmin and the MYSQL table is not
> displayed in the left frame / drop down
> 
> Does anyone have any suggestions as to where im going wrong here?? Ive
> been
> through the documentation on phpMyAdmin and as far as i can see i have
> followed the instructions to the T.
> 
> Regards.
> 
> Mark Priest
> 
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
> 

[José Luis Chafardet Grimaldi] 

Let me know if i have helped you, in the raq4i i was owning some time ago i
have installed it and it worked for me perfect.

Best regards

===========================================================
José Luis Chafardet G.
President
joseluis@xxxxxxxxxxxxxxxx
DGTal Studios Information Communication & Design Integrated Solutions
www.dgtalstudios.com
===========================================================