Giving a user full permissions in MySql is pretty simply task, as long as you have access. To do so, all you need to do is log into the MySql server that the database is housed on/at. Once there enter MySql by typing;
mysql
In some cases, such as running a control panel, you will need to use the following syntax to apply a password;
mysql -uadmin -p (it also might be mysql -uroot -p)
This should open a command prompt. Now you need to type;
GRANT ALL ON [database].* TO [username]@’%’ IDENTIFIED BY ‘[password]‘;
So basically substituting [database] with the database name, [username] with the person’s new username, [password] with the specified password. If you see no rows affected, replace [username]@’%’ with [username]@’localhost’ .
Then after this, type;
FLUSH PRIVILEGES;
Thats it! The user is added!
