MySQL Forums :: Newbie :: MySQL users question


Advanced Search

MySQL users question
Posted by: Michael Ho ()
Date: June 06, 2011 08:24AM

I am trying to create a new user for my new MySql database (press_db) under my CentOS server (Server have CentOS and MySQL installed on it only)

So from the command line I wrote:

> CREATE USER 'dbuser1'@'localhost' IDENTIFIED BY 'password_here';
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON press_db.* TO 'dbuser1'@'localhost';

and to make sure the user was created I executed the command:
> select user from mysql.user;

but I found that there was 2 'empty' records and also 3 records where the user field = 'root'....so I was wondering, does this mean that my server was hacked where someone added more 'root' users to the table? and if yes how I can distinguish between my original 'root' user and the hackers 'root' user in order to remove their?

Last question, is there a MySQL command where I can test logging to my database using the new user name / password in order to make sure I the new user name / password are working?

Thanks in advance for your time

Options: ReplyQuote


Subject Written By Posted
MySQL users question Michael Ho 06/06/2011 08:24AM
Re: MySQL users question bruce zuo 06/06/2011 11:17PM
Re: MySQL users question Michael Ho 06/07/2011 08:45AM
Re: MySQL users question Rick James 06/07/2011 10:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.