Installing MySQL and MariaDB - Learning MySQL and MariaDB - page 21

that box. In the Configuration section, you can also enter the password for the MySQL
root user. Enter a secure password and don't forget it. You can also add another user.
We'll cover that in Post-Installation . But if you want to make that process easier, you can
add a user here for yourself — but I recommend waiting and using MySQL to add users,
so you learn that important skill. As for the rest of the choices that the installer gives you,
you can probably accept the default settings.
In this topic, you will be working and learning from the command line, so you will need
to have easy access to the MySQL clients that work from the command line. To invoke
the command-line utilities without having to enter the file path to the directory containing
them, enter the following from the command line, from any directory:
PATH=%PATH%;C:\Program Data\MySQL\MySQL Server version \bin
export PATH
Replace the word version with the version number and make sure to enter the actual
path where MySQL is installed. If you changed the location when you installed MySQL,
you need to use the path that you named. The line just shown will let you start the client
by entering simply mysql andnot something like, C:\Program Data\MySQL\MySQL Serv-
er version \bin\mysql each time. For some Windows systems, you may need to change
the start of the path to C:\Program Files\ . You'll have to search your system to see where
the binary files for MySQL were installed — look for the bin\ subdirectory. Any com-
mand windows you may already have open won't get the new path. So be sure to close
them and open a new command window.
Once you've finished installing MySQL and you've set up the configuration file, the in-
staller will start the MySQL server automatically. If you've installed MySQL manually
without an installer, enter something like the following from a command window:
mysqld --install
net start mysql
Now that MySQL is installed and running, you need to make some post-installation ad-
justments, as explained in Post-Installation . So jump ahead to the last couple of pages of
thischapter.
FreeBSD and Sun Solaris Distributions
Installing MySQL or MariaDB with abinary distribution is easier than using a source dis-
tribution. If a binary distribution is available for your platform, it's the recommended
choice. For Sun Solaris distributions, there arePKG files for MySQL on Oracle's site and
PKG files for MariaDB on the MariaDB Foundation's site. For MySQL, you will have to