Server Command Options
419
•
--safe-user-create
[419]
Command-Line Format
--safe-user-create
Option-File Format
safe-user-create
Permitted Values
Type
boolean
Default
FALSE
If this option is enabled, a user cannot create new MySQL users by using the
GRANT
statement
unless the user has the
INSERT
[577]
privilege for the
mysql.user
table or any column in the
table. If you want a user to have the ability to create new users that have those privileges that the
user has the right to grant, you should grant the user the following privilege:
GRANT INSERT(user) ON mysql.user TO '
user_name
'@'
host_name
';
This ensures that the user cannot change any privilege columns directly, but has to use the
GRANT
statement to give privileges to other users.
•
--secure-auth
[419]
Command-Line Format
--secure-auth
Option-File Format
secure-auth
Option Sets Variable
Yes,
secure_auth
[490]
Variable Name
secure_auth
Variable Scope
Global
Dynamic Variable
Yes
This option causes the server to block connections by clients that attempt to use accounts that have
passwords stored in the old (pre-4.1) format. Use it to prevent all use of passwords employing the old
format (and hence insecure communication over the network).
Server startup fails with an error if this option is enabled and the privilege tables are in pre-4.1
format. See
Section C.5.2.4, “
Client does not support authentication protocol
”
.
The
mysql
client also has a
--secure-auth
[269]
option, which prevents connections to a server if
the server requires a password in old format for the client account.
•
--secure-file-priv=path
[419]
Version Introduced
5.0.38
Command-Line Format
--secure-file-priv=path
Option-File Format
secure-file-priv=path
Option Sets Variable
Yes,
secure_file_priv
[490]
Variable Name
secure-file-priv
Variable Scope
Global
Dynamic Variable
No
Permitted Values
Type
string
This option limits the effect of the
LOAD_FILE()
[890]
function and the
LOAD DATA
and
SELECT ... INTO OUTFILE
statements to work only with files in the specified directory.
This option was added in MySQL 5.0.38.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...