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
See reset root password in the manual. it will help you start mysql without the root user existing. you can then add one manually.
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)