Coverart for item
The Resource Getting Started with MariaDB

Getting Started with MariaDB

Label
Getting Started with MariaDB
Title
Getting Started with MariaDB
Creator
Subject
Language
eng
Summary
  • Appendix: MariaDB Next Steps; Index
  • A practical, hands-on, beginner-friendly guide to installing and using MariaDB. Getting Started with MariaDB is for anyone who wants to learn more about databases in general or MariaDB in particular. No prior database experience is required. It is assumed that you have basic knowledge of software installation, editing files with a text editor, and using the command line and terminal
Member of
http://library.link/vocab/creatorName
Bartholomew, Daniel
Dewey number
  • 004.36
  • 004/.36
Index
no index present
Literary form
non fiction
Nature of contents
dictionaries
Series statement
Community experience distilled
http://library.link/vocab/subjectName
  • Databases
  • Open source software
Label
Getting Started with MariaDB
Instantiates
Publication
Antecedent source
unknown
Color
multicolored
Contents
  • 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
Control code
ocn861558927
Dimensions
unknown
Extent
1 online resource (100 pages)
File format
unknown
Form of item
online
Isbn
9781782168102
Level of compression
unknown
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)861558927
Label
Getting Started with MariaDB
Publication
Antecedent source
unknown
Color
multicolored
Contents
  • 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
Control code
ocn861558927
Dimensions
unknown
Extent
1 online resource (100 pages)
File format
unknown
Form of item
online
Isbn
9781782168102
Level of compression
unknown
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)861558927

Library Locations

    • InternetBorrow it
      Albany, Auckland, 0632, NZ
Processing Feedback ...