what's wrong with this mysql command ?

[viao12322]

I cannot access phpMyAdmin so I try to run the following command to build my tables thru cron:

mysql -hlocalhost -u<username> -p<password> <database> < /path/to/sql

But I get this error:

ERROR 1045 (28000): Access denied for user '<username>'@'10.33.249.7' (using
password: YES)

<username>, <password>, <database> all set properly in mysql

I wonder if mysql is configured properly, admin, please check.

 

[masshuu]

Is the user added to the database in cpanel?
All i can offer is to make a simple php script and check if the login details in fact do work.

 

[viao12322]

So, let's recap

I have one database, one user (viao123_root), who has all privileges to that database, set in cpanel.

1) phpMyAdmin gave me "Wrong username/password. Access denied."

2) mysql command gave me "ERROR 1045 (28000): Access denied for user 'viao123_root'@'10.33.249.7' (using
password: YES)"

3) my php script gave me "function.mysql-connect</a>]: Access denied for user
'viao123_root'@'10.33.249.7' (using password: YES)"

If it is not that the problem of the server, I don't know what it is.

Please, could some1 please check.

 

[masshuu]

Ok, one last thing i want you to do.
Can you delete the user and re create it?

 

[viao12322]

I have deleted all database and user and create new ones with different names. (database: viao123_auction, username viao123_admin)

phpMyadmin still gives the same error.

php script gives the same error

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'viao123_admin'@'10.33.248.80' (using password: YES) in /home/viao123/public_html/cron/pennycurl.php on line 4
Cannot connect to database.

Thanks

 

[masshuu]

I'm going to escalate this now so an admin can look into it and see if there is an issue.