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

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

Installation-Related Issues
2959
See also Section 5.1.3, “Server Command Options” , and Section 21.3.1.7, “Making a Test Case If You
Experience Table Corruption” .
C.5.3. Installation-Related Issues
C.5.3.1. Problems with File Permissions
If you have problems with file permissions, the
UMASK
environment variable might be set incorrectly
when
mysqld
starts. For example, MySQL might issue the following error message when you create a
table:
ERROR: Can't find file: 'path/with/filename.frm' (Errcode: 13)
The default
UMASK
value is
0660
. You can change this behavior by starting
mysqld_safe
as follows:
shell> UMASK=384 # = 600 in octal
shell> export UMASK
shell> mysqld_safe &
By default, MySQL creates database and
RAID
directories with an access permission value of
0700
.
You can modify this behavior by setting the
UMASK_DIR
variable. If you set its value, new directories
are created with the combined
UMASK
and
UMASK_DIR
values. For example, if you want to give group
access to all new directories, you can do this:
shell> UMASK_DIR=504 # = 770 in octal
shell> export UMASK_DIR
shell> mysqld_safe &
MySQL assumes that the value for
UMASK
or
UMASK_DIR
is in octal if it starts with a zero.
See Section 2.21, “Environment Variables” .
C.5.4. Administration-Related Issues
C.5.4.1. How to Reset the Root Password
If you have never set a
root
password for MySQL, the server does not require a password at all
for connecting as
root
. However, this is insecure. For instructions on assigning passwords, see
Section 2.18.2, “Securing the Initial MySQL Accounts” .
If you know the
root
password, but want to change it, see Section 13.7.1.6, “
SET PASSWORD
Syntax” .
If you set a
root
password previously, but have forgotten it, you can set a new password. The
following sections provide instructions for Windows and Unix systems, as well as generic instructions
that apply to any system.
C.5.4.1.1. Resetting the Root Password: Windows Systems
On Windows, use the following procedure to reset the password for all MySQL
root
accounts:
1. Log on to your system as Administrator.
2. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to
the Services manager: From the Start menu, select Control Panel, then Administrative Tools, then
Services. Find the MySQL service in the list and stop it.
If your server is not running as a service, you may need to use the Task Manager to force it to stop.
3. Create a text file containing the following statements. Replace the password with the password that
you want to use.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';