[gentoo-user] OT: phpmyadmin

[Ernie Schroder]

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/';
$cfg['Servers'][$i]['host'] = 'MySQL.localhost';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';
$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 ;>)

--
Regards, Ernie
--
gento...@gentoo.org mailing list

[Joseph]

This tutorial will help you, GUARANTEED 100% (and it is worth a
bookmark).
http://arcticalliance.se/pma.php

--
#Joseph

[Thomas T. Veldhouse]

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/

>$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

>$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

--
gento...@gentoo.org mailing list

[Ernie Schroder]

On Wednesday 15 February 2006 23:53, a tiny voice compelled Joseph to write:
> This tutorial will help you, GUARANTEED 100% (and it is worth a
> bookmark).
> http://arcticalliance.se/pma.php

Fantastic!!! Thanks a lot Joseph. I've got it working. Now to figure out why
LOL.

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