PERROR(1) MySQL Database System PERROR(1)

# [NAME](#NAME)

perror - display MySQL error message information

# [SYNOPSIS](#SYNOPSIS)

**perror \[options] errorcode ...**

# [DESCRIPTION](#DESCRIPTION)

**perror** displays the error message for MySQL or operating system error codes. Invoke **perror** like this:

```
perror [options] errorcode ...
```

**perror** attempts to be flexible in understanding its arguments. For example, for the ER\_WRONG\_VALUE\_FOR\_VAR error, **perror** understands any of these arguments: **1231**, 001231, MY-1231, or MY-001231, or ER\_WRONG\_VALUE\_FOR\_VAR.

```
$> perror 1231
MySQL error code MY-001231 (ER_WRONG_VALUE_FOR_VAR): Variable '%-.64s'
can't be set to the value of '%-.200s'
```

If an error number is in the range where MySQL and operating system errors overlap, **perror** displays both error messages:

```
$> perror 1 13
OS error code   1:  Operation not permitted
MySQL error code MY-000001: Can't create/write to file '%s' (OS errno %d - %s)
OS error code  13:  Permission denied
MySQL error code MY-000013: Can't get stat of '%s' (OS errno %d - %s)
```

To obtain the error message for a MySQL Cluster error code, use the **ndb\_perror** utility.

The meaning of system error messages may be dependent on your operating system. A given error code may mean different things on different operating systems.

**perror** supports the following options.

•**--help**, **--info**, **-I**, **-?** Display a help message and exit.

•**--silent**, **-s** Silent mode. Print only the error message.

•**--verbose**, **-v** Verbose mode. Print error code and message. This is the default behavior.

•**--version**, **-V** Display version information and exit.

# [COPYRIGHT](#COPYRIGHT)

Copyright © 1997, 2026, Oracle and/or its affiliates.

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

# [SEE ALSO](#SEE_ALSO)

For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/.

# [AUTHOR](#AUTHOR)

Oracle Corporation (http://dev.mysql.com/).

09/15/2026 MySQL 8.4

---

Document: perror(1) from mysql-8.4 8.4.13-r3 (Chainguard OS)
Source: https://github.com/mysql/mysql-server