Re: [gentoo-user] OT: phpmyadmin

[Ernie Schroder]

On Thursday 16 February 2006 08:11, a tiny voice compelled Thomas T. Veldhouse 
to write:
> Ernie Schroder wrote:
> >I am just starting to play with php and mysql. I've got mysql working and
> > can log into root accounts using a password. php scripts work on
> >http://localhost. For example, http://localhost/php/index.php in a browser
> >shows a whole lot of info re php, mysql and apache2. However, I can't seem
> > to get phpmyadmin working.
> >Going to http://localhost/phpmyadmin, gives me a window asking for
> > username and password. If I insert my mysql username (root) and root's
> > mysql password, I just get the same box with no error. I've tried adding
> > a small
> >config.inc.php file to /var/www/localhost/htdocs that is configured like
> > so"
> >
> ><?php
> >$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
>
> Try 'http://127.0.0.1/phpmyadmin/

Tried that too. As well as hostname.domainname/phpmyadmin/
>
> >$cfg['Servers'][$i]['host'] = 'MySQL.localhost';
>
> '127.0.0.1'
>
> >$cfg['Servers'][$i]['auth_type'] = 'config';
>
> 'cookie'
>
> >$cfg['Servers'][$i]['user'] = 'root';
> >$cfg['Servers'][$i]['password'] = 'password';
>
> don't set the user and password

Tried that too.
>
> >$cfg['blowfish_secret'] = '1234';
> >?>
> >I restarted mysql and apache2 and still no joy
> >Obviously, I'm missing something, but I can't find anything after many
> > hours of searching that points me in the right direction. HELP ;>)
>
> When prompted for username and password, you probably want to start with
> a superuser that you created in MySQL.
>
> Tom Veldhouse


What I hadn't noticed when I emerged phpmyadmin, and none of the documentation 
I had read had told me, was there is a script installed by phpmyadmin located 
at:
/usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql
that needs to be run to setup a database for phpmyadmin.
I had to delete my previously created tables by doing:
# rm -r /var/lib/mysql/*
then, after starting mysql,
# /usr/bin/mysql_install_db
then I could login to mysql, set the root password and run the above script.
All is well. I can now run phpmyadmin in the browser at:
http://localhost/phpmyadmin/,
http://127.0.0.1/phpmyadmin/
or
hostname.domainname/phpmyadmin

Only thing left to do is learn how to use all this neat stuff.
-- 
Regards, Ernie
-- 
gentoo-user@g.o mailing list