Index
A
- --all-databases option / Checking and optimizing tables with mysqlcheck
- <alter_definition> attribute / Adding a column
- <alter_definition> command / Altering a table
- Advanced Package Tool (APT) / Filesystem layout for Linux
- AFTER option / Adding a column
- Alpha / The development series
- ALTER TABLE command / Creating a table, Altering a table, Modifying a column
- Aria table / Repairing tables
B
- backups
- creating, mysqldump used / Basic backups with mysqldump
- Beta / The development series
- binary log, MariaDB
- about / The all-important binary log
- working / The all-important binary log
- URL / The all-important binary log
C
- CentOS
- MariaDB, instaling on / Installing MariaDB on Fedora, Red Hat, and CentOS
- cold backup
- creating / Making cold backups
- column
- adding / Adding a column
- modifying / Modifying a column
- dropping / Dropping a column
- comments / Comments, commentsOptions which do not require values
- Create, Read, Update, and Delete (CRUD) / Summary
- CREATE DATABASE command / Creating a database
- CREATE TABLE command / Creating a table, Showing the command used to create a table, Inserting data
D
- --databases option / Checking and optimizing tables with mysqlcheck
- data
- inserting / Inserting data
- updating / Updating data
- deleting / Deleting data
- reading / Reading data
- restoring, mysqlimport used / Restoring and importing data with mysqlimport
- importing, mysqlimport used / Restoring and importing data with mysqlimport
- database
- using / Using a database, Listing all databases on a server
- listing, on server / Listing all databases on a server
- creating / Creating and dropping databases, Creating a database
- dropping / Creating and dropping databases, Dropping a database
- database and table privileges
- ALTER / Database, table, and column privileges
- ALTER ROUTINE / Database, table, and column privileges
- CREATE / Database, table, and column privileges
- CREATE ROUTINE / Database, table, and column privileges
- CREATE TEMPORARY TABLES / Database, table, and column privileges
- CREATE VIEW / Database, table, and column privileges
- DELETE / Database, table, and column privileges
- DROP / Database, table, and column privileges
- EVENT / Database, table, and column privileges
- EXECUTE / Database, table, and column privileges
- INDEX / Database, table, and column privileges
- INSERT / Database, table, and column privileges
- LOCK TABLES / Database, table, and column privileges
- SELECT / Database, table, and column privileges
- SHOW VIEW / Database, table, and column privileges
- TRIGGER / Database, table, and column privileges
- UPDATE / Database, table, and column privileges
- datatype
- about / Creating a table
- Debian
- MariaDB, instaling on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- DELETE command / Deleting data
- delimiter / Listing all databases on a server
- DESCRIBE command / Exploring the structure of a table
- development series / The development series
- DROP command / Dropping a database
- DROP DATABASE command / Dropping a database
- DROP TABLE command / Dropping a table
E
- Enable networking option / Installing MariaDB on Windows
- error log, MariaDB
- about / The error log
- URL / The error log
- event
- about / The all-important binary log
F
- Fedora
- MariaDB, instaling on / Installing MariaDB on Fedora, Red Hat, and CentOS
- filename attribute / Restoring and importing data with mysqlimport
- filesystem layout, MariaDB
- about / Filesystem layout for MariaDB
- for Windows / Filesystem layout for Windows
- for Linux / Filesystem layout for Linux
- modular configuration / Modular configuration on Linux
- MariaDB configuration file / The MariaDB configuration file
- comments / Comments, Groups, Options which require values
- options / Options, options everywhere
- configuration changes, activating / Activating configuration changes
- FIRST option / Adding a column
- foreign keys / Creating, altering, and dropping tables
G
- general query log, MariaDB
- about / The general query log
- URL / The general query log
- general_log variable / The general query log
- general_log_file variable / The general query log
- global administrative privileges
- about / Global administrative privileges
- CREATE USER / Global administrative privileges
- FILE / Global administrative privileges
- PROCESS / Global administrative privileges
- RELOAD / Global administrative privileges
- REPLICATION CLIENT / Global administrative privileges
- REPLICATION SLAVE / Global administrative privileges
- SHOW DATABASES / Global administrative privileges
- SHUTDOWN / Global administrative privileges
- SUPER / Global administrative privileges
- Gnu Privacy Guard (GPG) / MariaDB package security
I
- IF NOT EXISTS command / Creating a table
- InnoDB
- innodb variable / The slow query log
- innodb_force_recovery variable / Repairing tables
- INSERT command / Inserting data
- Install as service box / Installing MariaDB on Windows
- installing
- MariaDB, on Windows / Installing MariaDB on Windows
- MariaDB, on Mac OS X / Installing MariaDB on Mac OS X
- MariaDB, on Ubuntu / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- MariaDB, on Debian / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- MariaDB, on Linux Mint / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- MariaDB, on Fedora / Installing MariaDB on Fedora, Red Hat, and CentOS
- MariaDB, on Red Hat / Installing MariaDB on Fedora, Red Hat, and CentOS
- MariaDB, on CentOS / Installing MariaDB on Fedora, Red Hat, and CentOS
- MariaDB, on other Linux distribution / Installing MariaDB on other Linux distributions
- internal network security / Internal network security
- internet security / Internet security
L
- --local option / Restoring and importing data with mysqlimport
- Linux
- filesystem layout / Filesystem layout for Linux
- Linux Mint
- MariaDB, instaling on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- log_bin variable / The all-important binary log
- log_error variable / The error log
- log_slow_rate_limit variable / The slow query log
- log_slow_verbosity variable / The slow query log
- long_query_time variable / The slow query log
M
- Mac OS X
- MariaDB, installing on / Installing MariaDB on Mac OS X
- maintenance series / The maintenance series
- MariaDB
- installing, on Windows / Installing MariaDB on Windows
- Window installations, ZIP files / Installing MariaDB on Windows
- Window installations, MSI packages / Installing MariaDB on Windows
- installing, on Mac OS X / Installing MariaDB on Mac OS X
- installing, on Debian / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- 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 Fedora / Installing MariaDB on Fedora, Red Hat, and CentOS
- 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 other Linux Distributions / Installing MariaDB on other Linux distributions
- post installation / After the installation
- filesystem layout / Filesystem layout for MariaDB
- securing / Securing MariaDB in ten seconds
- connecting to / Connecting safely
- server security / Server security
- security, building / Building security
- internal network security / Internal network security
- internet security / Internet security
- user privileges / User privileges
- about / Running the mysql command-line client
- working / Running the mysql command-line client
- database, using / Using a database, Listing all databases on a server
- database, creating / Creating and dropping databases, Creating a database
- database, dropping / Creating and dropping databases, Dropping a database
- supported data types, URL / Creating a table
- data, inserting / Inserting data
- data, updating / Updating data
- data, deleting / Deleting data
- data, reading / Reading data
- comparison operators, URL / Reading data
- log files / MariaDB log files, The error log, The slow query log
- tuning / Optimizing and tuning MariaDB
- optimizing / Optimizing and tuning MariaDB
- tuning, URL / Optimizing and tuning MariaDB
- optimizing, URL / Optimizing and tuning MariaDB
- backing up / Backing up MariaDB, Basic backups with mysqldump, Making backups of MyISAM tables quickly with mysqlhotcopy, Making cold backups
- MariaDB back up
- basic backups, mysqldump used / Basic backups with mysqldump
- data restoring, mysqlimport used / Restoring and importing data with mysqlimport
- data importing, mysqlimport used / Restoring and importing data with mysqlimport
- MyISAM tables backup, creating / Making backups of MyISAM tables quickly with mysqlhotcopy
- cold backups, creating / Making cold backups
- MariaDB configuration file / The MariaDB configuration file
- MariaDB installation
- issues / Troubleshooting installation issues
- MariaDB log files
- about / MariaDB log files
- types / MariaDB log files
- binary log / The all-important binary log
- error log / The error log
- general query log / The general query log
- slow query log / The slow query log
- MariaDB Package Security / MariaDB package security
- MariaDB series
- choosing / Choosing a MariaDB series
- development series / The development series
- stable series / The stable series
- maintenance series / The maintenance series
- microtime variable / The slow query log
- miscellaneous privileges
- about / Miscellaneous privileges and limits
- USAGE / Miscellaneous privileges and limits
- ALL PRIVILEGES / Miscellaneous privileges and limits
- GRANT OPTION / Miscellaneous privileges and limits
- limits, MAX_QUERIES_PER_HOUR / Miscellaneous privileges and limits
- limits, MAX_UPDATES_PER_HOUR / Miscellaneous privileges and limits
- limits, MAX_CONNECTIONS_PER_HOUR / Miscellaneous privileges and limits
- limits, MAX_USER_CONNECTIONS / Miscellaneous privileges and limits
- modular configuration / Modular configuration on Linux
- my.cnf files function / Filesystem layout for Linux
- MyISAM table / Repairing tables
- MyISAM tables backup
- creating, mysqlhotcopy used / Making backups of MyISAM tables quickly with mysqlhotcopy
- mysqlbinlog program / The all-important binary log
- mysqlcheck program
- used, for checking tables / Checking and optimizing tables with mysqlcheck
- used, for optimizing tables / Checking and optimizing tables with mysqlcheck
- URL / Checking and optimizing tables with mysqlcheck
- used, for repairing tables / Repairing tables
- mysql command-line client
- running / Running the mysql command-line client
- mysqldump
- used, for backup creating / Basic backups with mysqldump
- URL / Basic backups with mysqldump
- mysqlhotcopy
- used, for MyISAM tables backup creating / Making backups of MyISAM tables quickly with mysqlhotcopy
- URL / Making backups of MyISAM tables quickly with mysqlhotcopy
- mysqlimport
- used, for data restoring / Restoring and importing data with mysqlimport
- used, for data importing / Restoring and importing data with mysqlimport
N
- normalization
- about / Creating a table
O
- Optimize for transactions checkbox / Installing MariaDB on Windows
- ORDER BY clause / Reading data
P
- -p option / Running the mysql command-line client
- passwords
- changing / Changing passwords
- performance_schema database / Creating and dropping databases
- permissions
- granting / Granting permissions
- grants, showing / Showing grants
- Pretty Good Privacy (PGP) / MariaDB package security
- primary key
- about / Creating a table
R
- red
- MariaDB, instaling on / Installing MariaDB on Fedora, Red Hat, and CentOS
- Red Hat
- MariaDB, instaling on / Installing MariaDB on Fedora, Red Hat, and CentOS
- relational database / Creating, altering, and dropping tables
S
- SELECT command / Reading data
- series / Choosing a MariaDB series
- server
- databases, listing on / Listing all databases on a server
- server security, MariaDB / Server security
- SHOW CREATE TABLE command / Showing the command used to create a table
- SHOW DATABASES command / Listing all databases on a server
- SHOW GRANTS command / Showing grants
- slow query log, MariaDB
- about / The slow query log
- slow_query_log_file variable / The slow query log
- long_query_time variable / The slow query log
- log_slow_rate_limit variable / The slow query log
- log_slow_verbosity variable / The slow query log
- switching on / The slow query log
- URL / The slow query log
- slow_query_log_file variable / The slow query log
- snapshots
- about / Making cold backups
- SQL
- stable series / The stable series
T
- --tab option / Basic backups with mysqldump
- table alteration
- column, adding / Adding a column
- column, modifying / Modifying a column
- column, dropping / Dropping a column
- table creation
- create table command, showing / Showing the command used to create a table
- table structure, exploring / Exploring the structure of a table
- tables
- creating / Creating, altering, and dropping tables, Creating a table, Showing the command used to create a table, Exploring the structure of a table
- altering / Altering a table, Dropping a column
- dropping / Dropping a table
- checking, mysqlcheck used / Checking and repairing tables, Checking and optimizing tables with mysqlcheck
- optimizing, mysqlcheck used / Checking and optimizing tables with mysqlcheck
- repairing, mysqlcheck used / Repairing tables
- test database / Creating a table
U
- -u option / Running the mysql command-line client
- Ubuntu
- MariaDB, instaling on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
- UPDATE command / Updating data
- USE command / Using a database
- user privileges
- global administrative privileges / Global administrative privileges
- database and table privileges / Database, table, and column privileges
- miscellaneous privileges / Miscellaneous privileges and limits
- adding / Adding and removing privileges
- removing / Adding and removing privileges
- users
- creating / Creating users
- removing / Removing users
W
- <what> section / Reading data
- WHERE clause / Reading data
- wildcard character
- about / Reading data
- Windows
- MariaDB, installing on / Installing MariaDB on Windows
- filesystem layout / Filesystem layout for Windows
X
- XtraDB/InnoDB Recovery Modes page / Repairing tables
Y
- Yellow Dog Updater, Modified (YUM) / Filesystem layout for Linux