title: MySQL Share table between two databases
body: <p>I want to know whether my approach is incorrect here</p>
  
  <p>I have a simple website which you can register for. It has a main database called <code>USERS</code> which has a table with a list of all the users, and then for every new user a new database is generated called <code>DB1,DB2,...,DBn</code>. The reason I did this is because there is a lot of information being stored per user and I thought this would be a better approach. However, now I am running into the problem that the user databases need access to the table in the <code>USERS</code> database (for a foreign key) and I can't figure out how to do that.</p>
  
  <p>I admit that I don't have much experience with MySQL, so it might be a very bad decision making a new database for every user. Is this the case? How efficient is MySQL? Can I, for example, create a list for (hypothetically) 100,000 users where each user has a further 100 entries for, lets say pictures, they have uploaded.</p>
  
  <p>Thanks</p>