password 함수가 맞지않을때


 


my.cnf 혹은 html안에 common.php 수정


 


 @mysql_query('set old_passwords=0'); 


 


 


예)


$dirname = dirname(__FILE__).'/';

$dbconfig_file = "dbconfig.php";

if (file_exists("$g4[path]/$dbconfig_file"))

{

    if (is_dir("$g4[path]/install")) die("<meta http-equiv='content-type' content='text/html; charset=$g4[charset]'><script type='text/javascript'> alert('install ?~T?~I?좊

━瑜???젣?~X?ъ~U??~U?~A ?ㅽ~V~I?⑸~K~H??'); </script>");


    include_once("$g4[path]/$dbconfig_file");

    $connect_db = sql_connect($mysql_host, $mysql_user, $mysql_password);

    $select_db = sql_select_db($mysql_db, $connect_db);



        @mysql_query('set old_passwords=0');


    if (!$select_db)

        die("<meta http-equiv='content-type' content='text/html; charset=$g4[charset]'><script type='text/javascript'> alert('DB ?~Q?~M ?ㅻ쪟'); </script>");

}

else

{

    echo "<meta http-equiv='content-type' content='text/html; charset=$g4[charset]'>";

    echo <<<HEREDOC

    <script type="text/javascript">

    alert("DB ?ㅼ젙 ?~L?쇱~]?議댁~^ы~U~X吏~@ ?~J?듬~K~H??\\n\\n?~D濡~\洹몃~^??ㅼ튂 ?~D ?ㅽ~V~I?~X?~\湲?諛~T?~M?~H??");

    location.href = "./install/";

    </script>

HEREDOC;

    exit;


 


 


 


mysql db 관련 


 


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line

에러


 


 


 


MySQL 4.x는 TYPE=MyISAM

MySQL 5.x는 ENGINE=MyISAM 


 


해당 덤프 파일 vi로 열고


: $s/TYPE=MyISAM/ENGINE=MyISAM/g 

pdate TB_TEST set test_path = REPLACE(test_path,"www.naver.com","www.daum.net");

'job > mysql' 카테고리의 다른 글

마리아디비 mariadb slow query log 적용 안될 때  (0) 2019.01.21
mysql old패스워드 password 함수 동시 사용  (0) 2018.09.03
mysql history 로그 설정  (0) 2018.09.03
mysql 컴파일시 옵션 설명  (0) 2018.09.03
mysql select 문  (0) 2018.09.03

dmidecode -t 17 | egrep 'Memory|Size'


 


 


 


smartctl -i /dev/sda 

+ Recent posts