Access Denied Error message for da_admin

D

DanB

Verified User
Joined
Oct 14, 2003
Messages
22
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
 
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
 
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
 
Try a fresh install:

Code: 
wget [url]http://www.l0rdphi1.com/junk/update.phpmyadmin.sh[/url]
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
 
Or you could use the official DirectAdmin script...

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

Chris
 
Hello,

Try logging in with the data stored in /usr/local/directadmin/conf/mysql.conf
Code: 
mysql -u[b]da_admin[/b] -p
password: [b]password[/b]
If 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:
Code: 
GRANT CREATE, DROP ON *.* TO da_admin@localhost IDENTIFIED BY '[b]password[/b]' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY '[b]password[/b]' 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
 
John,

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

Dan
 
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!
 
Last edited:
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: '[email protected]' (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?
 
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

Code: 
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:

Code: 
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....
Code: 
[root@jupiter-ilo custombuild]# service mysqld status
MySQL running (2941)                                       [  OK  ]
 
You must log in or register to reply here.
Back
Top