DATABASE ADMINISTRATION
AND SECURITY
Chapter 3
Bandarlampung, Februari 2020
Jupriyadi, S.Kom. M.T. https://spada.teknokrat.ac.id
[email protected] Course Objectives
The students will be able to:
Install MySQL database server on linux OS.
Basic configuration MySQL database server
MySQL, the most popular Open Source SQL database
management system, is developed, distributed, and
supported by Oracle Corporation.
The MySQL website (http://www.mysql.com/) provides the latest
information about MySQL software.
What is MySQL ..? (cont’d)
• MySQL is a database management system.
• MySQL databases are relational.
• MySQL software is Open Source.
• The MySQL Database Server is very fast, reliable, scalable,
and easy to use.
• MySQL Server works in client/server or embedded systems.
• A large amount of contributed MySQL software is available.
MySQL IS A DATABASE MANAGEMENT
SYSTEM
A database is a structured collection of data. It may be anything from a
simple shopping list to a picture gallery or the vast amounts of
information in a corporate network. To add, access, and process data
stored in a computer database, you need a database management
system such as MySQL Server. Since computers are very good at
handling large amounts of data, database management systems play a
central role in computing, as standalone utilities, or as parts of other
applications
MySQL DATABASE ARE RELATIONAL
A relational database stores data in separate tables rather
than putting all the data in one big storeroom.
The database structures are organized into physical files
optimized for speed.
The logical model, with objects such as databases, tables,
views, rows, and columns, offers a flexible programming
environment
MySQL SOFTWARE IS OPEN SOURCE
Open Source means that it is possible for anyone to use and modify
the software. Anybody can download the MySQL software from the
Internet and use it without paying anything. If you wish, you may study
the source code and change it to suit your needs. The MySQL
software uses the GPL (GNU General Public License),
http://www.fsf.org/licenses/, to define what you may and may not do
with the software in different situations
The MySQL Database Server is very
fast, reliable, scalable, and easy to use
If that is what you are looking for, you should give it a try.
MySQL Server can run comfortably on a desktop or laptop,
alongside your other applications, web servers, and so on,
requiring little or no attention.
If you dedicate an entire machine to MySQL, you can adjust
the settings to take advantage of all the memory, CPU
power, and I/O capacity available.
MySQL can also scale up to clusters of machines,
networked together
MySQL Server works in client/server or
embedded systems
The MySQL Database Software is a client/server system
that consists of a multithreaded SQL server that supports
different back ends, several different client programs and
libraries, administrative tools, and a wide range of
application programming interfaces (APIs).
We also provide MySQL Server as an embedded
multithreaded library that you can link into your application
to get a smaller, faster, easier-to-manage standalone
product
A large amount of contributed MySQL
software is available
MySQL Server has a practical set of features developed in
close cooperation with our users. It is very likely that your
favorite application or language supports the MySQL
Database Server.
The Main Features of MySQL
Designed to be fully multithreaded using kernel threads, to easily
use multiple CPUs if they are available
Many data types and Fixed-length and variable-length string
types
Full operator and function support in the SELECT list and
WHERE clause of queries
A privilege and password system that is very flexible and secure,
and that enables host-based verification.
Password security by encryption of all password traffic when you
connect to a server
Support for large databases
Clients can connect to MySQL Server using several protocols
The MySQL Data Directory
Data directory subdirectories. Each subdirectory of the data
directory is a database directory and corresponds to a database
managed by the server.
All MySQL installations have certain standard databases
Log files written by the server
InnoDB tablespace and log files
Default/autogenerated SSL and RSA certificate and key files
he server process ID file (while the server is running)
Running Multiple MySQL Instances on
One Machine
In addition to using different data directories, several other options
must have different values for each server instance:
--port=port_num
--socket={file_name|pipe_name}
--shared-memory-base-name=name
--pid-file=file_name
If you use the following log file options, their values must differ for
each server:
--general_log_file=file_name
--log-bin[=file_name]
--slow_query_log_file=file_name
--log-error[=file_name]
What's Next ?
