Excume people, but I have this question How Can I Create a New User in MySql?. I work like root, but I like create another user. If somebody knows how make this, please say me the instructions. Thanks.
The following section of the manual shows the two ways to add users:
http://www.mysql.com/doc/A/d/Adding_users.html
GRANT is preferred, though I established the bad habit of using INSERT INTO and can't seem to shake it 🙂
Curt
agreed =)
grants/revokes would be a lot nicer if they ignored errors (revoking permissions that the user doesn't have) and would revoke table & column level permission.
