{"id":42533,"library":"connect-mysql-session","title":"connect-mysql-session","description":"A MySQL session store for connect, the Node.js middleware framework. Version 0.1.3 is the latest stable release. This package provides a straightforward way to persist session data in MySQL, leveraging the node-mysql driver. It is designed for older versions of Node.js (pre-0.6) and connect. Compared to more modern session stores like connect-mysql, this package is simple but lacks active maintenance and is incompatible with newer Node.js versions.","status":"deprecated","version":"0.1.3","language":"javascript","source_language":"en","source_url":"git://github.com/CarnegieLearning/connect-mysql-session","tags":["javascript"],"install":[{"cmd":"npm install connect-mysql-session","lang":"bash","label":"npm"},{"cmd":"yarn add connect-mysql-session","lang":"bash","label":"yarn"},{"cmd":"pnpm add connect-mysql-session","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Peer dependency: session store is intended for use with the connect framework.","package":"connect","optional":false},{"reason":"Required to interact with MySQL database.","package":"node-mysql","optional":false}],"imports":[{"note":"Package uses CommonJS, ESM not supported.","wrong":"import MySQLStore from 'connect-mysql-session';","symbol":"default","correct":"var MySQLStore = require('connect-mysql-session');"},{"note":"connect is a CommonJS module.","wrong":"import connect from 'connect';","symbol":"connect","correct":"var connect = require('connect');"},{"note":"node-mysql is CommonJS.","wrong":"import mysql from 'node-mysql';","symbol":"node-mysql","correct":"var mysql = require('node-mysql');"}],"quickstart":{"code":"var connect = require('connect');\nvar MySQLStore = require('connect-mysql-session');\nvar mysql = require('node-mysql');\n\nvar db = mysql.createClient({\n  host: process.env.MYSQL_HOST || 'localhost',\n  port: process.env.MYSQL_PORT || 3306,\n  user: process.env.MYSQL_USER || 'root',\n  password: process.env.MYSQL_PASSWORD || ''\n});\n\ndb.query('CREATE DATABASE IF NOT EXISTS session_test');\ndb.query('USE session_test');\ndb.query('CREATE TABLE IF NOT EXISTS sessions (session_id VARCHAR(255) PRIMARY KEY, expires VARCHAR(255), data TEXT)');\n\nvar sessionStore = new MySQLStore(db, {\n  table: 'sessions'\n});\n\nvar app = connect();\napp.use(connect.cookieParser());\napp.use(connect.session({ store: sessionStore, secret: 'keyboard cat' }));\napp.use(function(req, res){\n  req.session.views = (req.session.views || 0) + 1;\n  res.end('views: ' + req.session.views);\n});\napp.listen(3000);","lang":"javascript","description":"Sets up a connect app with MySQL-backed session store, creating database and table if not exist."},"warnings":[{"fix":"Migrate to a maintained session store like connect-mysql or express-mysql-session.","message":"Package is no longer maintained and uses outdated dependencies.","severity":"deprecated","affected_versions":">=0.0.0"},{"fix":"Use an alternative session store with current Node.js support.","message":"Requires Node.js ~0.4, incompatible with modern Node.js versions.","severity":"breaking","affected_versions":">=0.1.0"},{"fix":"Execute CREATE TABLE statement before using the store.","message":"The session table must be created manually; automatic table creation is not supported.","severity":"gotcha","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'-0.6':49 '0.1.3':16 'activ':68 'compar':52 'connect':2,10,51,60 'connect-mysql':59 'connect-mysql-sess':1 'data':31 'design':42 'driver':39 'framework':14 'incompat':72 'javascript':77 'lack':67 'latest':19 'leverag':34 'like':58 'mainten':69 'middlewar':13 'modern':55 'mysql':3,6,33,38,61 'newer':74 'node':37 'node-mysql':36 'node.js':12,47,75 'older':44 'packag':23,63 'persist':29 'pre':48 'provid':24 'releas':21 'session':4,7,30,56 'simpl':65 'stabl':20 'store':8,57 'straightforward':26 'version':15,45,76 'way':27","created_at":"2026-06-05T16:55:26.137737+00:00","updated_at":"2026-06-05T16:55:26.137737+00:00","problems":[{"fix":"Run 'npm install connect-mysql-session' in your project directory.","cause":"Package not installed or module resolution fails.","error":"Error: Cannot find module 'connect-mysql-session'"},{"fix":"Ensure you call mysql.createClient() and pass the client, not the mysql module.","cause":"The MySQL client instance is not initialized properly.","error":"TypeError: Object #<Object> has no method 'query'"},{"fix":"Provide the store option: connect.session({ store: sessionStore, secret: '...' })","cause":"Session store not passed to connect.session() middleware.","error":"Error: connect.session() requires a session store"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"git://github.com/CarnegieLearning/connect-mysql-session","github":"git://github.com/CarnegieLearning/connect-mysql-session","docs":null,"changelog":null,"pypi":null,"npm":"connect-mysql-session","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}