grant all rights to a user code example Example: grant user all privileges mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';