Access Denied Error message for da_admin

[DanB]

I need a little help with this error message when I click on MySQL Databases in the user panel:

Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES)

The user da_admin is configured; as I can see it and access
it in PhpMyAdmin:

Welcome to phpMyAdmin 2.5.0 - MySQL 4.0.14-standard running on localhost as da_admin@localhost

Looking in the privileges area, I see da_admin has all the global permissions.

The user has available databases to be used.

Thanks for any suggestions.

Dan

[ProWebUK]

Have you just upgraded it?

If so,

pico -w /var/www/html/phpMyAdmin-X.X.X

(replacing x.x.x with the actual version, or if the upgrade is set to just phpmyadmin use that)


replace the config type from "config" to "http"

Chris

[DanB]

Nope on the upgrade, except for the periodic updates for RH9 and DA, nothing has been upgraded or modified since the DA staff did the install.

Looking through the file /var/www/html/phpMyAdmin-2.5.0config.inc.php

is this the area you're referring to:
$cfg['Servers'][$i]['auth_type'] = 'http';



Dan

[ProWebUK]

Try a fresh install:


wget http://www.l0rdphi1.com/junk/update.phpmyadmin.sh
sh update.phpmyadmin.sh
perl -pi -e 's#phpMyAdmin.\..\..#phpMyAdmin#g' /etc/httpd/conf/httpd.conf
service httpd restart


(Check your new phpmyadmin folder in /var/www/html is named phpMyAdmin)


The default settings should be fine, you should have no problems with just hitting enter for everything when running update.phpmyadmin.sh

Also, check MySQL is running!

After its installed, make sure the option mentioned in the previous post is set to http (in the new versions config)

Chris

[ProWebUK]

Or you could use the official DirectAdmin script...

/usr/local/directadmin/scripts/phpmyadmin.sh

Chris

[DirectAdmin Support]

Hello,

Try logging in with the data stored in /usr/local/directadmin/conf/mysql.conf
mysql -uda_admin -p
password: passwordIf you can't get in using that, then the da_admin account isn't setup. You need to login to mysql as root and run the following:
GRANT CREATE, DROP ON *.* TO da_admin@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;The mysql password should be stored in /usr/local/directadmin/scripts/setup.txt, or else you'll you'll need to restart mysql with the --skip-grant-tables option so you can login without a password.

John

[DanB]

John,

Your suggestion worked. But thanks to Chris
also for his input.

Dan

[alert3ff]

I did it and still no dice... same error.

[HeRCuL70]

i did it but still the error what can i do?

[jmstacey]

Have you actually followed the instructions provided here: http://help.directadmin.com/item.php?id=45
as well as made sure that MySQL is actually running? Do any other accounts work?

[Chezmoi]

I have the same problem and I don't understand a thing about what iso n this web page: http://help.directadmin.com/item.php?id=45

I don't know where is /usr/local/directadmin/scripts/setup.txt is, and I don't know how to fix the problem.

The page talks about doing things I don't even understand... Like: "1) Make sure the root mysql password works. If you know it, skip to 2). The mysql root password can be found in the /usr/local/directadmin/scripts/setup.txt if it has not been deleted. It's under the header "mysql=". If it cannot be found, then mysqld will have to be restarted with the --skip-grant-tables option:

service mysqld stop (Redhat)
mysqld_safe --skip-grant-tables &" To me this is close to chinese.

Anyone would like to give me some easy-to-follow steps to solve my problem?

Thank you!

[Chezmoi]

Wait a minute... I don't have the same exact problem...

My problem is when I try to install my .php

-----

A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: 'user_name@xxx.xx.xx.xx' (Using password: YES)

Please click on the Back button below to review your database server settings.

If you require help with your database server settings, please consult your hosting company.---

Any idea?

[youds]

For gods sake. Are we sure it is using "password" as the password? If so why but that's another question

MySQL is running, going to directadmin/custombuild and doing ./build roundcube produces errors


ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)


The following has been done:


mysql> GRANT CREATE, DROP ON *.* TO da_admin@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT CREATE, DROP ON *.* TO da_admin@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)


Obviously....[root@jupiter-ilo custombuild]# service mysqld status
MySQL running (2941) [ OK ]

[youds]

Just seen the KB article. Ignore me! hah