[gentoo-user] OT: phpmyadmin

[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
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] OT: phpmyadmin

[Joseph]

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

-- 
#Joseph

On Wed, 2006-02-15 at 22:30 -0500, 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/';
> $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

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] OT: phpmyadmin

[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.
>
> --
> #Joseph
>
> On Wed, 2006-02-15 at 22:30 -0500, 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/';
> > $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

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

Re: [gentoo-user] OT: phpmyadmin

[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


-- 
gentoo-user@gentoo.org mailing list

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@gentoo.org mailing list