Koozali.org: home of the SME Server

phpMyAdmin access

Warner

phpMyAdmin access
« on: February 23, 2003, 06:27:41 AM »
Search as I may, I have yet to find the solution. I'm a newbee when it comes to PHP and MySQL, so I might just be doing something totally wrong, but . . .

I've made sure the password for ROOT is the same system wide. I've created a user from the MySQL server console that has all priviledges. I've displayed the user's name in the user database, but I still can't seem to log into phpMyAdmin from the workstation browser (neither IE or Netscape). All I get is an Authorization Required Error page after three attempts.

If anyone has gotten this to work on 5.6, I'd really appreciate a straight forward step-by-step solution.

eric

Re: phpMyAdmin access
« Reply #1 on: February 23, 2003, 09:52:32 AM »
The user to access phpmyadmin is "admin" and the password is your "root" account password.

Warner

Re: phpMyAdmin access
« Reply #2 on: February 23, 2003, 05:32:03 PM »
That's a big step closer. At least there's some indication that the user is recognized. Now it says "The page cannot be displayed" after entering the login information. I've entered both "localhost" and "192.168.1.1" (internal LAN address) for the value of $cfgServers[1]['host'] value.

Dan Brown

Re: phpMyAdmin access
« Reply #3 on: February 23, 2003, 07:43:06 PM »
I'd keep the hostname at 'localhost'.  Could you try with mozilla or netscape?  IE's error messages are pretty much useless.  Might also want to take a look at apache's error log.

Warner

Re: phpMyAdmin access
« Reply #4 on: February 23, 2003, 11:16:38 PM »
The errors are as follows:

boot.log
Feb 23 09:44:51 Athelon mysql: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Feb 23 09:44:51 Athelon mysql.init: Loading 30mysql.create.horde.sql into mysql failed

The only message that appears to be Apache specific in any of the log files is in the error_log, which contains:
[Sun Feb 23 11:35:50 2003] [notice] Apache configured -- resuming normal operations

Warner

Re: phpMyAdmin access
« Reply #5 on: February 24, 2003, 12:40:10 AM »
Netscape message is:

The connection was refused when attempting to connect 127.0.0.1:980.

Mntsnow

Re: phpMyAdmin access
« Reply #6 on: February 24, 2003, 11:04:37 AM »
You are trying to get in using the this format correct? (notice the https)

https://servername/phpMyAdmin/

then login with  "admin" and your root password.

Mntsnow

Re: phpMyAdmin access
« Reply #7 on: February 24, 2003, 11:04:37 AM »
You are trying to get in using the this format correct? (notice the https)

https://servername/phpMyAdmin/

then login with  "admin" and your root password.

eric

Re: phpMyAdmin access
« Reply #8 on: February 24, 2003, 05:34:04 PM »
Oh I forgot that too, "HTTPS"

It needs to use the secure http, otherwise it won't work at all.

Warner

Re: phpMyAdmin access
« Reply #9 on: February 26, 2003, 03:31:17 AM »
Been there. Done that. Still no go.

Warner

Re: phpMyAdmin access
« Reply #10 on: February 26, 2003, 03:32:32 AM »
Tried that too. No good.

Jakob Strebel

Re: phpMyAdmin access
« Reply #11 on: February 26, 2003, 01:07:05 PM »
Bruce,
I did install phpmyadmin as well on 5.6 nd have the same problem as you. Is there anybody which has it installed trough rpm?

The install.sh gave me a very long password back wich comes out of /etc/ldap/

Are we talking about the same password?
I have tried with this and my "server password"

jakobWarner wrote:
>
> Tried that too. No good.

Warner

Re: phpMyAdmin access
« Reply #12 on: February 26, 2003, 03:09:08 PM »
I've tried the standard password, the admin password, the console password, and to no avail. I did end up installing mambo CMS, and it works fine (still in testing state), except when I try to access phpMyAdmin. Go figure!

Pedro

Re: phpMyAdmin access
« Reply #13 on: February 26, 2003, 03:14:40 PM »
just installed phpmyadmin using the rpm at http://myezserver.com/downloads/mitel/contrib/phpmyadmin/

I get the same problem:


Welcome to phpMyAdmin 2.3.3pl1

Error

MySQL said:

Access denied for user: 'root@localhost' (Using password: YES)


what to do?

Thor Anthrax

Re: phpMyAdmin access
« Reply #14 on: February 26, 2003, 06:50:07 PM »
Did you change the MySQL roto password?

If so, change the file /etc/openldap/ldap.pw and update the password. That is where the rpm grabs its password from.