# Node-red-contrib-mysql2 node

**URL:** https://discourse.nodered.org/t/node-red-contrib-mysql2-node/64096
**Category:** General
**Created:** [18 June 2022 06:52 UTC](https://discourse.nodered.org/t/node-red-contrib-mysql2-node/64096 "2022-06-18T06:52:40Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)
#### Post date: [18 June 2022 14:04 UTC](https://discourse.nodered.org/t/node-red-contrib-mysql2-node/64096/4 "2022-06-18T14:04:10Z")

</div>

i havent used the node but from the example  
the database property should be `db` and not `database`  
also you have used msg.Server with capital S. i believe it should be lowercase

```auto
var newmsg={};

newmsg.server={
"host":"11.1.1.228",
"port":"3306", 
"username": "user", 
"password": "@L8S", 
"db": "test"
}

//newmsg.Password=mariadb_Password;
newmsg.topic="select id,profileName from ProfileEntity;";
//node.log("------ GET ProfileEntity mysql(req)="+newmsg.topic);
node.warn(newmsg)
return newmsg;

```

---

_[View the full topic](https://discourse.nodered.org/t/node-red-contrib-mysql2-node/64096)._