Using PhpMyAdmin on XAMPP, I want to add a super user that has the same privileges as 'root'@'localhost'.
This is because I want to create a MySQL instance that my local machine will serve as a remote database server.
You can see the grants of root by executing "show grants for 'root'@'localhost';". This command will give you some output similar to this:
Then you can simply replace the username/password/host out of the shown grant query, for example like this:
This should create a user 'anotheruser'@'%' with the specified password, and give it the same rights as 'root'@'localhost' has.