Re: [cobalt-users] phpMyAdmin on a Raq 550

["Steve Bassi" <steve@xxxxxxxxx>]

> > Easiest way:
> > Download phpmyadmin 2.2.6
> > tar.gz
> > Unzip
> > Edit config.inc ( http as auth. Method + the absolute url) Upload
>
> But does it enable the one feature I want? Users only seeing THEIR
> database?
>

> Of course:

If you want to make phpmyadmin work on any domain, you may wish to try the
following.
I am not sure of the RAQ550 set up, but this should work on RAQ3 and RAQ4

http://anydomain.com/phpmyadmin

Will then work.

Rgds Bassi

==========Instructions below ============

SSH into RAQ
su -
mkdir /home/phpMyAdmin
cd /home/phpMyadmin
# get phpmyadmin tarball
wget phpMyAdmin.tar.gz

tar -xzvf phpMyAdmin.tar.gz

# edit the config file to reflect your requirements
pico -w config.inc.php

# You may need to do this, depends on how you have MYSQL set up
mysql -u root -p(your password here)
GRANT USAGE ON mysql.* TO 'mysql'@'localhost' IDENTIFIED BY '';
GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv,
Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv,
Process_priv, File_priv, Grant_priv, References_priv, Index_priv,
Alter_priv) ON mysql.user TO 'mysql'@'localhost';
GRANT SELECT ON mysql.db TO 'mysql'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON
mysql.tables_priv TO 'mysql'@'localhost';
exit

chown -cR root.root /home/phpMyAdmin
chgrp -cR root.root /home/phpMyAdmin
chmod 775 /home/phpMyAdmin

#turn on Magic Quotes (if they are off)
cp -p /etc/httpd/php.ini /etc/httpd/php.ini.phpMyAdmin.bak
pico -w  /etc/httpd/php.ini
Find the magic quotes line , change off to on and save and exit the file

# Check the admin GUI and make sure php is turned on for the main site

# Change srm.conf and add the alias that will redirect to phpMyAdmin,
examples below
pico -w /etc/httpd/conf/srm.conf

##   added by ??? date ? ##
Alias /phpmyadmin /home/phpMyAdmin
Alias /myadmin /home/phpMyAdmin
##   End of phpMyAdmin Additions   ##


#restart httpd
/etc/rc.d/init.d/httpd restart