Mysql – Erro MYSQL #1193 – Unknown system variable ‘lc_messages’

MySQL

Can anyone help me with this error. From several searches on the Net I have not found a solution. I'm using version 7.0.10 of PHP and when I try to log in to phpMyAdmin, the following message appears:

Erro

Comando SQL: Edita Edita

SET lc_messages = 'pt_PT';

Mensagens do MySQL : Documentação
#1193 – Unknown system variable 'lc_messages'

One other detail is I have installed Workbench version 6 and MySQL 5.1.

Best Answer

SET lc_messages = ... doesn't work in MySQL Server 5.1. This variable was introduced in 5.5.

Before MySQL 5.5, the lc_messages_dir and lc_messages system variables were unavailable.

To start mysqld with a particular language for error messages, the --language or -L option were used. The option value can be a language name or the full path to the error message file.

https://dev.mysql.com/doc/refman/5.5/en/error-message-language.html

Related Solutions

Mysql – My MySQL server time is not the same as the Server

I had this exact same problem after I had updated my server time. I just had to restart the MySql server then it reset the time to match my server time.

/etc/init.d/mysqld restart

Reference - https://major.io/2007/07/01/mysql-time-zone-different-from-system-time-zone/

MySQL Version Differences – Differences Between MySQL 5.1.73-Community-Log and 5.1.73-Community

They are the same software. The -log suffix is simply appended to the version string at runtime.

Here's an explanation (nearly from the last century), by long-time MySQL author Paul DuBois:

I want to know what the -log means and how it got in there.

-log is added if you start the server with logging turned on.

-debug is added if you're running a debugging version of the server with debugging on.

-demo is added if the server is running in demo mode

I verified this in the source, in sql/mysqld.cc, function set_server_version():

. . .
if (opt_log || opt_slow_log || opt_bin_log)
  strmov(end, "-log");                        // This may slow down system
. . .

I think the meaning of that comment is not that appending four extra characters to the version slows down the system, but that logging may slow down the system, so it's worth noting to the DBA that logging is enabled.

Best Answer

Related Solutions

Mysql – My MySQL server time is not the same as the Server

MySQL Version Differences – Differences Between MySQL 5.1.73-Community-Log and 5.1.73-Community

Related Question