PHPMyADMIn issues

[halohub1]

Hi there,

I am trying to give a db user for MySQL privileged permissions by running this code.

grant all privileges on chinkych_gpstracker.* to chinkych_DBUser@localhost identified by 'MAIN HOSTING ACCOUNT PASSWORD';

to which it throws back this error

#1044 - Access denied for user 'chinkych'@'localhost' to database 'chinkych_gpstracker'

How has my root account not got access?

 

[Dead-i]

Hi halohub1,

You should be able to manage your database users' privileges from within cPanel rather than using MySQL commands. In your cPanel, please go to MySQL Databases, and then assign your database user to your database. You will be asked what permissions you would like to grant.

Thank you,

 

[halohub1]

I have selected all permissions in cPanel, but I am still getting errors when importing a SQL file these are the errors



DELIMITER ;;
CREATE DEFINER=`chinkych_DBUser`@`localhost` PROCEDURE `prcDeleteRoute`(
_sessionID VARCHAR(50))
BEGIN
DELETE FROM gpslocations
WHERE sessionID = _sessionID;
END ;;



MySQL said:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 

[halohub1]

Please see image

 

[caftpx10]

The error has the hint, your MySQL account does not have SUPER privileges (quoting from phpMyAdmin).