Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: cvlcc on September 14, 2007, 10:19:10 AM
-
I have smeserver-phpmyadmin-multiuser-2.10.2-1.noarch.rpm installed on my server 7.0.
I get this error: Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
When I log into the root of the server I have no problem. But when I try to log into Welcome to phpMyAdmin 2.10.2 using admin or root I get this error. It is not accepting my Passwords from on the same network
I went to /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminmultiAlias
and got this in the file:
# Administration: phpMyAdmin
<Directory /opt/administration/phpmyadminmulti>
SSLRequireSSL on
Options -Indexes
AllowOverride None
order deny,allow
deny from all
{
my $phpmyadminaxs = $phpmyadminmulti{'access'} || "private";
if ($phpmyadminaxs eq "private")
{
$OUT .= " allow from $localAccess $externalSSLAccess";
} else {
$OUT .= " allow from all";
}
}
Satisfy all
AddType application/x-httpd-php .php .php3
php_flag magic_quotes_gpc on
php_flag track_vars on
</Directory>
<Directory /opt/administration/phpmyadminmulti/scripts>
SSLRequireSSL on
Options -Indexes
AllowOverride None
order deny,allow
deny from all
allow from { "$localAccess $externalSSLAccess"; }
AuthName "phpMyadmin Scripts (Admin)"
AuthType Basic
AuthExternal pwauth
require user admin
Satisfy all
AddType application/x-httpd-php .php .php3
php_flag magic_quotes_gpc on
php_flag track_vars on
</Directory>
<Directory /opt/administration/phpmyadminmulti/libraries >
order deny,allow
deny from all
</Directory>
How do I fix this? A line by line from the root prompt please.
Also is it possible to up grade to PHP 5.2.4 on RHEL and CentOS with no problems?
-
I have smeserver-phpmyadmin-multiuser-2.10.2-1.noarch.rpm installed on my server 7.0.
I get this error: Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
When I log into the root of the server I have no problem. But when I try to log into Welcome to phpMyAdmin 2.10.2 using admin or root I get this error. It is not accepting my Passwords from on the same network
The password on the SME Server shell is entered by a clever trick that automatically looks up the password in a file on your system when you are logged in as root user. This trick does not work when you login from other things than the SME Server shell.
The admin user is not configured for MySQL access by default. AFAIK it is normal practice to configure MySQL users yourself, this is not done by the system itself, and passwords are not synced either as MySQL does not use PAM, LDAP or anything else that it's own user database.
If you read this page in the wiki you find how to log in as admin: http://wiki.contribs.org/Phpmyadminmulti .
To configure MySQL access for certain users have a look at the wiki: http://wiki.contribs.org/MySQL
-
Well I removed the old smeserver-phpmyadmin-multiuser-2.10.2-1 and installed the new phpMyAdmin 2.11.0 and got the same problem. I followed the instruction exatly! I can see the login I put under Username:admin and Password: XXXXXXX I still get the error
Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
-> --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
-> --execute="flush privileges"
-> --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
-> --execute="flush privileges"
-> \q
Bye
[root@xxxx ~]#
Do I need to set a password for admin@localhost?
I just Don't seem to get right
Awating Your Reply
Thank You