This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › Can you authorize shared tables between MySQL databases?
View: 12318|Reply: 3

[Communication] Can you authorize shared tables between MySQL databases?

[Copy link]
Posted on 11/28/2018 11:11:25 AM | | | |
Scene
     The Oracle database used in the project now needs to be migrated to MySQL. There are multiple users in Oracle instances, and after migrating to MySQL, the mode is multiple databases, and now I don't want to access tables across databases like db.table.





Previous:Baidu statistics background, website display link timeout of 1%-5%
Next:php detects passwords
Posted on 11/28/2018 1:07:02 PM |
What does it mean to access a specified database through user authorization yes?  
If yes
http://blog.51cto.com/zhaoyun/727102
Posted on 11/28/2018 1:28:24 PM |
Do you mean mysql one user manages a database?

If you are not familiar with Oracle and can only simply add, delete, modify, and check, I feel that there is still a big difference between it and MySQL in terms of permission management
Posted on 11/28/2018 1:33:49 PM |
Answers provided by enthusiastic group friends

Provide an idea: databases 1, 2, 3, and 4 are the databases that need to be managed, and an intermediate management Manage library is added. The table of library 1234 has a completely consistent data structure, and manage is responsible for the user's account management (or the permission management of the 1234 database), and then the program gets the database connection required by the user through manage (database 1.2.3.4).

The corresponding permissions are connected and accounted) to manipulate the data

Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com