[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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)

And it logs me straight in as MySQL 3.23.54 running on localhost as
admin@localhost i thought this should be root@localhost

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