1045 Access denied for user: '[email protected]' (Using passwor

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
I have a user that is getting the following error message when she runs her PHP script:

1045 Access denied for user: '[email protected]' (Using password: YES)

I have searched this forum for answers, and found a solution from back in 2001. I tried it, but it didn't work. Can anyone help me with a fix for this problem? :)
 

snowgod

Well-Known Member
Sep 23, 2001
70
0
306
What solution did you try?
 

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
I tried the suggestions mentioned here: http://forums.cpanel.net/read.php?TID=80

Of course, looking at that again I see that is not the same problem. That thread shows [email protected], not [email protected]

I just haven't worked with MySQL at all and am kind of lost.
 

snowgod

Well-Known Member
Sep 23, 2001
70
0
306
From the client's cpanel. Try adding and removing a mysql user. See if that helps.
 

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
I tried adding and deleting a couple of users via the clients control panel. Then I made sure the php script was using the user that I created, but I still get the same error message.

Any other suggestions?
 

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
Hi Andy,

Yes, I noticed that too. I tried adding the users from the control panel and made one as fhca_test, and fhca_rita (owner of the website's name) and then applied them to the database being called in the script. But each time I got the same error.
 

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
Hi Juanra,

Yes! I did that myself several times with 2 different usernames. And I made sure not only to create the user, but added it to the database. I still get the same error.
 

feanor

Well-Known Member
Aug 13, 2001
835
0
316
apologies if you'd tried this, but if you just recently upgraded your php build (from something pre 4.1.2) it might be that the new php config needs some more details in /etc/hosts, to find localhost....

Perhaps only for particular applications..... ?
It seems its picky

Anyway make sure /etc/hosts is updated as cpanel requires it
(/scripts/fixetchosts)


just making sure you'd seen that one.
 

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
Hi Fenor,

Thanks for the suggestion. I hadn't tried that, but I did just now and I still have the same problem.

When I upgraded to PHP 4.2.1 I noticed that it was compiled with some different options. I don't have a copy of what they were before the upgrade. Would there be any specific option that should have been included at the time of compilation?

Would it help to reload certain perl modules? If yes, which ones?

I used the /scripts/easyapache to upgrade, and I just used the Beginner option when prompted. Any other ideas? I also installed the Zend Optimized 1.3.0, and the newest version of Curl.

??? :p


BTW... Here is the script my client is using, and has been using for some time now. It broke after we upgraded PHP:


&head&
&title&Florida Assisted Living Affiliation Data Load&/title&
&/head&
&body&
&p& &h3&Load Test Data for FALA Member Search&/h3&&p&
&?php
$hostname=&localhost&;
$username=&fhca_rita&;
$password=&******&;
$db = mysql_pconnect($hostname, $username, $password);
if ($db == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&Hello, did not connect!!!!&br&$error $errmsg&);
} else {
$result = mysql_select_db(&fhca_org&,$db);
if ($result == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&Hello, did not select!!!!&br&$error $errmsg&);
} else {
$result = mysql_query(&load data local infile \&fala.txt\& replace into table fala fields terminated by \&;\&&,$db);
if ($result == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&Hello, did not load!!!!&br&$error $errmsg&);
}

}
}
$result = mysql_query(&select facid from fala&,$db);
if ($result == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&&br&Hello, did not count!!!!&br&$error $errmsg&);
printf(&&);
} else {
$rows = mysql_num_rows($result);
printf(&&br& $rows&);
}
?&
&/body&
&/html&
 

feanor

Well-Known Member
Aug 13, 2001
835
0
316
Dude, in all honesty this could go a variety of ways.

If you thing perl modules are at fault, definitely re-run
/scripts/cleanmd5
/scripts/fixinterchange
/scripts/installdbi

That forces the installs (or at least verifies) the perl module integrity for about 99.9% of the BIG DAWG modules that actually take care of most perl-related apps.

If you've got people that were using the mysql auth module for apache, perhaps that evaporated with your latest build.

Try reinstantiating that module in a rebuild?


Looking at the code at 12:42 AM makes me sleepy............................................................


ZZzzzzzzzzzzzzzzz ?
 

nitromax

Well-Known Member
Feb 12, 2002
189
0
316
How can You tell what MySQL was configured with???

Hi Fenor,

How can you tell what MySQL was configured with???

That script I showed on page one of this post uses the &load data infile& command. According to this page (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it looks like MySQL version 3.23.49 is automatically configured with the --enable-local-infile option.

But we have version 3.23.45 installed, and I don't know if that option if configured by default or not, or if the 1148 error message would be displayed for our installed version.

Does CPanel have a way of upgrading to the latest version of MySQL 3.23.51?

Thanks in advance...
 

bennet

Well-Known Member
Apr 25, 2002
68
0
306
Brazil
cPanel Access Level
Root Administrator
Same Problem

&$result = mysql_query(&load data local infile \&fala.txt\& ...&

Same Problem
I am with the same problem. See:

Grants goes [email protected]
GRANT USAGE ON *. * TO ' wakigawa' @ ' localhost' IDENTIFIED BY PASSWORD ' 4cf7fd99245dac2c '
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON wakigawa_school. * TO ' wakigawa' @ ' localhost'

The permission for this operation, it should include the grants FILE, it is not specified.
I don't also know as doing that, because I am reselling.