Index
A
- ALTER COMMAND command
- ALTER TABLE command
- using / Using ALTER TABLE
- syntax / Using ALTER TABLE – basic syntax
- column, adding / Using ALTER TABLE – adding a column
- column, modifying / Using ALTER TABLE – dropping a column
- AND operator
- using / Using the AND operator
- AVG function / The AVG function
B
- backups
- creating, mysqldump used / Basic backups with mysqldump
- restoring, mysqldump used / Restoring backups made with mysqldump
- with xtrabackup, restoring / Restoring backups made with xtrabackup
- binary log
- about / The binary log
- URL / The binary log
- brew
C
- Centos
- MariaDB, installing on / Installing MariaDB on Fedora, Red Hat, and CentOS
- column user privileges
- comment lines
- about / Comments
- configuration file, MariaDB
- anatomy / The anatomy of the MariaDB configuration file
- about / Where is my configuration file?
- comment lines / Comments
- groups / Groups
- options, values not required / Options that do not require values
- options, values required / Options that require values
- options, formatting / Option formatting
- options / Options, options everywhere
- modifications / Activating configuration changes
- COUNT function / The COUNT function
- CREATE DATABASE command
- used, for creating database / Using CREATE DATABASE to create a database
- URL / Using CREATE DATABASE to create a database
- CREATE TABLE command
- used, for creating tables / Using CREATE TABLE
- syntax / Using CREATE TABLE – basic syntax
- datatypes / Using CREATE TABLE – datatypes
- other options / Using CREATE TABLE– other options
- example / Using CREATE TABLE – an example
- URL / Using CREATE TABLE – an example
D
- data
- about / Data, tables, and normalization
- retrieving / Retrieving data, Retrieving everything
- selected columns, retrieving / Retrieving selected columns
- filtering / Filtering and searching data
- searching / Filtering and searching data
- filtering, by exact values / Filtering by exact values
- logical operators, using / Using logical operators
- sorting / Sorting data
- joining / Joining data
- summarizing / Summarizing data
- data, summarizing
- about / Summarizing data
- AVG function / The AVG function
- COUNT function / The COUNT function
- MAX function / The MIN and MAX functions
- MIN function / The MIN and MAX functions
- SUM function / The SUM function
- GROUP BY used / Using GROUP BY with summarized data
- GROUP BY filtering, HAVING clause used / Using HAVING to filter GROUP BY
- database
- selecting, USE command used / Using USE to select a database
- listing on server, SHOW command used / Using SHOW to list all databases on a server
- creating / Creating and deleting databases
- deleting / Creating and deleting databases
- creating, CREATE DATABASE command used / Using CREATE DATABASE to create a database
- deleting, DROP DATABASE command used / Using DROP DATABASE to delete a database
- database user privileges
- datatypes
- Debian
- MariaDB, installing on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- DELETE command
- about / Using DELETE
- URL / Using DELETE
- DESCRIBE command
- used, for exploring table structure / Using DESCRIBE to explore the structure of a table
- URL / Using DESCRIBE to explore the structure of a table
- development series / The development series
- DROP DATABASE command
- used, for deleting database / Using DROP DATABASE to delete a database
- DROP TABLE command
- using / Using DROP TABLE
- URL / Using DROP TABLE
- DROP USER statement
- URL / Removing users
E
- error log
- about / The error log
- URL / The error log
F
- Fedora
- MariaDB, installing on / Installing MariaDB on Fedora, Red Hat, and CentOS
- filesystem, MariaDB
- layout / The MariaDB filesystem layout
- layout, on Windows / The MariaDB filesystem layout on Windows, The MariaDB filesystem layout on Linux
- floating point numbers
G
- general query log
- about / The general query log
- URL / The general query log
- global administrative user privileges
- Gnu Privacy Guard (GPG) / MariaDB package security
- GRANT statement
- URL / Granting permissions
- GROUP BY
- used, for data summarizing / Using GROUP BY with summarized data
- filtering, HAVING clause used / Using HAVING to filter GROUP BY
- groups
- about / Groups
I
- InnoDB tables backups
- creating, xtrabackup used / Making backups of XtraDB and InnoDB tables with xtrabackup
- IN operator
- using / Using the IN operator
- INSERT...SELECT command
- INSERT command
- using / Using INSERT
- complete rows, inserting / Inserting complete rows
- partial rows, inserting / Inserting partial rows
- URL / Inserting partial rows
- another table, inserting from / Inserting from another table
- inserting, from file / Inserting from a file
- internal network security
- about / Internal network security
- Internet security
- about / Internet security
- IRC channel
L
- LIKE
- searching with / Searching with LIKE
- limit user privileges / Miscellaneous user privileges and limits
- Linux
- modular configuration / Modular configuration on Linux
- Linux Mint
- MariaDB, installing on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- LOAD DATA INFILE command
- URL / Inserting from a file
- log files
- binary log / The binary log
- error log / The error log
- general query log / The general query log
- slow query log / The slow query log
- logical operators
- AND operator, using / Using the AND operator
- OR operator, using / Using the OR operator
- evaluation order / Evaluation order
- IN operator, using / Using the IN operator
- NOT operator, using / Using the NOT operator
M
- Mac OS X
- MariaDB, installing on / Installing MariaDB on Mac OS X
- maintenance series / The maintenance series
- MariaDB
- series / Choosing a MariaDB series
- installing, on Windows / Installing MariaDB on Windows
- downloads, URL / Installing MariaDB on Windows
- installing, on Mac OS X / Installing MariaDB on Mac OS X
- installing, on Ubuntu / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- installing, on Linux Mint / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- installing, on Debian / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- installing, on Red Hat / Installing MariaDB on Fedora, Red Hat, and CentOS
- installing, on Centos / Installing MariaDB on Fedora, Red Hat, and CentOS
- installing, on Fedora / Installing MariaDB on Fedora, Red Hat, and CentOS
- installing, on other Linux distributions / Installing MariaDB on other Linux distributions
- package security / MariaDB package security
- documentation, URL / MariaDB package security
- post installation / After the installation
- installation, issues / Troubleshooting installation issues
- filesystem, layout / The MariaDB filesystem layout on Windows, The MariaDB filesystem layout on Linux
- security / Security layers
- securing / Securing MariaDB in 10 seconds
- safe connection / Connecting safely
- safe connection, on command line / Connecting safely on the command line
- safe connection, in scripts / Connecting safely in scripts
- user privileges / User privileges
- connecting to / Connecting to MariaDB
- log files / MariaDB log files
- optimizing / Optimizing and tuning MariaDB
- tuning / Optimizing and tuning MariaDB
- data, backing up / Backing up, importing, and restoring data
- data, importing / Backing up, importing, and restoring data
- data, restoring / Backing up, importing, and restoring data
- repairing / Repairing MariaDB
- MAX function / The MIN and MAX functions
- MIN function / The MIN and MAX functions
- miscellaneous user privileges / Miscellaneous user privileges and limits
- MyISAM tables
- backup creating, mysqlhotcopy used / Making backups of MyISAM tables with mysqlhotcopy
- mysqlcheck
- used, for optimizing tables / Checking and optimizing tables with mysqlcheck
- used, for checking tables / Checking and optimizing tables with mysqlcheck
- URL / Checking and optimizing tables with mysqlcheck
- mysql command-line client application
- mysqldump
- used, for creating backup / Basic backups with mysqldump
- used, for creating tab-delimited backups / Making tab-delimited backups with mysqldump
- URL / Making tab-delimited backups with mysqldump
- mysqlhotcopy
- used, for creating MyISAM tables backup / Making backups of MyISAM tables with mysqlhotcopy
- URL / Making backups of MyISAM tables with mysqlhotcopy
- mysqlimport
- used, for restoring backups / Restoring backups made with mysqldump
- data, importing with / Restoring and importing data with mysqlimport
- data, restoring with / Restoring and importing data with mysqlimport
- URL / Restoring and importing data with mysqlimport
N
- normalization
- about / Data, tables, and normalization
- NOT operator
- using / Using the NOT operator
O
- OR operator
- using / Using the OR operator
P
- passwords
- changing / Setting and changing passwords
- setting / Setting and changing passwords
- permissions
- granting / Granting permissions
- revoking / Revoking permissions
- showing / Showing permissions
- Pretty Good Privacy (PGP) / MariaDB package security
R
- Red Hat
- MariaDB, installing on / Installing MariaDB on Fedora, Red Hat, and CentOS
- repository configuration tool
- REVOKE statement
- URL / Revoking permissions
S
- security
- layers / Security layers
- Internet security / Security layers, Internet security
- internal network security / Security layers, Internal network security
- building / Security layers, Building security
- server / Security layers
- SELECT command
- URL / Retrieving data
- series
- selecting / Choosing a MariaDB series
- about / Choosing a MariaDB series
- development series / The development series
- stable series / The stable series
- maintenance series / The maintenance series
- server security
- about / Server security
- SET PASSWORD statement
- SHOW command
- used, for listing databases on server / Using SHOW to list all databases on a server
- used, for displaying comand / Using SHOW to display the command used to create a table
- SHOW CREATE TABLE command
- slow query log
- about / The slow query log
- URL / The slow query log
- stable series / The stable series
- Structured Query Language (SQL) / Using SHOW to list all databases on a server
- SUM function / The SUM function
T
- tab-delimited backups
- creating, mysqldump used / Making tab-delimited backups with mysqldump
- tables
- about / Data, tables, and normalization
- creating / Creating, altering, and dropping tables
- CREATE TABLE command, using / Using CREATE TABLE
- CREATE TABLE command, basic syntax / Using CREATE TABLE – basic syntax
- CREATE TABLE command, datatypes / Using CREATE TABLE – datatypes
- CREATE TABLE command, other options / Using CREATE TABLE– other options
- CREATE TABLE command, example / Using CREATE TABLE – an example
- SHOW command, used for displaying command / Using SHOW to display the command used to create a table
- structure exploring, DESCRIBE command used / Using DESCRIBE to explore the structure of a table
- ALTER TABLE command, using / Using ALTER TABLE
- ALTER TABLE command, syntax / Using ALTER TABLE – basic syntax
- ALTER TABLE command, used for adding column / Using ALTER TABLE – adding a column
- ALTER TABLE command, used for modifying column / Using ALTER TABLE – modifying a column
- ALTER TABLE command, used for dropping column / Using ALTER TABLE – dropping a column
- DROP TABLE command, using / Using DROP TABLE
- optimizing, mysqlcheck used / Checking and optimizing tables with mysqlcheck
- repairing / Repairing tables
- table user privileges
U
- Ubuntu
- MariaDB, installing on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- UPDATE command
- about / Using UPDATE
- URL / Using UPDATE
- USE command
- used, for selecting database / Using USE to select a database
- user privileges
- global administrative user privileges / Global administrative user privileges
- table user privileges / Database, table, and column user privileges
- database user privileges / Database, table, and column user privileges
- column user privileges / Database, table, and column user privileges
- table privileges / Database, table, and column user privileges
- database privileges / Database, table, and column user privileges
- miscellaneous user privileges / Miscellaneous user privileges and limits
- limits privileges / Miscellaneous user privileges and limits
- URL / Miscellaneous user privileges and limits
- users
- creating / Creating users
- creating, URL / Creating users
- removing / Removing users
W
- Windows
- MariaDB, installing on / Installing MariaDB on Windows
- URL / Installing MariaDB on Windows
- MariaDB filesystem layout / The MariaDB filesystem layout on Windows, The MariaDB filesystem layout on Linux
X
- xtrabackup
- used, for creating XtraDB backups / Making backups of XtraDB and InnoDB tables with xtrabackup
- used, for creating InnoDB tables backup / Making backups of XtraDB and InnoDB tables with xtrabackup
- URL / Making backups of XtraDB and InnoDB tables with xtrabackup
- backups, restoring / Restoring backups made with xtrabackup
- cold backups, creating / Making cold backups
- XtraDB backups
- creating, xtrabackup used / Making backups of XtraDB and InnoDB tables with xtrabackup
- URL / Repairing tables
Y
- Yellowdog Updater, Modified (YUM) package / Installing MariaDB on Fedora, Red Hat, and CentOS