Create database and database user with all permissions.

Creating a database with a user that have a all permissions. This sort of task is usually necessary in order to run your own web applications.

CREATE DATABASE testdatabase;
CREATE USER testuser@localhost IDENTIFIED BY 'testpassword';
GRANT ALL PRIVILEGES ON testdatabase.* TO testuser@localhost;
FLUSH PRIVILEGES;
exit

Add your comment