Posts in 2021
-
Most votes on nginx questions 2
May 01, 2021 in FAQ
Most votes on nginx questions 2. #11 How to clear the cache of nginx? #12 Nginx location priority #13 Configure nginx with multiple locations with different root folders on subdomain #14 nginx - client_max_body_size has no effect #15 Nginx 403 error: directory index of [folder] is forbidden #16 Nginx 403 forbidden for all files #17 How do I prevent a Gateway Timeout with FastCGI on Nginx #18 nginx missing sites-available directory #19 Kubernetes service external ip pending #20 How can I have same rule for two locations in NGINX config?
Read all the top votes questions and answers in a single page. #11: How to clear the cache of nginx? (Score: 270) Created: 2011-06-04 Last updated: 2020-01-06 Tags: css, nginx, caching, server, nginx-cache I use nginx to as the front server, I have …
-
Most votes on nginx questions 10
May 01, 2021 in FAQ
Most votes on nginx questions 10. #91 NGINX gzip not compressing JavaScript files #92 How to preserve request url with nginx proxy_pass #93 nginx: connect() failed (111: Connection refused) while connecting to upstream #94 EventSource / Server-Sent Events through Nginx #95 Why do HTTP servers forbid underscores in HTTP header names #96 Nginx subdomain configuration #97 PHP-FPM and Nginx: 502 Bad Gateway #98 Why use Mongrel2? #99 Simple NGINX log file analyzer #100 Nginx will not start (Address already in use)
Read all the top votes questions and answers in a single page. #91: NGINX gzip not compressing JavaScript files (Score: 81) Created: 2014-05-29 Last updated: 2015-04-21 Tags: nginx All JavaScript files are not compressed by nginx gzip. CSS files are …
-
Most votes on nginx questions 1
May 01, 2021 in FAQ
Most votes on nginx questions 1. #1 From inside of a Docker container, how do I connect to the localhost of the machine? #2 Node.js + Nginx - What now? #3 Nginx – static file serving confusion with root & alias #4 Nginx no-www to www and www to no-www #5 Where can I find the error logs of nginx, using FastCGI and Django? #6 (13: Permission denied) while connecting to upstream:[nginx] #7 NGinx Default public www location? #8 nginx error connect to php5-fpm.sock failed (13: Permission denied) #9 nginx - nginx: [emerg] bind() to [::]:80 failed (98: Address already in use) #10 upstream sent too big header while reading response header from upstream
Read all the top votes questions and answers in a single page. #1: From inside of a Docker container, how do I connect to the localhost of the machine? (Score: 1969) Created: 2014-06-20 Last updated: 2019-11-09 Tags: nginx, docker, reverse-proxy, …
-
Most votes on mysql questions 9
May 01, 2021 in FAQ
Most votes on mysql questions 9. #81 ERROR 1698 (28000): Access denied for user 'root'@'localhost' #82 MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) #83 Run MySQLDump without Locking Tables #84 Maximum length for MySQL type text #85 MySQL DROP all tables, ignoring foreign keys #86 How to delete a column from a table in MySQL #87 How to retrieve the current version of a MySQL database management system (DBMS)? #88 MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes #89 Convert from MySQL datetime to another format with PHP #90 Is there an SQLite equivalent to MySQL's DESCRIBE [table]?
Read all the top votes questions and answers in a single page. #81: ERROR 1698 (28000): Access denied for user 'root'@'localhost' (Score: 470) Created: 2016-09-01 Last updated: 2019-11-09 Tags: mysql, iredmail I’m setting up a new server and …
-
Most votes on mysql questions 8
May 01, 2021 in FAQ
Most votes on mysql questions 8. #71 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) #72 Error installing mysql2: Failed to build gem native extension #73 How to show the last queries executed on MySQL? #74 List of Stored Procedures/Functions Mysql Command Line #75 MySQL select 10 random rows from 600K rows fast #76 How to convert an entire MySQL database characterset and collation to UTF-8? #77 How to do 3 table JOIN in UPDATE query? #78 Error related to only_full_group_by when executing a query in MySql #79 How to run SQL script in MySQL? #80 How to take backup of a single table in a MySQL database?
Read all the top votes questions and answers in a single page. #71: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Score: 507) Created: 2012-07-25 Last updated: 2016-11-03 Tags: mysql, …
-
Most votes on mysql questions 7
May 01, 2021 in FAQ
Most votes on mysql questions 7. #61 MySql export schema without data #62 How to do a regular expression replace in MySQL? #63 How can I view live MySQL queries? #64 What is the size of column of int(11) in mysql in bytes? #65 Delete with Join in MySQL #66 Authentication plugin 'caching_sha2_password' cannot be loaded #67 When to use MongoDB or other document oriented database systems? #68 How to see indexes for a database or table in MySQL? #69 MySQL: @variable vs. variable. What's the difference? #70 Create a temporary table in a SELECT statement without a separate CREATE TABLE
Read all the top votes questions and answers in a single page. #61: MySql export schema without data (Score: 553) Created: 2011-05-30 Last updated: 2013-01-13 Tags: mysql, sql I’m using a MySql database with a Java program, now I want to give …
-
Most votes on mysql questions 6
May 01, 2021 in FAQ
Most votes on mysql questions 6. #51 How do I see all foreign keys to a table or column? #52 How to get size of mysql database? #53 Skip certain tables with mysqldump #54 #1071 - Specified key was too long; max key length is 767 bytes #55 MySQL string replace #56 How do I restore a dump file from mysqldump? #57 How to shrink/purge ibdata1 file in MySQL #58 How do I change the data type for a column in MySQL? #59 MySQL - UPDATE query based on SELECT Query #60 MySql export schema without data
Read all the top votes questions and answers in a single page. #51: How do I see all foreign keys to a table or column? (Score: 624) Created: 2008-10-14 Last updated: 2017-05-23 Tags: mysql, foreign-keys, innodb In MySQL, how do I get a list of all …
-
Most votes on mysql questions 5
May 01, 2021 in FAQ
Most votes on mysql questions 5. #41 MySQL Query GROUP BY day / month / year #42 How can I temporarily disable a foreign key constraint in MySQL? #43 SQL injection that gets around mysql_real_escape_string() #44 How do I see what character set a MySQL database / table / column is? #45 When to use single quotes, double quotes, and backticks in MySQL #46 Find duplicate records in MySQL #47 Create new user in MySQL and give it full access to one database #48 MySQL Error 1093 - Can't specify target table for update in FROM clause #49 MySQL: Grant all privileges on database #50 Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
Read all the top votes questions and answers in a single page. #41: MySQL Query GROUP BY day / month / year (Score: 703) Created: 2009-02-03 Last updated: 2020-03-20 Tags: mysql, sql, date, datetime, group-by Is it possible to make a simple query to …
-
Most votes on mysql questions 4
May 01, 2021 in FAQ
Most votes on mysql questions 4. #31 TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes #32 Finding duplicate values in MySQL #33 How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL? #34 What is the best collation to use for MySQL with PHP? #35 Duplicating a MySQL table, indices, and data #36 Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server #37 How to do a FULL OUTER JOIN in MySQL? #38 'IF' in 'SELECT' statement - choose output value based on column values #39 How to truncate a foreign key constrained table? #40 Disable ONLY_FULL_GROUP_BY
Read all the top votes questions and answers in a single page. #31: TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes (Score: 846) Created: 2012-12-18 Last updated: 2017-08-08 Tags: mysql, innodb Per the MySQL docs, there are four TEXT …
-
Most votes on mysql questions 3
May 01, 2021 in FAQ
Most votes on mysql questions 3. #21 mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource #22 How do you set a default value for a MySQL Datetime column? #23 How do I specify unique constraint for multiple columns in MySQL? #24 Join vs. sub-query #25 MySQL error code: 1175 during UPDATE in MySQL Workbench #26 How to 'insert if not exists' in MySQL? #27 How to find all the tables in MySQL with specific column names in them? #28 MyISAM versus InnoDB #29 MySQL: Large VARCHAR vs. TEXT? #30 "INSERT IGNORE" vs "INSERT … ON DUPLICATE KEY UPDATE"
Read all the top votes questions and answers in a single page. #21: mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource (Score: 975) Created: 2010-06-04 Last updated: 2020-04-08 …