mySQL - local user privileges
 

MySQL only lets me play with databases only as root, although I can create new servers using a local user.

mysql> create database amir;
ERROR 1044: Access denied for user: '@localhost' to database 'amir'

the thing is I dont know how to go about adding any new users. Id also rather not have to use a login name and password whenever i start the mysql client from a local (unprivileged) user.

Users that can create databases are not unpriiledged ...

Read this

thanks, what i meant by unprivileged was non root user, not unprivileged in mysql, i wanted the user to unprivileged user but privileged in mysql :S