I decided to reinstall my database. I established the an empty database "moodle" via PLSK (I was unable to do it via commend line somehow) and have the database user name (say A1) and password (say A2) setup. Then I typed the following commends:
#>mysql -u A1 -pA2
mwsql>grant select,insert,update,delete,create,drop,index,alter on moodle.* to A1@localhost identified by 'A2';
I got the error message:
#1044 - Access denied for user: 'A1@localhost' to database 'moodle'
I though that if I can go from the promp '#>' to 'mysql>', I must have the correct username (-u) and password (-p), why the access be denied? confused.