Topic: phpMyAdmin

[Dave Reinhardt]

I have successfuly instaled phpMyAdmin on my e-smith.
but when we installed it on my daughters e-smith server
doing the following we could not get it to run.
what are we missing?

I installed: e-smith-phpmyadmin-0.2-2.noarch.rpm
and got this when I went to http://servername:980/phpMyAdmin
 #------------------------------------------------------------ # DO NOT MODIFY THIS FILE! It is updated automatically by the # e-smith server and gateway software. Instead, modify the source # template in the /etc/e-smith/templates directory. For more # information, see http://www.e-smith.org. # # copyright (C) 1999-2001 e-smith, inc. #------------------------------------------------------------ #------------------------------------------------------------ # TEMPLATE END #-----------------------------------------------------------

so we installed e-smith-phpmyadmin-0.2-3.src.rpm
annd got the same as above.

[Scott Smith]

I've not used the e-smith-phpmyadmin rpm as I find it simple enough to do the following:

1. create an i-bay using the e-smith-manager -- I called mine phpmyadmin

2. extract the phpmyadmin files into the i-bay's html directory (easily referenced as ~phpmyadmin/../html)

3. remove the file ~phpmyadmin/../html/index.html (allows index.php to load by default -- leave this if you want to "hide" phpmyadmin)

4. point your browser to the i-bay using http://e-smith-server/phpmyadmin (if you removed index.html) or http://e-smith-server/phpmyadmin/index.php (if you left index.html in place)

Simple and works perfectly, so I'm curious as to what the rpm offers.

Scott

[Dave Reinhardt]

What is the differance between a SRC version and a noarch?
e-smith-adm-phpmyadmin-2.2.0-0.noarch.rpm
e-smith-adm-phpmyadmin-2.2.0-0.src.rpm

[Dan Brown]

In brief, the .src.rpm contains all the source files needed to create the .noarch.  If you needed to modify it in some way, you'd need the .src.  To install and use, you want the .noarch (or the .i386, etc.).

[Spencer Fornaciari]

Hey, I did exactly like Scott Smith on a fresh SME 5 install and when I went to
try it I got the following:

Error
MySQL said:


MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO)

I haven't dont any altering of mysql...any idea why this would be happening?
-Spencer

[Dan Brown]

You haven't told phpMyAdmin the MySQL root password.  Read the docs.

[Spencer Fornaciari]

I have read the docs...and thats because I was under the impression that the default password for root is nothing (from what i could gather in the mysql documentation)...and since I don't know how to set the password I was under the impression that would work.

[Dan Brown]

This has been discussed _many_ times here in the past; a search on "mysql root password" will find you many variations on the answer.  One of the answers is dated 9/23 by j-l boers.

[Spencer Fornaciari]

Yeah, and I followed the steps...input the password it had and still get an error (same error except with Password: Yes)...is it a different user other than root that I'm supposed to use or anything else that may be wrong?

[Dan Brown]

Are you sure you got the entire mysql password out of .my.cnf?  It wraps onto the next line, at least in pico.

[Spencer Fornaciari]

Yup, I got everything including the wrapped part and it still didn't work.  Also, I tried to change the password via mysqladmin and it didn't work for that either...it didn't recognize the whole thing for some reason.

[Spencer Fornaciari]

Nevermind...it came down to something as trivial as a 0 being confused with O...thankfully all is well now.

[IS]

I found the .my.cnf file in the root directory the password is composed with 3 letters and 3 numbers (not a big password ...).

When I use this password, I have the same problem as Spencer.
And when I use the same password when I use the shell "mysql -u root -p" I don't have problems...

But I don't know what'a appened with my phpMyAdmin ...