Rechercher dans le manuel MySQL
perror displays the error message for MySQL or operating system error codes. Invoke perror like this:
shell> 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
.
shell> 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:
shell> 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.
Display a help message and exit.
Print the error message for a MySQL Cluster error code.
This option was removed in MySQL 8.0.13. Use the ndb_perror utility instead.
--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.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-perror.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.