How to find out what database to look for the login authentication


Problem :

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.



Solution :

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.


Mysql Tutorials

Mysql Howto..

How to reset mysql password

How to query, then process a large quantity in somewhat short time frame

mysql: how to perform these 2 tasks

how to use IGNORE?

How to connect MySQL with python 3

How to use SELECT inside INSERT to define a specific column in mysql

How to update mysql fields with Javascript

MySQL question: How to insert unique non-integer employee ids?

Windows: How to open a .exe in a shell window that won't close?

How to SELECT the total values from a column in MySQL?

How to find out data from more than one tables in MYSQL

how to design a mysql database with phone contacts and find if any contact using the same app?

laravel: how to multiply current value of column with some value when updating rows?

How to create Alphabetical Group of Brands Menu by php

How to check MySQL port on Mac [closed]

How to use the LIKE statement correctly in a MySql SELECT statement?

php mysql How to Run a Subquery in the right way for this table

How to create a valid MYSql database name from a string?

how to insert data into mysql using iphone [closed]

How to append the new data to a column in mysql

How to know if a name refers to mysql table or mysql view in a php script

how to do “with CTE” in mySQL?

How to connected to existing MySQL database in Laravel 5?

how to write a mysql trigger to log history

How to check for multiple values in MySQL using IN and a parameter?

How to order comments by likes/dislikes in MySQL

How to get temporal sequence by mysql

how can affect performance when I use UUIDs as my primary keys in MySQL

How to install MySQLdb with python 3.2

MySQL select seems very slow but cannot think how to improve?