1,105,644 Community Members

Check if user exists

Member Avatar
tuse
Junior Poster
174 posts since Jul 2007
Reputation Points: 22 [?]
Q&As Helped to Solve: 14 [?]
Skill Endorsements: 0 [?]
 
0
 

I need to check if a databse user exists and if not, create that user.

However, I do not know the statement to check if a user already exits.

How to check if a user already exists in MySQL?

Member Avatar
varmadba
Junior Poster in Training
83 posts since Jun 2008
Reputation Points: 12 [?]
Q&As Helped to Solve: 9 [?]
Skill Endorsements: 0 [?]
 
1
 
select user from mysql.user where user='  ';

you should have access to mysql DB to execute the query

Member Avatar
tuse
Junior Poster
174 posts since Jul 2007
Reputation Points: 22 [?]
Q&As Helped to Solve: 14 [?]
Skill Endorsements: 0 [?]
 
0
 

Thanks a lot.

Didn't see the 'mysql' database.

Member Avatar
tesuji
Master Poster
721 posts since Apr 2008
Reputation Points: 135 [?]
Q&As Helped to Solve: 98 [?]
Skill Endorsements: 0 [?]
 
1
 

Hi tuse

How are you?

Thanks a lot.

Didn't see the 'mysql' database.

Well, if you had access to grant table mysql.user you would have also been able to
SELECT User, Password FROM mysql.user. You got it? Yes, you would be able to hack that
mysql database. So it's a good idea that not everybody is allowed to "see" grant table.

Happy hacking !

krs,
tesu

Member Avatar
tuse
Junior Poster
174 posts since Jul 2007
Reputation Points: 22 [?]
Q&As Helped to Solve: 14 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi tesu!

I have (somehow) managed to see the mysql database!

Question Answered as of 5 Years Ago by tesuji and varmadba
Member Avatar
Offirmo
Newbie Poster
1 post since Dec 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 
mysqladmin -u 'user' -p 'password' status

this function returns 0 and a line if the user exists, !0 else.

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article