I am using mySQL client to access mysql on another box. I cannot create database:
mysql> create database db1;
ERROR 1044: Access denied for user: 'scott@192.168.0.127' to database 'db1'
User 'scott@192.168.0.127' can perform other tasks except creating a database. Why?
Do I have to use the server box to grant scott authority for db1 which does not exist yet?
Thanks!