DB

MySQL 8.0 Keywords and Reserved Words

2018-07-04 KENNETH 0

URL : https://dev.mysql.com/doc/refman/8.0/en/keywords.html   MySQL 8.0 Keywords and Reserved Words The following list shows the keywords and reserved words in MySQL 8.0, along with changes to individual words from version to version. Reserved keywords are marked with (R). In addition, _FILENAME is reserved. At some point, you might upgrade to a higher version, so it is a good idea to have a look at future reserved words, too. You can find these in the manuals that cover higher versions of MySQL. Most of the reserved words in the list are forbidden by standard SQL as column or table names (for example, GROUP). A few are reserved because MySQL needs them and uses a yacc parser.   A ACCESSIBLE (R) ACCOUNT ACTION ADD (R) ADMIN became nonreserved in 8.0.12 AFTER AGAINST AGGREGATE ALGORITHM ALL (R) ALTER (R) ALWAYS ANALYSE removed in 8.0.1 [ more… ]

No Image

mysql server system variables log_warnings to log_error_verbosity

2016-10-04 KENNETH 0

url : http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html   under 5.7.2 : log_warnings over 5.7.2 : log_error_verbosity   log_warnings Deprecated 5.7.2 Command-Line Format –log-warnings[=#] System Variable Name log_warnings Variable Scope Global Dynamic Variable Yes Permitted Values (32-bit platforms, <= 5.7.1) Type integer Default 1 Min Value 0 Max Value 4294967295 Permitted Values (32-bit platforms, >= 5.7.2) Type integer Default 2 Min Value 0 Max Value 4294967295 Permitted Values (64-bit platforms, <= 5.7.1) Type integer Default 1 Min Value 0 Max Value 18446744073709551615 Permitted Values (64-bit platforms, >= 5.7.2) Type integer Default 2 Min Value 0 Max Value 18446744073709551615 Whether to produce additional warning messages to the error log. This variable is enabled by default (the default is 1 before MySQL 5.7.2, 2 as of 5.7.2). To disable it, set it to 0. The server logs messages about statements that are unsafe for statement-based logging if the [ more… ]

No Image

[mysql] Buffered warning: Could not increase number of max_open_files to more than 1024 on centos

2016-09-07 KENNETH 0

OS : CentOS7 MySQL : install rpm package from mysql official repository 1. mysql error log [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 16384) [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 3000) [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 2048) 2. modify service file file path : /usr/lib/systemd/system/mysqld.service add LimitNOFILE=163840 LimitNPROC=163840 3. reload # systemctl daemon-reload for this error message… Warning: mysqld.service changed on disk. Run ’systemctl daemon-reload’ to reload units. 4. Restart mysql # service mysqld restart

No Image

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MariaDB client in /home1/htdocs/apartzm/affisacc/php/acc_tongys.inc.php on line 188ERROR 1251: Client does not smysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

2016-07-26 KENNETH 0

mysql(mariadb) 접근시 mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client 또는 mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MariaDB client 오류가 발생한다면…   구버전의 mysql 클라이언트가 신 버전의 mysql 서버로 접근하는 경우 좀더 정확히는… mysql서버의 old_passwords 설정이 ”0(off)” 정책으로 운영되어 생성된 계정의 패스워드가 새로운 패스워드 정책을 사용하지만 클라이언트는 이를 지원하지 못하는 버전인 경우에 발생함 접근하고자 하는 유저의 패스워드를 구버전 형태로 변경해주면 된다. (서버의 old_passwords 옵션을 건드릴 필요는 없음…. 필요한 계정에 대해서만 처리해주면 됨) update user set password=old_password(‘변경할 패스워드’) where user=’변경 대상 유저’; flush privileges; 변경 대상 유저는 choilha, 변경할 패스워드는 “1234” 라고 한다면 update user set password=old_password(‘1234′) where user=’choilha’; 이렇게..   처리하면 됨…