How to find out what database to look for the login authentication
I'm working on a project that has a website panel and an android app and for database i'm using mysql to save users information like username and password.
What i'm going to do is for every client(company), i want to create a database with it's unique name but with same tables and my problem is when users are logging in, i don't know how to find out which database should i use for login authentication because i think it's a bad idea to look in the all of databases to find user's information.
Thanks for your help in advance.
First step: Create API for connect Android User to Mysql user+database, so when you authenticate, the API send you back the connection string, different for every user. It means that you need a database, only for auth and connect.
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]