GRANT ALL ON elgg.* to elgg;

You granted privileges to the user "elgg", not "admin"

Thanks Cash, I changed the grants with

GRANT ALL ON elgg.* to admin;

but the issue is still present.

The file settings are correct ?

I have to install MySQL in the same path of Elgg ?

Google how to create a user and add privileges. There are plenty of tutorials out there. I think you have an issue with not including the host for the user.

I changed it, I dropped the user admin and re-created it in this way

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin';

now I have another issue

Elgg couldn't select the database 'elgg', please check that the database is created and you have access to it.

You can create the user on the fly. Try this

1. use mysql;
2. create database elgg;
3. GRANT ALL PRIVILEGES ON elgg.* to admin@localhost IDENTIFIED BY 'admin';
4. flush privileges;

You might also want to add an underscore in Elgg's settings.php in this line:

$CONFIG->dbprefix = 'elgg_';

If it still doesn't work, your mysql server might not be accessible at all. Have you tested, if the server is accessible in general?

I tried to grant all privilege on the user admin (also with MySql Server Access Management) but the issue is still

Elgg couldn't select the database 'elgg', please check that the database is created and you have access to it.

Any other ideas ?

how can I test if the server is accessible in general ?

I have just tried with SQLDeveloper and the DB elgg is accessible.

So there is something wrong in the settings file...please help!!!!

Hi I am having problems here too, on apache.

@sugarplum:sorry we didnt understand that. the settings.php page should look like below

/**
 * The database username
 *
 * @global string $CONFIG->dbuser
 * @name $CONFIG->dbuser
 */
$CONFIG->dbuser = 'username';

/**
 * The database password
 *
 * @global string $CONFIG->dbpass
 */
$CONFIG->dbpass = 'password';

/**
 * The database name
 *
 * @global string $CONFIG->dbname
 */
$CONFIG->dbname = 'database_name';

/**
 * The database host.
 *
 * For most installations, this is 'localhost'
 *
 * @global string $CONFIG->dbhost
 */
$CONFIG->dbhost = 'localhost';

/**
 * The database prefix
 *
 * This prefix will be appended to all Elgg tables.  If you're sharing
 * a database with other applications, use a database prefix to namespace tables
 * in order to avoid table name collisions.
 *
 * @global string $CONFIG->dbprefix
 */
$CONFIG->dbprefix = 'prefix_';

I have that experience as you guys mentioned above:

Fatal Error.
Elgg couldn't connect to the database using the given credentials. Check the settings file.

I don't know why I experience it because I haven't done any changes since it was running with no error. The error appeared only after I have a few people signing in to my site with their Facebook accounts that I have installed Facebook API mod.

I was a bit nervous and run upgrade.php then the error disappeared. But I'm concern about this error will come up again anytime soon or often. It would be greatly appreciated if anyone could advice about further information on that error and how to fix it.

Thank you.