Late update on this resolution... I'd stored the password in MySQL Workbench, and so hadn't been typing it in for a while. My host changed the password a while back. I updated it in Workbench, but never got rid of the original e-mail... short version, I was using the wrong password to try to connect.

The server name was specified as the server name (which is sql2.domainname .com). The return of the statements is below (first is with the vweb2 host, second is without. I'm not sure where the vweb2 is coming from, unless it is an internal network DNS name that is being applied by the server.

SHOW GRANTS FOR 'cars2'@'VWEB2'
Error Code: 1141
There is no such grant defined for user 'cars2' on host 'VWEB2'

If...

The user cars2 is the user account that my Magento installation uses to connect to the very same database from the very same server. Ergo, it has the appropriate permissions at the database level. This is a new table in the existing database.

I am getting the below error when attempting to run a php script on my server which accesses a mysql table I have created in an existing database. I can connect to the database table via the MySQL workbench, but not via a php script I have written. This database was originally created for use with Magento Cart, which I have installed and which works correctly (can access it's database tables). I simply cannot access the database with a separate...