Hello Have you tried using the MySQL client to connect? You'll need access to the server, either remote or locally. You can set it up so that you can access the MySQL via a different computer (you'll need mysql client installed, comes with MySQL, or you can grab it seperatly), or you ssh onto the server (assuming its linux, and you have access to it). The syntax is (in the command line) mysql -h <hostname - not needed if localhost> -u <username> -p hit enter, and then it will ask for your password. Enter it, and if you get in, its a problem with your script. If you cant, its a problem with the user define on mysql. HTH, Johnathon -- Johnathon Tinsley, Encryptec Limited Tel: 0845 25 77033, FWD: 753977 Email: jtinsley at encryptec.net, MSN: jtinsley at encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. ----- Original Message ----- From: Randal Rust <randalrust at gmail.com> To: thelist at lists.evolt.org Sent: 12 October 2006 17:39:12 o'clock GMT+0000 Subject: [thelist] MySQL User Problem I think that my understanding of what goes on in MySQL -- how users and permissions are managed -- is wrong. In the mysql.user table, I have defined a user... Host: localhost Username: dba Password: foo ...and granted all permissions to that user. Next, I have added this to the mysql.db table... Host: localhost Db: test_db User: dba However, when I try to connect (via ADODB and PHP), I continue to get this error: Access denied for user 'dba'@'localhost' (using password: YES) I am trying to set this up through PHPMyAdmin, but I don't know if that has anything to do with it. Usually, I have a control panel that I am using that walks me through this. However, on this particular site, the client is running their own server, sans a control panel. Where am I going wrong? -- Randal Rust R.Squared Communications www.r2communications.com -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !