Can anyone point me in the right direction.
I am looking to have one single database to manage nothing but User ID, Password and Permissions - we will call this database A.
I then have 6 (B - G)different databases which all have a Users table for ID's and Passwords. I want to have the database look to the A database for login information by somehow linking the backend of the database to DB A. rather than its own local table Users.
I have read that foreign keys come into place, however my 6 databases B - G are all MyISAM table structure rather than InnoDB.
Is there a good read somewhere that covers this? I tried doing some searches but as I am new to MySQL I think I am looking up the wrong terms.
Screach.....the sound of your world coming to an end at the sight of the dreaded BSOD!
I am looking to have one single database to manage nothing but User ID, Password and Permissions - we will call this database A.
I then have 6 (B - G)different databases which all have a Users table for ID's and Passwords. I want to have the database look to the A database for login information by somehow linking the backend of the database to DB A. rather than its own local table Users.
I have read that foreign keys come into place, however my 6 databases B - G are all MyISAM table structure rather than InnoDB.
Is there a good read somewhere that covers this? I tried doing some searches but as I am new to MySQL I think I am looking up the wrong terms.
Screach.....the sound of your world coming to an end at the sight of the dreaded BSOD!