Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: Warner 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.
-
The user to access phpmyadmin is "admin" and the password is your "root" account password.
-
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.
-
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.
-
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
-
Netscape message is:
The connection was refused when attempting to connect 127.0.0.1:980.
-
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.
-
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.
-
Oh I forgot that too, "HTTPS"
It needs to use the secure http, otherwise it won't work at all.
-
Been there. Done that. Still no go.
-
Tried that too. No good.
-
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.
-
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!
-
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?
-
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.
-
Nice try, but no. This is the same password that is in all the other configuration files.
I am almost glad to hear that I'm not the only one having this problem, but I'd prefer to have it resolved.
-
To log into phpMyAdmin from the browser, you need to use the admin id and password. I have installed it on a new 5.6 server, and it works flawlessly.
Des Dougan
-
I'm glad that worked for you. It has failed repeatedly for me. I've checked every instance of the password to make sure that the root password has not changed, I can log in from the Mitel Console, and it continues to fail the login process fromt he browser.
I'm beginning to think it might have something to do with upgrading rather than a fresh install.
-
Bruce,
I had the same problem as indicated in my earlier posting.
This is the way I fixed it. I am not saying that all the steps are required.
1) I did a password reset as desribed in the document below.
http://www.familybrown.org/howtos/mysql-password-howto.html
2) started mysql
[root@kobifix root]# mysql -u root mysql -p
Enter password:(here I entered the SME root password)
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23411 to server version: 3.23.49
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
3)grant the required privileges
mysql> grant all privileges on *.* to root@localhost identified by 'mysmerootpassword';
Query OK, 0 rows affected (0.00 sec)
(I am not sure if the admin is needed, most probably not)
mysql> grant all privileges on *.* to admin@localhost identified by 'mysmerootpassword';
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
[root@kobifix root]#
Remark: I am not a expert in mysql, may be there is a possibility that I broke a security role with the steps above. It would be nice to hear back form the experts.
Hope it works for you as well.
Best regards
jakob
-
This this well!
perfecT!
-
I found a quicker solution. The newest phpMyAdmin has released a later version in the last two weeks. I installed it according to the directions, and everything worked right away.
-
If anyone is still looking for a fix for this, realizing this thread is a couple of weeks old, I have the solution...
-
Hi there,
You said in the thread that you have a solution for this, I am having the same problem.
I know it was a long time ago, but if you know the answer that'd be great,
cheers,
Adam