Hi,
I tried to add the following user as root:
mysql> GRANT ALL ON testDB.* TO forum@'%' IDENTIFIED BY "password";
However, how come I cannot connect to testDB using my new user with a password? But without typing password, the connection is successful?
C:\mysql\bin>mysql -u forum -ppassword...