Ad:

MySQL Discussion Thread
Marked Solved
Views: 21752

Jun 27th, 2008

Check if user exists

Expand Post »

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?

Similar Threads

Validating a User Imput with SQL Database (Login) in C#
Is there any problem wid ths code? in PHP
Storing if a user has viewed a post in Database Design
Determine if session exists in PHP
Can Someone please check my project & comment/tips in C

tuse

Reputation Points: 32

Solved Threads: 14

Junior Poster

Offline

173 posts
since Jul 2007

Permalink

Jun 27th, 2008

Re: Check if user exists

MySQL Syntax (Toggle Plain Text)
 SELECT user FROM mysql.user WHERE user='  ';
 select user from mysql.user where user='  ';

you should have access to mysql DB to execute the query

varmadba

Reputation Points: 22

Solved Threads: 9

Junior Poster in Training

Offline

83 posts
since Jun 2008

Permalink

Jun 27th, 2008

Re: Check if user exists

Thanks a lot.

Didn't see the 'mysql' database.

tuse

Reputation Points: 32

Solved Threads: 14

Junior Poster

Offline

173 posts
since Jul 2007

Permalink

Jun 27th, 2008

Re: Check if user exists

Hi tuse

How are you?

Click to Expand / Collapse Quote originally posted by tuse ...

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

Last edited by tesuji; Jun 27th, 2008 at 7:08 pm.

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

Permalink

Jun 28th, 2008

Re: Check if user exists

Hi tesu!

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

tuse

Reputation Points: 32

Solved Threads: 14

Junior Poster

Offline

173 posts
since Jul 2007

Permalink

Dec 6th, 2011

better way

MySQL Syntax (Toggle Plain Text)

mysqladmin -u 'user' -p 'password' status

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

Offirmo

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Dec 2011

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Crystal reports for SQL Database

Next Thread in MySQL Forum Timeline: Add Image to mySQL from vb.net

DaniWeb Message

Cancel Changes

User Name
Password