본문 바로가기

MySQL9

NextJS 13 에서 DB 연동한 풀스택 만들때 에러 NextJS를 이용하여 mysql에 연동해서 만들때 npm run dev는 잘 작동 되나 npm run build는 ./node_modules/mysql/lib/Connection.js Module not found: Can't resolve 'net' https://nextjs.org/docs/messages/module-not-found Import trace for requested module: ./node_modules/mysql/index.js ./node_modules/mysql/lib/Connection.js Module not found: Can't resolve 'tls' https://nextjs.org/docs/messages/module-not-found Import trace f.. 2023. 3. 24.
Amazon EC2 nodejs mysql 설치 curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.39.3/install.sh | bash . ~/.nvm/nvm.sh nvm --version nvm install node node --version node: /lib64/libm.so.6: version `GLIBC_2.27' not found (required by node) node: /lib64/libc.so.6: version `GLIBC_2.25' not found (required by node) 위와 같은 에러 발생시 node 버전 다운 nvm ls-remote nvm install 16.19.1 node --version nvm ls ln -s /root/.nvm/versions/no.. 2023. 3. 10.
MySql Lock 풀기(PHPMyAdmin) SHOW PROCESSLIST; 실행 후 프로세서 ID 를 죽이면 됨 예) KILL {ID} PHPMyAdmin 에서는 UI에서 처리 가능 2016. 6. 21.
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13) 에러 대처방법 130218 11:03:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql130218 11:03:57 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.^G/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)130218 11:03:57 [ERROR] Aborting130218 11:03:57 [Note] /usr/libexec/mysqld: Shutdown complete130218.. 2013. 2. 18.