Really, all my years as a programmer, I've been dealing with GUI stuffs. Pls answer this:
for example on nairaland, is this how users are created? eg
CREATE USER 'logicalhumour'@'nairaland.com' IDENTIFIED BY 'omega123ova';


Before something like
GRANT SELECT, INSERT, UPDATE ON nairaland_db.user_db TO 'logicalhumour'@'nairaland.com';


Is this how it's done?.
Thanks.

Yes it is

bigtt76:
Yes it is

Thanks... but is that how real websites do it?

@logicalhumour I suspect you're trolling but I'll answer your question in the off chance that you're not.

That is how you create a user in mysql but not quite in the same sense as creating a user account for users on your site. Creating a user in this manner is similar to creating a Windows user (I.e. the type you use to login to your laptop after booting) for every user of your site. So, in reality you only need just one (or a couple for things like replication, backup etc) such mysql user.

Your website will then use this one mysql user to connect to the mysql server. In addition to having this mysql user you must create a database in mysql and explicitly grant access to that database to this user. Within this database you also must create a table in which the actual login credentials of users of your site will be stored.

To recap, use the mysql user account to connect to a specific database on your mysql server. When connected create a record in a table with username and password for your site's user.

PS: For one who claims to have 'years as a programmer' and given your username it is hard to believe that you're not just trolling with this question. However, am glad to be punked.

foldl:
@logicalhumour I suspect you're trolling but I'll answer your question in the off chance that you're not.

That is how you create a user in mysql but not quite in the same sense as creating a user account for users on your site. Creating a user in this manner is similar to creating a Windows user (I.e. the type you use to login to your laptop after booting) for every user of your site. So, in reality you only need just one (or a couple for things like replication, backup etc) such mysql user.

Your website will then use this one mysql user to connect to the mysql server. In addition to having this mysql user you must create a database in mysql and explicitly grant access to that database to this user. Within this database you also must create a table in which the actual login credentials of users of your site will be stored.

To recap, use the mysql user account to connect to a specific database on your mysql server. When connected create a record in a table with username and password for your site's user.

PS: For one who claims to have 'years as a programmer' and given your username it is hard to believe that you're not just trolling with this question. However, am glad to be punked.

Lol... Thanks... but how on earth do you think its real