nodejs入门之连接mysql

最近工作项目有调整，需要熟悉一些前端的内容，就顺便看看node，同时边学习边总结一下。这篇文章主要总结node链接mysql相关的各种问题。

示例Demo

准备环境：

  ➜  1  mkdir node-mysql
  ➜  1  cd node-mysql
  ➜  node-mysql  tnpm install mysql
  npm WARN saveError ENOENT: no such file or directory, open '/Volumes/Document/Document/temp/1/node-mysql/package.json'
  npm WARN enoent ENOENT: no such file or directory, open '/Volumes/Document/Document/temp/1/node-mysql/package.json'
  npm WARN node-mysql No description
  npm WARN node-mysql No repository field.
  npm WARN node-mysql No README data
  npm WARN node-mysql No license field.
	
  + mysql@2.16.0
  added 11 packages from 15 contributors and audited 13 packages in 1.524s
  found 0 vulnerabilities
	
  ➜  node-mysql  touch demo.js

准备事例代码，在demo.js中增加下面的代码

  var mysql = require('mysql');

  var con = mysql.createConnection({
    host: "127.0.0.1",
    user: "zixie",
    password: "zixie"
  });
	
  con.connect(function(err) {
      if (err) {
          throw err;
      }else{
          console.log("Connected to zixie!");
      }
  });
	
  con.query('SELECT 1 + 1 AS solution', function (err, results, fields) {
    	if (err) {
          throw err;
      }else{
          console.log('The solution is: ', results[0].solution);
      }
  });

运行测试效果：

  ➜  node-mysql  node demo.js
  Connected to zixie!
  The solution is:  2

异常处理

连接mysql失败，报错：ER_NOT_SUPPORTED_AUTH_MODE或添加权限出错

可能错误信息1

  throw err; // Rethrow non-MySQL errors
  ^

  Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

可能错误信息2

  mysql> ALTER USER 'zixie'@'localhost' IDENTIFIED WITH mysql_native_password BY 'zixie';
  ERROR 1396 (HY000): Operation ALTER USER failed for 'zixie'@'localhost'

解决方案

root登录登录mysql，并查看用户信息

  ➜  1  mysql -uroot -p
  Enter password:
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 39
  Server version: 8.0.13 Homebrew
		
  Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
		
  Oracle is a registered trademark of Oracle Corporation and/or its
  affiliates. Other names may be trademarks of their respective
  owners.
		
  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
		
  mysql> ALTER USER 'zixie'@'localhost' IDENTIFIED WITH mysql_native_password BY 'zixie';
  ERROR 1396 (HY000): Operation ALTER USER failed for 'zixie'@'localhost'
  mysql> use mysql
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A
		
  Database changed
  mysql> select user,host from user;
  +------------------+-----------+
  | user             | host      |
  +------------------+-----------+
  | zixie            | %         |
  | mysql.infoschema | localhost |
  | mysql.session    | localhost |
  | mysql.sys        | localhost |
  | root             | localhost |
  +------------------+-----------+
  5 rows in set (0.00 sec)

找到自己对应的账号，然后执行下面的授权命令，切记账号和host要对应：

  ALTER USER 'USERNAME'@'HOST' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';

例如

  mysql> ALTER USER 'zixie'@'%' IDENTIFIED WITH mysql_native_password BY 'zixie';
  Query OK, 0 rows affected (0.10 sec)
		
  mysql>

那时年少

微信公共平台

前端开发

开发资源

终端开发

开发工具

经验总结

玩一玩

在路上

后台开发

标签

总结 8

公共平台 3

wordpress 1

API 1

web 9

资源 4

android 50

log 1

adb 6

学习资源 1

md5 1

bug 7

svn 2

命令 3

常用工具 8

Markdown 3

markdown 2

工具 30

经验 3

SDK 22

Android 13

NDK 1

jni 1

个人作品 7

终端 1

测试 7

签名 1

iMac 13

调试 1

学习 1

gradle 7

ant 1

旅行 8

php 1

git 2

mac 2

java 1

androir 1

sqlite 1

mysql 1

tags 53

apk 5

图片 1

规划 1

chrome 1

iOS 1

jekyll 1

ruby 1

schema 1

自动 3

appium 2

linux 1

webview 1

开发资源 1

nodejs入门之连接mysql

「 后台开发 」 —— 2019年01月23日

[本文结构]

示例Demo

异常处理

「后台开发」 —— 2019年01月23日