How do I grant full permissions to a mysql user? Im running MySQL 5.1 on Redhat. I tried using cpanel, but when I use jet profiler it says I do not have full permissions.
I am not too good with ssh, so please be detailed.
From the shell connect to MySQL as an administrator:
Now on the mysql prompt type:
You can read more about GRANT's syntax at MySQL's site.
You mention that you're using Cpanel, which usually indicates that you're on a shared hosting server in which case you won't be able to grant full permissions.
If you're not though, then you need to run a SQL command.
You can do this through PHPMyAdmin or through a MySQL client over ssh.
The query you need to run is: GRANT ALL PRIVILEGES TO username@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
To do this through PHPMyAdmin, select any database and then click on 'SQL' tab in the main window. You can then type it from there. Although in fact if you're using PHPMyAdmin there's a "Privileges" section that you can use rather than running an SQL query.
If you're using command line, then connect over SSH.
Then, run the following command: mysql -u [username] -p
This will drop you into an interactive MySQL prompt and you can paste the queries as above.
Just insert or update mysql.user with value 'Y' in each column privileges.