免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1997 | 回复: 0

install a MySQL source distribution [复制链接]

论坛徽章:
0
发表于 2008-12-08 20:22 |显示全部楼层
The basic commands that you must execute to install a MySQL source
distribution are:

     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> gunzip  cd mysql-VERSION
     shell> ./configure --prefix=/usr/local/mysql
     shell> make
     shell> make install
     shell> cp support-files/my-medium.cnf /etc/my.cnf
     shell> cd /usr/local/mysql
     shell> chown -R mysql .
     shell> chgrp -R mysql .
     shell> bin/mysql_install_db --user=mysql
     shell> chown -R root .
     shell> chown -R mysql var
     shell> bin/mysqld_safe --user=mysql &

If you start from a source RPM, do the following:
     shell> rpmbuild --rebuild --clean MySQL-VERSION.src.rpm

This makes a binary RPM that you can install. For older versions of
RPM, you may have to replace the command `rpmbuild' with `rpm' instead.
*Note*: This procedure does not set up any passwords for MySQL
accounts.

A more detailed version of the preceding description for installing
MySQL from a source distribution follows:
  1. Add a login user and group for `mysqld' to run as:
          shell> groupadd mysql
          shell> useradd -g mysql mysql

     These commands add the `mysql' group and the `mysql' user. 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'.

     You might want to call the user and group something else instead
     of `mysql'. If so, substitute the appropriate name in the
     following steps.

  2. Perform the following steps as the `mysql' user, except as noted.

  3. Pick the directory under which you want to unpack the distribution
     and change location into it.

  4. Obtain a distribution file using the instructions in *Note
     getting-mysql::.

  5. Unpack the distribution into the current directory:
          shell> gunzip

     This command creates a directory named `mysql-VERSION'.
     With GNU `tar', no separate invocation of `gunzip' is necessary.
     You can use the following alternative command to uncompress and
     extract the distribution:
          shell> tar zxvf /PATH/TO/MYSQL-VERSION-OS.tar.gz

  6. Change location into the top-level directory of the unpacked
     distribution:
          shell> cd mysql-VERSION

     Note that currently you must configure and build MySQL from this
     top-level directory. You cannot build it in a different directory.

  7. Configure the release and compile everything:
          shell> ./configure --prefix=/usr/local/mysql
          shell> make
     When you run `configure', you might want to specify other options.
     Run `./configure --help' for a list of options.

     If `configure' fails and you are going to send mail to a MySQL
     mailing list to ask for assistance, please include any lines from
     `config.log' that you think can help solve the problem. Also
     include the last couple of lines of output from `configure'.

  8. Install the distribution:
          shell> make install

     You might need to run this command as `root'.
     If you want to set up an option file, use one of those present in
     the `support-files' directory as a template. For example:
          shell> cp support-files/my-medium.cnf /etc/my.cnf

     You might need to run this command as `root'.

     If you want to configure support for `InnoDB' tables, you should
     edit the `/etc/my.cnf' file, remove the `#' character before the
     option lines that start with `innodb_...', and modify the option
     values to be what you want.


  9. Change location into the installation directory:
          shell> cd /usr/local/mysql

10. If you ran the `make install' command as `root', the installed
     files will be owned by `root'. Ensure that the installation is
     accessible to `mysql' by executing the following commands as
     `root' in the installation directory:
          shell> chown -R mysql .
          shell> chgrp -R mysql .

     The first command changes the owner attribute of the files to the
     `mysql' user. The second changes the group attribute to the
     `mysql' group.

11. If you have not installed MySQL before, you must create the MySQL
     data directory and initialize the grant tables:
          shell> bin/mysql_install_db --user=mysql

     If you run the command as `root', include the `--user' option as
     shown. If you run the command while logged in as `mysql', you can
     omit the `--user' option.

     The command should create the data directory and its contents with
     `mysql' as the owner.

     After using `mysql_install_db' to create the grant tables for
     MySQL, you must restart the server manually. The `mysqld_safe'
     command to do this is shown in a later step.

12. Most of the MySQL installation can be owned by `root' if you like.
     The exception is that the data directory must be owned by `mysql'.
     To accomplish this, run the following commands as `root' in the
     installation directory:
          shell> chown -R root .
          shell> chown -R mysql var
13. If you want MySQL to start automatically when you boot your
     machine, you can copy `support-files/mysql.server' to the location
     where your system has its startup files. More information can be
     found in the `support-files/mysql.server' script itself.

14. You can set up new accounts using the `bin/mysql_setpermission'
     script if you install the `DBI' and `DBD::mysql' Perl modules.

After everything has been installed, you should test your distribution.
To start the MySQL server, use the following command:
     shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &

If you run the command as `root', you should use the `--user' option as
shown. The value of the option is the name of the login account that
you created in the first step to use for running the server. If you run
the command while logged in as that user, you can omit the `--user'
option.

If the command fails immediately and prints `mysqld ended', you can
find some information in the `HOST_NAME.err' file in the data directory.


The accounts that are listed in the MySQL grant tables initially have no passwords.  After starting the server, you should set up passwords for them.


本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/87863/showart_1686187.html
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

SACC2021中国系统架构师大会

【数字转型 架构重塑】2021年5月20日-22日第十三届中国系统架构师大会将在云端进行网络直播。

大会为期3天的议程,涉及20+专场,近120个主题,完整迁移到线上进行网络直播对会议组织来说绝非易事;但考虑到云端会议的直播形式可以实现全国各地技术爱好者的参与,也使ITPUB作为技术共享交流平台得到更好的普及,我们决定迎难而上。
http://sacc.it168.com/


大会官网>>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP