Database Used in PLM Software
MYSQL
MySQL Server (mysqld) is the main
program that does most of the work in a MySQL installation. This chapter
provides an overview of MySQL Server and covers general server administration:
·
Server configuration.
·
The server log files.
·
Management of multiple servers on a single machine.
When thinking
about security within a MySQL installation, you should consider a wide range of
possible topics and how they affect the security of your MySQL server and
related applications:
·
General factors that affect security. These
include choosing good passwords, not granting unnecessary privileges to users,
ensuring application security by preventing SQL injections and data corruption,
and others.
.
·
Security of the installation itself. The data
files, log files, and the all the application files of your installation should
be protected to ensure that they are not readable or writable by unauthorized
parties.
·
Access control and security within the database
system itself, including the users and databases granted with access to the
databases, views and stored programs in use within the database.
·
Network security of MySQL and your system. The
security is related to the grants for individual users, but you may also wish
to restrict MySQL so that it is available only locally on the MySQL server
host, or to a limited set of other hosts.
No comments:
Post a Comment