how to create a user in mysql 5.1 with all permissions?

Question

I want to create a user with permission to create database, import mysqldump files, create tables?

What is the command for that?

Thanks

Answer 1

Short answer: in the MySQL client, run the following:

GRANT ALL PRIVILEGES ON *.* to username@hostname_or_ip identified by 'password';

Longer answer:

There is really excellent documentation in the MySQL Reference Manual on this topic. Take special note of the chapter on User Account Management.

Answer 2

GRANT ALL ON *.* TO username@"%" IDENTIFIED BY "password";