cPanel Hosting Stuff

1) Login to shell as root

2) And give the following commands :

a) mysql

b) use mysql

c) update user set Create_tmp_table_priv=’Y’ where Create_tmp_table_priv=’N';

d)update user set Lock_tables_priv=’Y’ where Lock_tables_priv=’N';

e) update `user` set Create_tmp_table_priv = ‘N’, Lock_tables_priv = ‘N’ where user <> ‘root’;

flush privileges;

e) quit

3) service mysql restart

MySQL and databases