Installing MySQL on Unix/Linux Using Generic Binaries

素颜马尾好姑娘i 2022-08-27 11:55 2阅读 0赞

2.2 Installing MySQL on Unix/Linux Using Generic Binaries  
2.2 在Unix/Linux上使用通用的二进制文件安装MySQL  
  
   Oracle provides a set of binary distributions of MySQL.  
   Oracle 提供了一组MySQL的二进制分发版.  
  
   These include binary distributions in the form of compressed tar files  
   (files with a .tar.gz extension) for a number of platforms, as  
   well as binaries in platform-specific package formats for selected  
   platforms.  
   包括以tar压缩文件形式的二进制分发版（文件以.tar.gz为后缀名），它和所选择平台的特定平台的二进制一样。  
  
   This section covers the installation of MySQL from a compressed  
   tar file binary distribution.  
   本节讨论从二进制分发版的压缩文件安装MySQL.  
  
   For other platform-specific package  
   formats, see the other platform-specific sections.  
   对于其他特定平台的包的格式，请看其他特定平台的章节。  
  
   For example,  
   for Windows distributions, see Section 2.3, "Installing MySQL on  
   Microsoft Windows."  
   比如，对于Windows的分发版，请看2.3章节，“在Microsoft Windows上安装MySQL”.  
  
   To obtain MySQL, see Section 2.1.3, "How to Get MySQL."  
   要获取MySQL,请看2.1.3章节，“如何获取MySQL”.  
      
  
   MySQL compressed tar file binary distributions have names of the  
   form mysql-VERSION-OS.tar.gz, where VERSION is a number (for  
   example, 5.6.20), and OS indicates the type of operating system  
   for which the distribution is intended (for example, pc-linux-i686  
   or winx64).  
   MySQL压缩文件二进制分发版文件名格式为mysql-VERSION-OS.tar.gz,其中VERSION是  
   版本号（例如，5.6.20），OS表示准备安装的分发版文件的操作系统类型（例如，  
   pc-linux-i686或者winx64）.  
  
   To install MySQL from a compressed tar file binary distribution,  
   your system must have GNU gunzip to uncompress the distribution  
   and a reasonable tar to unpack it.  
   要从二进制发布版的压缩文件安装MySQL，你的系统必须有GNU gunzip来解压压缩分发版，  
   并且有一个合适的tar解包分发版。  
  
   If your tar program supports  
   the z option, it can both uncompress and unpack the file.  
   如果你的tar程序支持z选项，也能够解压缩文件。  
  
  
   GNU tar is known to work.  
   GUN tar据所了解，可以工作。  
  
   The standard tar provided with some  
   operating systems is not able to unpack the long file names in the  
   MySQL distribution.  
   一些操作系统中含有安装的tar,不能够解压MySQL分发版的长文件名。  
     
   You should download and install GNU tar, or if  
   available, use a preinstalled version of GNU tar.  
   这是你需要下载并且安装GNU tar，或者有可能，使用预装版本的GNU tar。  
  
   Usually this is  
   available as gnutar, gtar, or as tar within a GNU or Free Software  
   directory, such as /usr/sfw/bin or /usr/local/bin.  
   通常，这是可作为gnutar,gtar,或者使用GNU或免费的软件目录作为tar,例如  
   /usr/sfw/bin or /usr/local/bin。  
  
   GNU tar is available from http://www.gnu.org/software/tar/.  
   GNU tar可以从http://www.gnu.org/software/tar/获取。  
     
   Warning  
   警告  
  
   If you have previously installed MySQL using your operating system  
   native package management system, such as yum or apt-get, you may  
   experience problems installing using a native binary.  
   如果你之前已经使用你的操作系统的本地包管理系统安装了MySQL,比如yum或者  
   apt-get,你可能在使用本地二进制安装上有遗留问题。  
  
   Make sure  
   your previous MySQL previous installation has been removed  
   entirely (using your package management system), and that any  
   additional files, such as old versions of your data files, have  
   also been removed.  
   确保你之前安装的MySQL被全完清除了（使用包滚利系统），并且任何附加文件，  
   例如你数据文件的旧版本，也被删除了。  
     
   You should also check the existence of  
   configuration files such as /etc/my.cnf or the /etc/mysql  
   directory have been deleted.  
   你还要检查配置文件的存在，像目录/etc/my.cnf or the /etc/mysql是否被删。  
  
   If you run into problems and need to file a bug report, please use  
   the instructions in Section 1.7, "How to Report Bugs or Problems."  
   如果你遇到问题，需要提交错误报告，请使用1.7章节的说明，“如何报告错误或问题”。  
  
  
   On Unix, to install a compressed tar file binary distribution,  
   unpack it at the installation location you choose (typically  
   /usr/local/mysql).  
   在Unix上，安装一个二进制分发版的压缩文件，在你选择的安装位置解压缩它（典型的是/usr/local/mysql）。  
     
   This creates the directories shown in the  
   following table.  
   如下表所示，为创建目录。  
  
   Table 2.3 MySQL Installation Layout for Generic Unix/Linux Binary Package  
   表2.3是MySQL在Unix/Linux二进制包上的安装的目录结构  
     
   Directory Contents of Directory  
   bin Client programs and the mysqld server  
   data Log files, databases  
   docs Manual in Info format  
   man Unix manual pages  
   include Include (header) files  
   lib Libraries  
   scripts mysql\_install\_db  
   share Miscellaneous support files, including error messages,  
   sample configuration files, SQL for database installation

sql-bench Benchmarks

<table> 
 <tbody> 
  <tr> 
   <td>Directory</td> 
   <td>Contents of Directory</td> 
  </tr> 
  <tr> 
   <td>bin</td> 
   <td>Client programs and the mysqld server</td> 
  </tr> 
  <tr> 
   <td>data</td> 
   <td>Log files, databases</td> 
  </tr> 
  <tr> 
   <td>docs</td> 
   <td>Manual Unix manual pagesin Info format</td> 
  </tr> 
  <tr> 
   <td>man</td> 
   <td>Unix manual pages</td> 
  </tr> 
  <tr> 
   <td>include</td> 
   <td>Include (header) files</td> 
  </tr> 
  <tr></tr> 
 </tbody> 
</table>

lib

<table> 
 <tbody> 
  <tr> 
   <td>Libraries</td> 
  </tr> 
  <tr> 
   <td>scripts</td> 
   <td>mysql_install_db</td> 
  </tr> 
  <tr> 
   <td>share</td> 
   <td>Miscellaneous support files, including error messages,</td> 
  </tr> 
  <tr> 
   <td>sample</td> 
   <td>configuration files, SQL for database installation</td> 
  </tr> 
  <tr> 
   <td>sql-bench</td> 
   <td>Benchmarks</td> 
  </tr> 
 </tbody> 
</table>

Debug versions of the mysqld binary are available as mysqld-debug.  
   mysqld二进制的调试版作为mysqld-debug是可用的。  
  
   To compile your own debug version of MySQL from a source  
   distribution, use the appropriate configuration options to enable  
   debugging support.  
   编译你的MySQL调试版的源码，使用适当的配置选项使它支持调试。  
  
   For more information on compiling from source,  
   see Section 2.8, "Installing MySQL from Source."  
   关于更多的源码编译信息，请看2.8章节，“从源码安装MySQL”.  
  
   To install and use a MySQL binary distribution, the basic command  
   sequence looks like this:  
   安装使用MySQL二进制分发版，基本的命令序列如下：  
  
shell> groupadd mysql  
添加mysql用户组  
shell> useradd -r -g mysql mysql  
添加mysql用户，并制定到mysql用户组  
shell> cd /usr/local  
切换到/usr/local目录下  
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz  
解压缩mysql-VERSION-OS.tar.gz  
shell> ln -s full-path-to-mysql-VERSION-OS mysql  
ln命令生成到该目录的一个符号链接，这让我们更容易的把安装目录制定为/usr/local/mysql  
shell> cd mysql  
切换到mysql  
shell> chown -R mysql .  
把数据目录的拥有权给mysql用户  
shell> chgrp -R mysql .  
把组的权限给mysql组  
shell> scripts/mysql\_install\_db --user=mysql  
用 mysql\_install\_db 创建MySQL授权表初始化  
shell> chown -R root .  
将文件拥有权给root  
shell> chown -R mysql data  
将mysql数据目录权限给mysql用户  
shell> bin/mysqld\_safe --user=mysql &  
运行mysql,测试是否安装成功  
\# Next command is optional  
\# 下一个命令是可选的

shell> cp support-files/mysql.server /etc/init.d/mysql.server

将mysql.server复制到etc/init.d下

mysql\_install\_db creates a default option file named my.cnf in the  
   base installation directory.  
   mysql\_install\_db在基本安装目录下创建了一个名为my.cnf的默认选项文件。  
   This file is created from a template  
   included in the distribution package named my-default.cnf.  
   这个文件依照一个模板创建的，包括名为my-default.cnf的二进制包。  
   For more information, see Section 5.1.2.2, "Using a Sample Default  
   Server Configuration File."  
   需要更多的信息，请看5.1.2.2章节，“使用服务器配置文件默认样本”。  
  
   A more detailed version of the preceding description for  
   installing a binary distribution follows.  
   前面详细的描述了安装一个二进制发行版。  
  
   Note  
   注意  
  
   This procedure assumes that you have root (administrator) access  
   to your system.  
   这一步需要你获取系统管理员权限。  
   Alternatively, you can prefix each command using  
   the sudo (Linux) or pfexec (OpenSolaris) command.  
   或者你可以在每个命令前面使用sudo或者pfexec。  
  
   The procedure does not set up any passwords for MySQL accounts.  
   这个过程没有为MySQL账户设置任何密码。  
  
   After following the procedure, proceed to Section 2.9.2, "Securing  
   the Initial MySQL Accounts."  
   接下来请看2.9.2章节，“固定初始化MySQK账户”。  
  
Create a mysql User and Group  
创建一个mysql用户和组  
  
   If your system does not already have a user and group for mysqld  
   to run as, you may need to create one.  
   如果你的系统没有mysql的用户和组运行，你需要创建一个。  
     
   The following commands add  the mysql group and the mysql user.  
   下面的命令是创建mysql的用户和组的。  
  
   You might want to call the user and group something else instead of mysql.  
   你可能想给用户和组取其他的名字而不是mysql。  
     
   If so, substitute the appropriate name in the following instructions.  
   如果如此，使用相应的名字替代下面的说明。  
     
   The syntax for  
   useradd and groupadd may differ slightly on different versions of  
   Unix, or they may have different names such as adduser and  
   addgroup.  
   在不同版本的Unix系统上，创建用户和组的语法可能略微有些不同，  
   或者有不同的叫法，例如adduser和addgroup。  
shell> groupadd mysql  
shell> useradd -r -g mysql mysql  
  
   Note  
   注意  
  
   Because the user is required only for ownership purposes, not  
   login purposes, the useradd command uses the -r option to create a  
   user that does not have login permissions to your server host.  
   因为用户的目的只是拥有所有权，而不是进入系统，useradd命令使用-r选项  
   来创建一个没有登录服务器主机权限的用户。  
  
   Omit this option to permit logins for the user (or if your useradd  
   does not support the option).  
   不使用这个选项就允许用户登录（或者你的useradd不支持这个选项）。  
  
  
Obtain and Unpack the Distribution  
获取并且解压缩发布版  
  
   Pick the directory under which you want to unpack the distribution  
   and change location into it.  
   在你希望解压缩发布版的目录下解压。  
  
   The example here unpacks the distribution under /usr/local.  
   例如：/usr/local  
  
   The instructions, therefore, assume  
   that you have permission to create files and directories in  
   /usr/local.  
   这个指令的前提是你有权限在/usr/local下创建文件和目录  
     
   If that directory is protected, you must perform the  
   installation as root.  
   如果这个目录被保护，你必须使用超级管理员权限执行。  
shell> cd /usr/local  
  
   Obtain a distribution file using the instructions in Section  
   2.1.3, "How to Get MySQL."  
   使用2.1.3章节“如何获取mysql”来获取一个分布文件。  
  
   For a given release, binary  
   distributions for all platforms are built from the same MySQL  
   source distribution.  
   对于一个给定的释放，所有平台的分布版的创建都来自与同一个MySQL源分布。  
  
  
   Unpack the distribution, which creates the installation directory.  
   解压分布版，它会为我们创建安装目录。  
  
   Then create a symbolic link to that directory.  
   然后创建一个符号链接目录。  
   tar can uncompress and unpack the distribution if it has z option support:  
   tar命令如果支持z选项，它就可以解压分布版。  
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz  
shell> ln -s full-path-to-mysql-VERSION-OS mysql  
  
   The tar command creates a directory named mysql-VERSION-OS.  
   tar命令创建了一个名为mysql-VERSION-OS的目录。  
  
   The ln command makes a symbolic link to that directory.  
   ln命令为该目录创建了一个符号链接。  
     
   This enables you  
   to refer more easily to the installation directory as  
   /usr/local/mysql.  
   这使你更容易的使用安装目录如/usr/local/mysql。  
  
   If your tar does not have z option support, use gunzip to unpack  
   the distribution and tar to unpack it.  
   如果你的tar没有z选项的支持，使用gunzip来解压缩分布版和tar来解压它。  
     
   Replace the preceding tar  
   command with the following alternative command to uncompress and  
   extract the distribution:  
   使用下面的命令来代替之前的命令来解压并提取目录。  
  
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -  
  
Perform Postinstallation Setup  
执行安装后的配置  
  
   The remainder of the installation process involves setting up the  
   configuration file, creating the core databases, and starting the  
   MySQL server.  
   剩下的安装过程包括设置配置文件，创建核心数据库，启动mysql服务器。  
     
   For next steps, see Section 2.9, "Postinstallation  
   Setup and Testing."  
   下面的步骤，参照2.9节“安装后的设置与测试”  
  
   Note  
   注意  
  
   The accounts that are listed in the MySQL grant tables initially  
   have no passwords.  
   在MySQL grant的表里面初始化列出的账户没有密码。  
     
   After starting the server, you should set up  
   passwords for them using the instructions in Section 2.9.2,  
   "Securing the Initial MySQL Accounts."  
   在启动服务气候，你应该参照2.9.2节“安全初始化MySQL账户”，为它们设置密码。  
  
   Copyright (c) 1997, 2014, Oracle and/or its affiliates. All rights  
   reserved. Legal Notices