Cargando…
Getting Started with MariaDB.
Appendix: MariaDB Next Steps; Index.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2013.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing MariaDB; Choosing a MariaDB series; The development series; The stable series; The maintenance series; Installing MariaDB on Windows; Installing MariaDB on Mac OS X; Installing MariaDB on Debian, Ubuntu, and Linux Mint; Installing MariaDB on Fedora, Red Hat, and CentOS; Installing MariaDB on Other Linux Distributions; MariaDB Package Security; After the installation; Troubleshooting installation issues; Summary; Chapter 2: Configuring MariaDB.
- Filesystem layout for MariaDBFilesystem layout for Windows; Filesystem layout for Linux; Modular configuration on Linux; The MariaDB configuration file; Comments; Groups; Options which do not require values; Options which require values; Options, options, everywhere; Activating configuration changes; Summary; Chapter 3: MariaDB Security; Securing MariaDB in ten seconds; Connecting safely; Server security; Building security; Internal network security; Internet security; Summary; Chapter 4: MariaDB User Account Management; User privileges; Global administrative privileges.
- Database, table, and column privilegesMiscellaneous privileges and limits; Creating users; Granting permissions; Adding and removing privileges; Showing grants; Changing passwords; Removing users; Summary; Chapter 5: Using MariaDB; Running the mysql command-line client; Using a database; Listing all databases on a server; Creating and dropping databases; Creating a database; Dropping a database; Creating, altering, and dropping tables; Creating a table; Showing the command used to create a table; Exploring the Structure of a Table; Altering a table; Adding a column; Modifying a column.
- Dropping a columnDropping a table; Selecting, inserting, updating, and deleting data; Inserting data; Updating data; Deleting data; Reading data; Summary; Chapter 6: MariaDB Maintenance; MariaDB log files; The all-important binary log; The error log; The general query log; The slow query log; Optimizing and tuning MariaDB; Backing up MariaDB; Basic backups with mysqldump; Restoring and importing data with mysqlimport; Making backups of MyISAM tables quickly with mysqlhotcopy; Making cold backups; Checking and repairing tables; Checking and optimizing tables with mysqlcheck; Repairing tables.