Installing MySQL on macOS On Windows, MySQL Server supports only directory and file names that are compatible with the current ANSI code pages. For example, the following Japanese directory name does not work in the Western locale (code page 1252): The same limitation applies to directory and file names referred to in SQL statements, such as the data file path name in  LOAD DATA . Path name components in Windows are separated by the  \  character, which is also the escape character in MySQL. If you are using  LOAD DATA  or  SELECT ... INTO OUTFILE , use Unix-style file names with  /  characters: Alternatively, you must double the  \  character: Pipes do not work reliably from the Windows command-line prompt. If the pipe includes the character  ^Z /  CHAR(24) , Windows thinks that it has encountered end-of-file and aborts the program. This is mainly a problem when you try to apply a binary log as follows: If you have a problem applying the log and suspect that it is because of a  ^Z  /  CHAR(24)  character, you can use the following workaround: The latter command also can be used to reliably read any SQL file that may contain binary data. For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/ supportedplatforms/database.html. MySQL for macOS is available in a number of different forms: 156 •Compressed TAR archive, which uses a file packaged using the Unix  tar  and  gzip  commands. To use this method, you need to open a  Terminal  window. You do not need administrator privileges using this method; you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic instructions for using a tarball, Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries” . •Native Package Installer, which uses the native macOS installer (DMG) to walk you through the installation of MySQL. For more information, see Section 2.4.2, “Installing MySQL on macOS Using Native Packages” . You can use the package installer with macOS. The user you use to perform the installation must have administrator privileges. • Problems with pipes • The  \  path name separator character datadir="C:/ 私たちのプロジェクトのデータ " mysql>  LOAD DATA INFILE ’C:/tmp/skr.txt’ INTO TABLE skr; mysql>  SELECT * INTO OUTFILE ’C:/tmp/skr.txt’ FROM skr; mysql>  LOAD DATA INFILE ’C:\	mp\\skr.txt’ INTO TABLE skr; mysql>  SELECT * INTO OUTFILE ’C:\	mp\\skr.txt’ FROM skr; C:\>  mysqlbinlog  binary_log_file  | mysql --user=root C:\>  mysqlbinlog  binary_log_file  --result-file=/tmp/bin.sql C:\>  mysql --user=root --execute "source /tmp/bin.sql" 2.4 Installing MySQL on macOS