January 2005
Intermediate to advanced
544 pages
23h 44m
English
Content preview from Linux Server Security, Second Edition
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.