我的socket.io project在XAMPP上的HTDOCS文件上,我在server.js文件上定义了数据库,我检查了我的数据库表是否来自Cormend Line
/opt/lampp/bin/mysql -u root
MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| users |
| fbstatus |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
但是,当我在终端中运行node server
时,我会遇到此错误
Error: ER_DBACCESS_DENIED_ERROR: Access denied for user ''@'localhost' to database 'users'
我的软件包.json文件
{
"name": "iochat",
"version": "1.0.0",
"description": "Simple chat app",
"main": "server.js",
"scripts": {
"test": "echo "Error: no test specified" && exit 1"
},
"author": "shar",
"license": "ISC",
"dependencies":{
"socket.io":"*",
"express":"*"
}
}
my server.js file
var express = require('express');
var app = express();
var server = require('http').createServer(app);
var io = require('socket.io').listen(server);
var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost'
, database: 'users'
, username: 'root'
, password: ''
});
connection.connect();
users = [];
connections = [];
server.listen(process.env.PORT || 3000);
console.log('Server running...');
app.get('/', function(req, res){
res.sendFile(__dirname + '/index.html');
});
io.sockets.on('connection', function(socket){
//con
connections.push(socket);
console.log('connected: %s socket connected', connections.length);
connection.query("UPDATE users SET onoff= '8' WHERE UserName='shakoo'");
//discon
socket.on('disconnect',function(data){
users.splice(users.indexOf(socket.username),1);
updateUsernames();
connections.splice(connections.indexOf(socket), 1);
console.log('Disconnected: %s sockets connected', connections.length);
});
//send message
socket.on('send message', function(data){
io.sockets.emit('new message', {msg: data, user: socket.username});
});
//new user
socket.on('new user', function(data, callback){
callback(true);
socket.username = data;
users.push(socket.username);
updateUsernames();
});
function updateUsernames(){
io.sockets.emit('get users', users);
}
});
proplem在这里
, username: 'root'
应该是
user: 'root',
我忘记将mysql定义添加到package.json文件
"dependencies":{
"socket.io":"*",
"express":"*",
"mysql": "2.13.0"
}