MySQL Permissions Error - Access Denied

Using joomla

[puteri nur85]

please anybody of u please help me to solve this problem.

i don't know what happen.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql_user'@'localhost' (using password: YES) in C:\AppServ\www\mangrove\database.php on line 2
Could not connect: Access denied for user 'mysql_user'@'localhost' (using password: YES)

i just want to do the database, i use joomla, so i wanted to do the database inside the joomla.

can you show me what i must do if this error appear again.

please help me,
i'm student Bioinformatics from malaysia

[justageek]

You do not have permissions so the user does not exist or does not have the proper table permissions or the password is wrong.

JAG

[cmarshall]

Welcome to WebmasterWorld, puteri nur85!

As JAG said, it is a permissions error.

I'll expand on that a bit.

When you set up a database, you also need to establish a MySQL user to access the database. I'm not familiar with setting up Joomla, but I have set up many other CMS systems. They all require this user and password.

When you create the user (using MySQL), you need to assign permissions for the table to that user.

Most CMS systems require that the DB user have the DATA and STRUCTURE suites enabled:

Data:
SELECT
INSERT
UPDATE
DELETE
FILE

Structure:
CREATE
ALTER
INDEX
DROP
CREATE TEMPORARY TABLES
CREATE VIEW
SHOW VIEW
CREATE ROUTINE
ALTER ROUTINE
EXECUTE

Make sure that the MySQL user you gave to Joomla has all these permissions turned on for the database you are using for Joomla.

Discussion continues here: [webmasterworld.com...]

[edited by: eelixduppy at 8:38 pm (utc) on Mar. 8, 2007]