tailieunhanh - Hướng dẫn sử dụng MySQL part 7

An ninh Một trong những khía cạnh quan trọng nhất của quản trị cơ sở dữ liệu và thiết kế ứng dụng cả hai cũng là một trong những bị bỏ qua: an ninh. Trong khi có hàng tá các định nghĩa về bảo mật có thể áp dụng cho phần mềm máy tính, chúng ta có thể tổng hợp nhu cầu của chúng tôi chỉ đơn giản. An ninh là khả năng cho phép người dùng có quyền truy cập dữ liệu trong khi ngăn chặn truy cập từ người sử dụng trái phép | DRAFT 9 10 01 Security One of the most important aspects of both database administration and application design is also one of the most overlooked security. While there are dozens of definitions of security that can apply to computer software we can sum up our needs simply. Security is the ability to allow authorized users to access data while preventing access from unauthorized users. As simple as this definition is it provides flexibility through the terms users and access . Different kinds of security allow different kinds of users different kinds of access. In this chapter we will examine the three main areas where security is important with regards to MySQL MySQL data security server security and client security. A lack of foresight in any of these areas can open up valuable data to attackers. However with a little preventative care your MySQL server can safely provide data in any environment. MySQL data security MySQL provides several mechanisms to control access to the data of the system. Looking back at the definition of security above we can define MySQL data security be specifying meaning of user and access in this context. A user to MySQL is an authenticated connection to the MySQL server. Any time a program attempts to connect to a MySQL server it must provide credentials that identify the user. Those credentials then define the users to MySQL for that connection. To a MySQL server access is simply access to the functions the server provides. While this usually means access to the data in the server via SQL queries it can also mean access to administrative functions such as setting access-rights for other users and shutting down or reloading the server. Protecting MySQL data is the major job of the MySQL security system. The data in this context can have two seperate meanings actual data stored in the database and information about that data also called meta-data . An example of actual database data would be any information stored within an actual .