mysql problem

[mike16889]

the other day i went onto my site and all of a sudden it started having MySQL errors.

i haven't changed anything since b4 the errors and after i cant work out why its not working the MySQL server is apparently down but i still have some functionality like i can log-in and the admin panel for my site is working fine but its all these errors

 Access denied for user 'mike1688'@'localhost' (using password: NO)

no one else seems to be having problems I'm starting to think some of my files got corrupted somehow...

can someone please help... im on the normal free server not sustained.

 

[Zenax]

Dunno if this would help.

Add a new user to the database with full permissions, then change the settings in PHP-Nuke to that Username and see if that makes it work??

Its a guess as I am not really a PHP/MY-SQL know it all

--
Zenax

 

[Micro]

if you create mysql usernames, they become yourcpanelusername_usernameyouchose

so my SMF one is,

leighto_smf

Where leighto is my cpanel username

and smf is the username i chose in the MySQL admin

 

[mike16889]

im using php-fusion not nuke

http must be down cos know i can't even get to my site or cpanel

and not rly related but smf rules!!!

 

[Zenax]

sorry, i got wrong one

bt that might help it might not

let us know how u get on

 

[Chris Z]

yup, Zenax is right, I had something happen to me like that, where i got on my site one day and it was giving me errors like that, and i just deleted the user and added it again, don't worry though, no data will be lost, it's all on the DB, but it's not the DB you delete, just the MySQL Username

 

[Zenax]

so basically the username just got changed or edited? or something?

 

[Aria5]

I have the same problem with my oekaki:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'xariax'@'localhost' (using password: NO) in /home/xariax/public_html/oekaki/index.php

It happened once before, but fixed itself after about a day. This time its been 2+ days.

Also, my forum works fine, and has a different mySQL account, so it's just the one I'm using for the oekaki.

I'll try what Zenax suggested.

--------------

Eep. That didn't work. I'm still getting the same errors.

 

[Micro]

Try creating another user, remember that xariax_mysqluser is the format for it.

 

[Aria5]

Try creating another user, remember that xariax_mysqluser is the format for it.

That didn't work either x.x

Anybody fixed theirs? Mines still dead. :/

 

[Brandon]

It looks like you never set a password for the script?

 

[dest581]

The error does say that there is no password submitted, but people were saying that it would happen after a time of it working. That makes me think it's a deeper user error.

 

[mike16889]

my username for i created is now muke1688_PTYPE

but it still gives the exact same error...

has MySQL been updated or something?

also i do have the password in the config file:

<?php

// database settings

$db_host="localhost";

$db_user="mike1688_PTYPE";

$db_pass="*******";

$db_name="mike1688_fusion";

$db_prefix="fusion_";

define("DB_PREFIX", "fusion_");

?>

 

[Micro]

In cPanel at the bottom have you assigned that user to the db?

 

[mike16889]

yes with all privliges

 

[Aria5]

In cPanel at the bottom have you assigned that user to the db?

Yes D:

I'm hoping it will fix itself when they're done editing the site. If not I'll delete the database :eek4: and start anew. ;-;

 

[subodh]

I am also getting the same error:

Access denied for user 'subodh'@'localhost' (using password: NO)

My site is also using phpfusion cms. I have set everything like other user with password and assigning rights to database.

 

[YamiKaitou]

Well, in your script, you have no password assigned or something. Also, the MySQL users are formated like this, cpanelusername_mysqlusername

 

[mike16889]

my config file (as above) is 100% correct with the details but the error still comes up as

Access denied for user 'mike1688'@'localhost' (using password: NO)

even thow the name in the config file is mike1688_PTYPE and the password is in there

 

[YamiKaitou]

The error shows that you are not using a password. You have to use the cpanelusername_mysqluser and the password for it to work