mySQL get root

Databases
1

Sorry no one responded earlier. 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

2

See reset root password in the manual. it will help you start mysql without the root user existing. you can then add one manually.

3

Did you try to log in to the mysql console as root? by default there should be no root password. So, just type on SSH:

mysql -u root -p (and press ENTER where you will be asked for password)