mysql username help!

I've just installed MySQL server and client on my Redhat Linux 9 server and I accidentally deleted all the usernames including "root" via Webmin, and now I can't manage the database because it requires root login:

Webmin needs to know your MySQL administration login and password in order to manage your database. Please enter your administration username (usually root) and password below.
I tried my root login, but it won't work. Any ways to go around this, adding new usernames to manage the database, via SSH or Webmin?

Thanks in advance.

 

 

 

 

Top