Skip to Main Content
Linux Server Security, Second Edition
book

Linux Server Security, Second Edition

by Michael D. Bauer
January 2005
Intermediate to advanced content levelIntermediate to advanced
544 pages
23h 44m
English
O'Reilly Media, Inc.
Content preview from Linux Server Security, Second Edition
This is the Title of the Book, eMatter Edition
Copyright © 2007 O’Reilly & Associates, Inc. All rights reserved.
248
|
Chapter 8: Database Security
Stopping the Server
Anyone with SHUTDOWN privilege may stop the MySQL server by running
mysqladmin shutdown. The mysql user may also stop the server at the operating sys-
tem level with commands such as
service mysqld stop.
Backups
A database administrator should periodically dump tables to files in case data
becomes lost or corrupted and needs to be recovered. The mysqldump client writes
all the SQL commands needed to re-create the tables and insert all the data rows.
The backup file permissions should only allow reading and writing by the mysql user
and group.
Logging
MySQL writes logs to record errors, queries, slow queries, and updates. These are
normally written to the same data directory that contains the MySQL database.
Besides protecting these files from snooping, they should be rotated before they fill
up the disk. Red Hat includes a mysql-log-rotate script as part of its logrotate
package.
Replication
To enhance speed and reliability, MySQL can be configured to replicate data in
many ways. This introduces many issues that are better explained in the book, High
Performance MySQL (O’Reilly). In terms of security, you want to protect the data
streams among master(s) and slaves.
Queries
Database servers have some of the same problems as web servers. Each ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Linux: Powerful Server Administration

Linux: Powerful Server Administration

Uday Sawant, Oliver Pelz, Jonathan Hobson, William Leemans
Linux Server Hacks

Linux Server Hacks

Rob Flickenger
Linux Server Hacks, Volume Two

Linux Server Hacks, Volume Two

William von Hagen, Brian K. Jones

Publisher Resources

ISBN: 0596006705Supplemental ContentCatalog PageErrata