Re: [cobalt-users] Fw: Cobalt MySQL package

[Simon Billis <simon@xxxxxxxxxxxxxxxxxxxxxxx>]

On Tuesday, March 12, 2002 4:37 pm, Lillith Lesanges <lillith@xxxxxxxxxx> wrote:
>On Tuesday, March 12, 2002, at 08:53 AM, Micha Kagie wrote:
>> Does anybody know where I can find a HOW-TO for the Cobalt MySQL (3.23.37)
>>  package?
>>
>> I just installed this package, and now I want to create a database with 
>> it, which i can use with a website, but I don't know where to
>start! :-(
>
>Well, this isn't Cobalt-specific, but is a good source of general MySQL 
>information:
>
>http://www.mysql.com/docs/
>
>
>Some people on the list will also mention phpmyAdmin, which I have had 
>some trouble getting installed and working properly, but is a way to 
>administrate MySQL through a web interface.
>
>Anybody know what I need to do to get phpmyAdmin set up so I can actually 
>add and manipulate databases?  Right now, all I see is a place to change 
>the mysql admin password.
>
>Lillith K. Lesanges
>Sysadmin/Programmer, MIS, Inc.
>lillith@xxxxxxxxxx
>http://www.misinc.net/

Hi,

In config.inc.php found in the phpmyadmin directory, the relevant section follows below, change the relevent parts as required.

Also if you get the following error "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) " then you may wish to put in a symlink into /tmp pointing to the location of mysql.sock

// The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host']          = 'localhost'; // MySQL hostname 
$cfgServers[1]['port']          = '';          // MySQL port - leave blank for default port
$cfgServers[1]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfgServers[1]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfgServers[1]['adv_auth']      = FALSE;       // Use advanced authentication?
$cfgServers[1]['stduser']       = '';          // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass']       = '';          // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user']          = 'USERNAME';      // MySQL user (only needed with basic auth)
$cfgServers[1]['password']      = 'PASSWORD';          // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db']       = '';          // If set to a db-name, only this db is accessible
                                               // It may also be an array of db-names
$cfgServers[1]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
$cfgServers[1]['bookmarkdb']    = '';          // Bookmark db - leave blank for no bookmark support
$cfgServers[1]['bookmarktable'] = '';          // Bookmark table - leave blank for no bookmark support


I hope that this helps


Simon