Koozali.org: home of the SME Server

phpmyadmin install

James Shields

phpmyadmin install
« on: November 19, 2001, 01:44:55 AM »
Recently installed dmc-mitel-phpmyadmin-2.2.1-0.noarch.rpm
Everything appeared to install OK, but getting error on accessing using following address: https://www.shields.net.au/phpmyadmin/

This lets me connect using "admin" & "admin password", but gives this message:

Error
MySQL said:
MySQL Connection Failed: Host 'tintagel.shields.net.au' is not allowed to connect to this MySQL server

Can anybody offer me assistance with this problem. Much appreciated.

James Shields

Stefan Brunnengraeber

Re: phpmyadmin install
« Reply #1 on: November 19, 2001, 03:52:45 PM »
Hello James,

MySQL must have your host in the users database. It seems that the RPM doesn't set this information to MySQL. On every linux platform or if I get a new PC, I set this manually:

log in as root!

INSERT INTO db VALUES ( 'youservername_or_ip', '%', 'theuser', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

INSERT INTO user VALUES ( 'youservername_or_ip', 'theuser', password('thepasswd'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

in homedir of phpMyAdmin edit config.inc.php and insert theuser, thepasswd and youservername_or_ip

$cfgServers[1]['host']          = 'youservername_or_ip'; // 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']          = 'theuser';      // MySQL user (only needed with basic auth)
$cfgServers[1]['password']      = 'thepasswd';          // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db']       = '';          // If set to a db-name, only this db is accessible

Don't forget to restart the mysqld with mysqladmin reload

That works on normal Linuxes. I have to try it on SME.

Bye,
Stefan Brunnengraeber

James Shields

Re: phpmyadmin install
« Reply #2 on: November 26, 2001, 07:52:19 AM »
This seems like a real long way around getting this to work. Somebody surely must have used the rpm from Darrell.

Any help would be appreciated.

James