I have a dedicated server, In mySQL but I am missing the root user and I need a root user with full rights in mySQL.

I have a root server user and use SSH

I keep getting an error


GRANT ALL PRIVILEGES ON * . * TO 'admin'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

MySQL said: Documentation
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)


I was trying to make admin able to grant rights because no users have the grant option


Its kinda a catch 22.. I need to create a user have full rights but no user can create this user... Can anyone help


How do I create a root user that has full rights



Thank You