Monthly Archives: February 2018

sqlite3 compilation

Posted on February 21, 2018 by Shixun

sqlite3 compilation on VS2017 出現 1>sqlite3.c(39053): error C4996: ‘GetVersionExA’: 宣告為已被取代 1>C:\Program Files (x86)\Windows Kits\8.1\Include\um\sysinfoapi.h(433): note: 請參閱 ‘GetVersionExA’ 的宣告 1>sqlite3.c(39063): error C4996: ‘GetVersionExW’: 宣告為已被取代 1>C:\Program Files (x86)\Windows Kits\8.1\Include\um\sysinfoapi.h(442): note: 請參閱 ‘GetVersionExW’ 的宣告 在 sqite3.c加上 #pragma warning(disable: 4996) 即可

Posted in Library | Leave a comment

mysql install

Posted on February 16, 2018 by Shixun

MySQL install on CentOS 7 從官網下載yum repo https://dev.mysql.com/downloads/repo/yum/ mysql57-community-release-el7-11.noarch.rpm 安裝 yum -y install mysql-community-server.x86_64 重設root password 如果忘記root密碼 需要重設時 先打開skip-grant-tables選項 可在/etc/my.cnf [mysqld]下加上 skip-grant-tables /etc/my.cnf [mysqld] skip-grant-tables #… 然後重啟server mysql -u root 即可登入進去，但注意 重設password會跳出error說還是在skip-grant-tables mode 此時先刷新privileges flush privileges; 再來將password重設 shell> mysql -u … Continue reading →

Posted in System Administration | Leave a comment