CODEWITHSUNDEEP
phpmysqldatabasedrupal
aneuryzm
aneuryzm

Reputation: 64834

Drupal, mysql server settings

I've a problem to configure database settings in Drupal. I will propose here some sample data:

Database Mysql:
Database: databaseName
User: user
Password: password
Server: server.com
Server Choice: mysqldb2 (in phpmyadmin I have this option and I can choose between mysqldb1 and mysqldb2 to access to the mysql server)

The error message I get is:

The mysql error was: Access denied for user: 'user@localhost' (Using password: YES).

I've tried the following lines in settings.php but I always get the same error message:

$db_url = 'mysql://user:password@localhost/databaseName'; 
$db_url = 'mysql://user:password@localhost/databaseName/mysqldb2';

The user and password work in phpmyadmin so I'm sure they are correct.

thanks

Upvotes: 0

Views: 2762

Answers (2)

lfx
lfx

Reputation: 1391

server.com? I think you must change localhost to server.com in your string.

$db_url = 'mysql://user:[email protected]/databaseName';

Upvotes: 0

Nir Levy
Nir Levy

Reputation: 4740

try:

$db_url = 'mysql://user:[email protected]/databaseName';

or

$db_url = 'mysql://user:password@mysqldb2/databaseName';

Upvotes: 1

Related Questions