Restoring all rights for root I have root access to the database on VPS, however it looks like root has no rights.

When I tried to create a database, it said :'user 'root' access denied to database..'

When I wanted to select users from mysql.users it said 

'SELECT command denied to user 'root'


I wrote 'SHOW GRANTS', it gave 
'GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD &lt;secret&gt;' in 'GRANTS FOR 'root@%'' column

Ideas?
How are you connecting?  Is the client on the same machine?  Same client?  You seem to be coming in from a different machine.  % is the world; you do not want root to get in that way.

If this is a Cloud setup, you were probably told what IP address to come in from, and that may be the only way to come in.

We need to know who set up your access and the details (except password).