Getting started with MariaDB explore the powerful features of MariaDB with practical examples
This book is for anyone who wants to learn more about databases in general and wants to get started with MariaDB. Prior database experience is not required.
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England ; Mumbai, [India] :
Packt Publishing
2015.
|
| Edición: | 2nd ed |
| Colección: | Community experience distilled.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629936206719 |
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
- The MariaDB filesystem layoutThe MariaDB filesystem layout on Windows; The MariaDB filesystem layout on Linux; Modular configuration on Linux; The anatomy of the MariaDB configuration file; Where is my configuration file?; Comments; Groups; Options that do not require values; Options that require values; Option formatting; Options, options everywhere; Activating configuration changes; Summary; Chapter 3: Securing MariaDB; Security layers; Securing MariaDB in 10 seconds; Connecting safely; Connecting safely on the command line; Connecting safely in scripts; Server security; Building security
- Internal network securityInternet security; Summary; Chapter 4: Administering MariaDB; User privileges; Global administrative user privileges; Database, table, and column user privileges; Miscellaneous user privileges and limits; Creating users; Granting, revoking, and showing permissions; Granting permissions; Revoking permissions; Showing permissions; Setting and changing passwords; Removing users; Summary; Chapter 5: Using MariaDB - Databases and Tables; The mysql command-line client application; Connecting to MariaDB; Using USE to select a database
- Using SHOW to list all databases on a serverCreating and deleting databases; Using CREATE DATABASE to create a database; Using DROP DATABASE to delete a database; Data, tables, and normalization; Creating, altering, and dropping tables; Using CREATE TABLE; Using CREATE TABLE - datatypes; Using CREATE TABLE- other options; Using CREATE TABLE - an example; Using SHOW to display the command used to create a table; Using DESCRIBE to explore the structure of a table; Using ALTER TABLE; Using ALTER TABLE - basic syntax; Using ALTER TABLE - adding a column; Using ALTER TABLE - modifying a column
- Using ALTER TABLE - dropping a columnUsing DROP TABLE; Summary; Chapter 6: Using MariaDB - Inserting, Updating, and Deleting; Using INSERT; Inserting complete rows; Inserting partial rows; Inserting from another table; Inserting from a file; Using UPDATE; Using DELETE; Summary; Chapter 7: Using MariaDB - Retrieving Data; Retrieving data; Retrieving everything; Retrieving selected columns; Filtering and searching data; Filtering by exact values; Using logical operators; Using the AND operator; Using the OR operator; Evaluation order; Using the IN operator; Using the NOT operator
- Searching with LIKE
