I had a forum up for a couple of months (or at least quite a few weeks) on a Fedora4 pc. however, today when i tried to login (
http://ls2.xyz.com/forum) the browser just comes back with a screen that has:
Quote:MySQLi error: 1045
Access denied for user 'as_bb'@'localhost' (using password: YES)
Query:
using WebMin , I checked the User Permissions under MySql for user as_bb and it has All permissions from Any host. Host Permissions for the database is set to Any Hosts , All Permissions.
I checked the /etc/host file and it has:
127.0.0.1 ls2.xyz.com localhost
192.168.1.51 localhost ls2.xyz.com ls2
xx.yyy.221.79 localhost ls2.xyz.com ls2
Any help appreciated.
What host are you using? I had a similar problem w/ my old host, so I contacted them, and they fixed it for me.
The host is internal, in our LAN.
as an aside, rebooting did not help.
Try 127.0.0.1 for your server instead of localhost.
Something has changed...you just need to find out what. It's not mybb either.
Can you connect to mysql from ssh? Are you positive the daemon is running?
labrocca Wrote:Try 127.0.0.1 for your server instead of localhost.
Something has changed...you just need to find out what. It's not mybb either.
Can you connect to mysql from ssh? Are you positive the daemon is running?
from the command prompt:
/usr/bin/mysql -h ls2 -u as_bb -p worked
/usr/bin/mysql -h localhost -u as_bb -p
/usr/bin/mysql -h 127.0.0.1 -u as_bb -p
both fail with message of
"ERROR 1045 (28000): Access denied for user 'as_bb'@'localhost'
So , being desperate I went back and hacked at the /etc/hosts
Changing it to read:
Quote:# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
192.168.1.51 localhost ls2.xyz.com ls2
63.228.221.79 localhost ls2.xyz.com ls2
got mySql happy to use ls2.xyz.com, but not localhost.
Which actually works for our situation
But - I would like to know how to get it so that localhost or ls2.xyz.com would work equally as well.
How many MySQL servers do you run? Anyway, the error suggests that the username and password combination are incorrect. Please amend in /inc/config.php
You need this line added to your hosts file.
127.0.0.1 localhost ls2.xyz.com
That SHOULD be appropriate.
Also after changes make sure to restart the network daemon and maybe even BIND.
ct2k7 Wrote:How many MySQL servers do you run? Anyway, the error suggests that the username and password combination are incorrect. Please amend in /inc/config.php
Only one and the combination is correct.
labrocca Wrote:You need this line added to your hosts file.
127.0.0.1 localhost ls2.xyz.com
That SHOULD be appropriate.
Also after changes make sure to restart the network daemon and maybe even BIND.
nope, that breaks it. Neither name works with that setup.
The problem is the 127.0.0.1 ip address evidently.
Are you running firewall rules?