在 Ubuntu 上用 Node.js 连接要看你具体想连什么(MySQL、MongoDB、Redis、PostgreSQL、SSH、API 等)。下面给你常见场景的通用做法 + 示例,你可以直接对照用。
node -v
npm -v
如果没有:
sudo apt update
sudo apt install nodejs npm
推荐安装 LTS(更稳):
curl -fsSL https://deb.nodesource.com/setup_lts.x | sudo -E bash -
sudo apt install -y nodejs
npm install mysql2
const mysql = require('mysql2/promise');
async function main() {
const conn = await mysql.createConnection({
host: 'localhost',
user: 'root',
password: '123456',
database: 'test'
});
const [rows] = await conn.execute('SELECT NOW()');
console.log(rows);
}
main();
npm install mongoose
const mongoose = require('mongoose');
mongoose.connect('mongodb://127.0.0.1:27017/test')
.then(() => console.log('MongoDB connected'))
.catch(err => console.error(err));
npm install pg
const { Client } = require('pg');
const client = new Client({
host: 'localhost',
user: 'postgres',
password: '123456',
database: 'test',
port: 5432
});
client.connect();
client.query('SELECT NOW()', (err, res) => {
console.log(res.rows);
client.end();
});
npm install redis
const redis = require('redis');
const client = redis.createClient();
client.on('error', err => console.error(err));
client.connect().then(() => {
client.set('name', 'ubuntu-node');
client.get('name').then(val => console.log(val));
});
const axios = require('axios');
axios.get('https://api.github.com')
.then(res => console.log(res.data))
.catch(err => console.error(err));
const net = require('net');
const client = net.createConnection(8080, '127.0.0.1', () => {
client.write('hello');
});
client.on('data', data => {
console.log(data.toString());
});
systemctl status mysqlsudo ufw statussudo usermod -aG user_name $USER
你可以直接告诉我:
我可以一步一步帮你排错 ✅