1PERROR(1) MySQL Database System PERROR(1)
2
3
4
6 perror - display MySQL error message information
7
9 perror [options] errorcode ...
10
12 perror displays the error message for MySQL or operating system error
13 codes. Invoke perror like this:
14
15 perror [options] errorcode ...
16
17 perror attempts to be flexible in understanding its arguments. For
18 example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any
19 of these arguments: 1231, 001231, MY-1231, or MY-001231, or
20 ER_WRONG_VALUE_FOR_VAR.
21
22 shell> perror 1231
23 MySQL error code MY-001231 (ER_WRONG_VALUE_FOR_VAR): Variable '%-.64s'
24 can't be set to the value of '%-.200s'
25
26 If an error number is in the range where MySQL and operating system
27 errors overlap, perror displays both error messages:
28
29 shell> perror 1 13
30 OS error code 1: Operation not permitted
31 MySQL error code MY-000001: Can't create/write to file '%s' (OS errno %d - %s)
32 OS error code 13: Permission denied
33 MySQL error code MY-000013: Can't get stat of '%s' (OS errno %d - %s)
34
35 To obtain the error message for a MySQL Cluster error code, use the
36 ndb_perror utility.
37
38 The meaning of system error messages may be dependent on your operating
39 system. A given error code may mean different things on different
40 operating systems.
41
42 perror supports the following options.
43
44 • --help, --info, -I, -? Display a help message and exit.
45
46 • --ndb Print the error message for a MySQL Cluster error code.
47
48 This option was removed in MySQL 8.0.13. Use the ndb_perror utility
49 instead.
50
51 • --silent, -s Silent mode. Print only the error message.
52
53 • --verbose, -v Verbose mode. Print error code and message. This is
54 the default behavior.
55
56 • --version, -V Display version information and exit.
57
59 Copyright © 1997, 2021, Oracle and/or its affiliates.
60
61 This documentation is free software; you can redistribute it and/or
62 modify it only under the terms of the GNU General Public License as
63 published by the Free Software Foundation; version 2 of the License.
64
65 This documentation is distributed in the hope that it will be useful,
66 but WITHOUT ANY WARRANTY; without even the implied warranty of
67 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
68 General Public License for more details.
69
70 You should have received a copy of the GNU General Public License along
71 with the program; if not, write to the Free Software Foundation, Inc.,
72 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
73 http://www.gnu.org/licenses/.
74
75
77 For more information, please refer to the MySQL Reference Manual, which
78 may already be installed locally and which is also available online at
79 http://dev.mysql.com/doc/.
80
82 Oracle Corporation (http://dev.mysql.com/).
83
84
85
86MySQL 8.0 09/04/2021 PERROR(1)