Click here to Skip to main content
14,770,678 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I will maybe sound stupid, but. I read one book about MySQL (Im totally new to that type of stuff). And I dont know any practical usage of that SQL.

What a thought: I ll have a website, or online app written in some language (C#, python, or something). And I ll use MySQL for saving users logins and passwords. Does MySQL works like that?

What I have tried:

Do I need it for online apps with user logins at all? Or is it just waste of time and I can save and protect logins and passwords in any language without using SQL?
Posted
Updated 18-Jan-20 18:51pm

Protecting an account using a password is always a good idea. You can use the database to store the hashed passwords.

Have a look at Password Storage: How to do it.[^]
   
To add to what Wendelius says, you don't need SQL to implement a secure login ... SQL is all about storing data and there are many different ways to do that, of which SQL allows access to several but by no means all.

The first thing to note is that SQL and MySQL are not synonymous: MySQL is a specific multiuser database system while SQL is a (mostly) generic language for querying data sources. SQL can be used to access a MySQL database, but it can also be used to access Access, Excel, SQL Server, SqLite, Oracle, and many others; and to do other things which indirectly access stored information such as report generation (Crystal Reports, SSRS, ...)

You should not use the two terms as if they are interchangeable!

In fact, many online systems use an Access DB to store login information, though I prefer SQL Server, simply because my hosting service provides it and I see no need to add extra services.

But ... I really wouldn't suggest learning this stuff by creating an online login system, simply because it would be covered by GDPR legislation, and if you don't know what you are doing you could end up in a lot of trouble - it's not a good area for "playing" :laugh:

Instead, why not try setting up a DB to organise your MP3 or MP4 collection? That'll give you a good deal of experience, without any legal ramification, other than if any of it nis pirated and that one is down to you already! LOL.
   
Comments
sOwlO 18-Jan-20 19:44pm
   
Thank you for clear explanation. :)
Yes,
Of course Mysql can do this task.
Just need some code to do the job.
Read more here:
Manual:Securing database passwords - MediaWiki[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900