In which of the following files must the base directory be specified if MySQL is not installed in the default directory for the platform?

The correct answer is C. my.cnf D. my.ini. If you install MySQL on Windows, the server assumes by default that the installation directory is C:\mysql and the data directory is named data in the installation directory. If you install MySQL somewhere else, such as E:\mysql, you must tell the server that location with a…

MySQL Installation and Configuration

Question

Options

Aconfig.cnf
Bconfig.ini
Cmy.cnf
Dmy.ini
Ebasedir.cnf
Fbasedir.ini

How the community answered

(25 responses)

A
4% (1)
B
16% (4)
C
72% (18)
E
8% (2)

Explanation

If you install MySQL on Windows, the server assumes by default that the installation directory is C:\mysql and the data directory is named data in the installation directory. If you install MySQL somewhere else, such as E:\mysql, you must tell the server that location with a --basedir option. Options in option files are given without the leading dashes, so to indicate the installation directory, specify the option as follows: basedir=E:/mysql

Topics

#configuration files#my.cnf#my.ini#basedir

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice