Users & mySQL User

[H. Bartel]

Hi,

I have installed mySQL-Server on my freeBSD 4.8, and now I want to set it up. I can connect to the database with root at localhost and the according password, but I would like to add another user, which would then only be used to connect to the database server.
Does this need to be another user on my system, or just an "internal" mySQL User? Any hints on how to set this up?

Thanks, Holger