Oracle 5.0, Справочное руководство

Страница: 132 / 3232

Installing MySQL from a Standard Source Distribution
112
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,
removing the
#
character before the option lines that start with
innodb_...
, and modify the option
values to be what you want. See Section 4.2.3.3, “Using Option Files” , and Section 14.2.1, “
InnoDB
Configuration” .
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 the plugin directory is writable by the server, it may be possible for a user to write executable
code to a file in the directory using
SELECT ... INTO DUMPFILE
. This can be prevented by
making
plugin_dir
[481] read only to the server or by setting
--secure-file-priv
[419]
to a directory where
SELECT
writes can be made safely.
14. 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; see also Section 2.18.1.2,
“Starting and Stopping MySQL Automatically” .
15. You can set up new accounts using the
bin/mysql_setpermission
script if you install
the
DBI
and
DBD::mysql
Perl modules. See Section 4.6.15, “
mysql_setpermission
—
Interactively Set Permissions in Grant Tables” . For Perl module installation instructions, see
Section 2.22, “Perl Installation Notes” .
After everything has been installed, test the distribution. To start the MySQL server, use the following
command:
shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &