Skip to content

Instantly share code, notes, and snippets.

View devheedoo's full-sized avatar
☺️
React + TypeScript

heedo devheedoo

☺️
React + TypeScript
  • Seoul, South Korea
View GitHub Profile

MacOS에서 MySQL 설치 도중 다음과 같은 오류가 발생했다:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock (2)'

아래 명령어까지는 정상적으로 실행됐다:

brew install mysql

발생 원인

MySQL 을 사용하는 경우,

ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client

위와 같은 오류를 만났다면 이는 암호화 방식의 차이 때문이다.

@devheedoo
devheedoo / sql.md
Last active February 2, 2017 01:46
Document for simple sql works

SQL

MySQL

$ mysql -u root -p

Dump

Import

$ mysqldump -u root -p --routines [dbname] > [filename].sql;

$ mysqldump -u root -p --routines --all-databases > [filename].sql;

Export

@devheedoo
devheedoo / https.js
Last active December 16, 2016 04:07
redirect to https
// If user types www.example.com, browser opens http://www.example.com by default.
var url = "https://www.example.com";
window.location.replace(url);
@devheedoo
devheedoo / OracleConnectTest.jsp
Created December 12, 2016 08:44
Test oracle connection
<%@ page contentType="text/html; charset=EUC-KR" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR" />
<title>Oracle Connection Test</title>
</head>
<body>
<h1>Oracle Connection Text</h1>
@devheedoo
devheedoo / header.html
Created December 12, 2016 08:35
things that must added to header
<!-- set IE Browser's version latest-->
<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
@devheedoo
devheedoo / auth.jsp
Created December 8, 2016 05:37
codes related with authentication
<!-- Change your id from "myUserId" to "my******" -->
<c:forEach var="i" begin="0" end="${fn:length(id)-1}">
<c:choose>
<c:when test="${i <= 1}">
<c:out var="${id.charAt(i)}" />
</c:when>
<c:otherwise>
<c:out var="*" />
</c:otherwise>
@devheedoo
devheedoo / compability.md
Last active December 8, 2016 01:02
Notes for compability among browsers

JavaScript

.includes()

// IE8 : custom declaration of indexOf()
if(!Array.indexOf){
  Array.prototype.indexOf = function(obj){
    for(var i=0; i<this.length; i++){
      if(this[i]==obj){
        return i;
 }
@devheedoo
devheedoo / detectIE.html
Last active October 14, 2017 13:14
Total IE Detection using conditional comments (<10) and JavsScript (10, 11)
<!-- Tested on 2016. 12. 5. -->
<body>
<!-- IE8 -->
<!--[IF IE 8]>
<p>isIE8</p>
<![endif]-->
<!-- IE9 -->
<!--[IF IE 9]>
<p>isIE9</p>