Pls webmasters in the house, first of all, i have two sites that are using same database,anything i edit in the home page on one, affects the other. Now i want to separate the database, unfortunately, in the process, i revoked the admin user of my database in my cpanel. Since then, my site cannot open. It always say' server cannot connet to database of mysql'. Pls how can i reverse dat pls.

.

Create a new user, and assign priviledges. And as well, change the username and password in your script that connects to the database.
Then you could goto your error logs to find out more.

What then happened to data on the other username i invoked

Its still intact. Since the only thing u did was revoke the admin username, it shouldn't affect the database data.