Well first thing i would do is check if premissions have been set, you can use MySql Administrator or from command line:
From command prompt:
go to mysql/bin directory
login using admin account, to login :
mysql -h host -u username -p;
-----> will prompt for password, if default installation then just hit enter.
check user privilages:
mysql> SHOW GRANTS FOR os@localhost;
os= change with user name
localhost = servername
if it gives error then you can use command line to create account for user:
mysql> grant all privileges on database.* to username@"servername" identified by 'password';
Else it will display something like this
: where "oscom" is the name name of database on which user has rights.
+-------------------------------------------------------------------------------
------+
| Grants for oscom@localhost
|
+-------------------------------------------------------------------------------
------+
| GRANT USAGE ON . TO 'os'@'localhost' IDENTIFIED BY PASSWORD '3e8fad3b02bb
d756' |
| GRANT ALL PRIVILEGES ON oscommerce.* TO 'os'@'localhost'
|
+-------------------------------------------------------------------------------
------+
In this case you might have problem with Password Hashing. For detail description check this link:
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
good luck
