Member Avatar for tuse

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?

  • 4 Contributors
  • 5 Replies
  • 1K Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by Offirmo
Member Avatar for varmadba 
select user from mysql.user where user='  ';

you should have access to mysql DB to execute the query

commented: Thanx +1
Member Avatar for tuse

Thanks a lot.

Didn't see the 'mysql' database.

Member Avatar for tesuji

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

commented: oops...i was supposed to give you green rep last time +1
Member Avatar for tuse

Hi tesu!

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

Member Avatar for Offirmo 
mysqladmin -u 'user' -p 'password' status

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.