14–16 CompTIA Linux+ Certification, Powered by LPI
Topic B: MySQL services
This topic covers the following CompTIA exam objectives for Linux+ [Powered by
LPI] Certification, LX0-101 and LX0-102 exams.
102.4 Use Debian package management
Install, upgrade and uninstall Debian binary packages
110.2 Setup host security
The following is a partial list of the used files, terms, and utilities:
MySQL is an open source database server published by Oracle Corporation (formerly
Sun Microsytems). It is frequently used by Web site programmers for storing data that is
created or managed by a Web application. For example, an online shopping site could
store its product catalog, pricing information, inventory, sales history, and so forth in a
MySQL support is probably not installed on your Linux distribution by default, unless
you specify so during installation. You can download MySQL from www.mysql.com. It
is also available as a package for most distributions.
Connections to a MySQL server must include a user name and password. You can use
this feature to restrict access to selected databases. User A might have access to
Database A, while User B cannot access that database but can access Database B.
The default user, named root, has full control over the server. You are prompted for a
password to use with this account, if you install MySQL via a package. With other
cases, the password might be blank. You should not run a MySQL server with a blank