I’m attempting to resolve points created when my ISP moved my database from a shared server to devoted cloud storage. I’m reaching it remotely through SQLyog. They are saying they’ve given all privileges to all customers (I am the one person)

Issuing the sql

SHOW GRANTS

returns

GRANT ALL PRIVILEGES ON `my_database_name`.* TO 'myusername'@'my ip handle'

but when I attempt to create a person for my database utilizing command resembling

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

or

CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';

I get the error

Entry denied; you want (at the least one in every of) the CREATE USER privilege(s) for this operation

and if I attempt to see precisely what privileges I’ve utilizing

SELECT USER FROM mysql.db WHERE db = 'my_database_name';

I get the error

SELECT command denied to person 'myusername'@'my ip handle' for desk 'db'

I am unable to choose from a number of different system tables both, eg person

Ought to I be capable to do these items if I actually have ‘ALL privileges’?

How can I record precisely which privileges I’ve as an alternative of simply getting ‘ALL’ ?

Can anybody recommend a manner I can attempt to observe down what’s flawed?

BTW I do not know in the event that they executed flush privileges after doing the grant or not. would this have made a distinction on condition that SHOW GRANTS seems to indicate that I’ve all privileges?