mysql-getting-started-en.pdf - Getting Started with MySQL Abstract MySQL is the world's most popular open-source database Despite its powerful features

mysql-getting-started-en.pdf - Getting Started with MySQL...

This preview shows page 1 - 6 out of 14 pages.

Getting Started with MySQL
Image of page 1
Abstract MySQL is the world's most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions to help you get MySQL up and running in a few easy steps. We also explain how to perform some basic operations with MySQL using the mysql client. Notes The following instructions are for MySQL Community Server 5.7 and do not necessarily apply to earlier or other versions of MySQL. These are instructions for a fresh installation only. If you are already using MySQL and want to upgrade to a newer version, see Upgrading MySQL . For legal information, see the Legal Notices . For help with using MySQL, please visit the MySQL Forums , where you can discuss your issues with other MySQL users. Document generated on: 2019-07-01 (revision: 62525)
Image of page 2
iii Table of Contents .......................................................................................................................................................... 1
Image of page 3
iv
Image of page 4
1 Installing and Starting MySQL Connecting to the MySQL Server with the mysql Client Some Basic Operations with MySQL Other Important Tasks to Perform Troubleshooting Other Helpful Resources Installing and Starting MySQL There are different ways to install MySQL. The following covers the easiest methods for installing and starting MySQL on different platforms. Linux. The easiest way to install MySQL is to use the MySQL repositories : For Yum-based Linux distributions like Oracle Linux, Red Hat Enterprise Linux, and Fedora, follow the instructions in A Quick Guide to Using the MySQL Yum Repository . If your system cannot use the MySQL Yum repository for some reason, follow the instructions in Installing MySQL on Linux Using RPM Packages from Oracle . For APT-based distributions like Debian and Ubuntu, follow the instructions in A Quick Guide to Using the MySQL APT Repository . If your system cannot use the MySQL APT repository for some reason, follow the instructions in Installing MySQL on Linux Using Debian Packages from Oracle . For SUSE Linux Enterprise, follow the instructions in A Quick Guide to Using the MySQL SLES Repository . If your system cannot use the MySQL SUSE repository for some reason, follow the instructions in Installing MySQL on Linux Using RPM Packages from Oracle . For Linux distributions that do not support the MySQL repositories or the installation packages mentioned above, you can install MySQL using generic binaries: Download the .tar or .tar.gz archive for the generic binaries for Linux from the Download MySQL Community Server page. See Installing MySQL on Unix/Linux Using Generic Binaries for instructions on installing the binaries. After installing the binaries, following the instructions given in Initializing the Data Directory . It is especially important to note the random root password generated for you during the initialization process; see Initializing the Data Directory for more detail.
Image of page 5
Image of page 6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture