Hack The Sec-Leading Resource Of Linux Tutorial: Mysql

How to Install MySQL 5.7 or 5.6 or 5.5 on Ubuntu, Debian & LinuxMint

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: red;">How to Install MySQL 5.7 or 5.6 or 5.5 on Ubuntu, Debian & LinuxMint</span></h2>
<div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">This article will help you for installing MySQL 5.7 or 5.6 or 5.6 on Ubuntu, Debian and LinuxMint systems.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s1600/mysq-linux-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s1600/mysq-linux-www.hackthesec.co.in.jpg" /></a></div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Use one of following installation steps as per your requirement of MySQL version. Install process will prompt you for inpur password twice. This will be root account password for your MySQL install.</span></div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-mysql-5615-on-centos-6.html" target="_blank"><span style="color: red; font-size: large;">How to Install MySQL 5.6.15 on CentOS 6 and RHEL 6</span></a></span></li>
</ul>
<br />
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install MySQL 5.7</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Use the following commands to install or upgrade MySQL 5.7 on your Ubuntu, Debian or LinuxMint systems. At the last update of this tutorial MySQL 5.7.9 is latest available MySQL release.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo apt-get <orange style="color: orange;">install</orange> software-properties-common
$ sudo <orange style="color: orange;">add-apt-repository</orange> -y ppa:ondrej/mysql-5.7
$ sudo apt-get <orange style="color: orange;">update</orange>
$ sudo apt-get <orange style="color: orange;">install</orange> mysql-server<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install MySQL 5.6</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Use the following commands to install or upgrade MySQL 5.6 on your Ubuntu or LinuxMint systems. Currently this is the most popular version used.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo apt-get <orange style="color: orange;">install</orange> software-properties-common
$ sudo <orange style="color: orange;">add-apt-repository</orange> -y ppa:ondrej/mysql-5.6
$ sudo apt-get <orange style="color: orange;">update</orange>
$ sudo apt-get <orange style="color: orange;">install</orange> mysql-server<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Verify installed version</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">rahul@hackthesec:~$ <orange style="color: orange;">mysql --version </orange>

mysql  Ver 14.14 Distrib 5.6.19, for debian-linux-gnu (x86_64) using  EditLine wrapper<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install MySQL 5.5</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Use the following commands to install MySQL 5.5 on your Ubuntu or LinuxMint systems. If not specifically required, we recommend to use higher version of MySQL than 5.5.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo apt-get <orange style="color: orange;">install</orange> software-properties-common
$ sudo <orange style="color: orange;">add-apt-repository</orange> -y ppa:ondrej/mysql-5.5
$ sudo apt-get <orange style="color: orange;">update</orange>
$ sudo apt-get <orange style="color: orange;">install</orange> mysql-server</pre>
</div>
</div>

How to Install MySQL 5.7 or 5.6 or 5.5 on Ubuntu, Debian & LinuxMint

How to Install MySQL 5.7 or 5.6 or 5.5 on Ubuntu, Debian & LinuxMint This article will help you for installing MySQL 5.7 or 5.6 or ...

How to Connect Node.js with MySQL

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
How to Connect Node.js with MySQL</h2>
<div>
<span style="font-family: "georgia" , "times new roman" , serif;"><span style="background-color: white; color: #555555; font-size: 16px; line-height: 28px;">Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is most popular database used for storing values. MySQL database driver for Node.js is available under </span><a href="https://www.npmjs.com/" style="background-color: white; color: #ff8800; font-size: 16px; line-height: 28px; outline: none; text-decoration: none;" target="_blank">NPM</a><span style="background-color: white; color: #555555; font-size: 16px; line-height: 28px;"> repository. In this tutorial we are assuming that you already have Node.js, NPM and MySQL installed on your system. We will help you to install Node.js MySQL driver module on your system and a sample program to connect to MySQL using node.js.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguMhM-YuBhRPY6Lyh6UPysHQgMYyW1CzPhLSjmUt_TNsCksPQWfJZm7JloGx5tG5-IepRC2L-7gPfIuAPXu9bTRVonP9frtTur1hY26OVKDBbc9ombDL6oXaFSQPBC-mvCEUMtwrL8PCYu/s1600/node-with-mysql_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguMhM-YuBhRPY6Lyh6UPysHQgMYyW1CzPhLSjmUt_TNsCksPQWfJZm7JloGx5tG5-IepRC2L-7gPfIuAPXu9bTRVonP9frtTur1hY26OVKDBbc9ombDL6oXaFSQPBC-mvCEUMtwrL8PCYu/s1600/node-with-mysql_www.hackthesec.co.in.png" /></a></div>
<span style="background-color: white; color: #555555; font-family: "roboto slab"; font-size: 16px; line-height: 28px;"><br /></span></div>
<div>
<h2 class="heading1" style="background-color: white; border: 0px; color: #ff3a00; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
Step 1 – Install Node.js MySQL Module</h2>
<div style="background-color: white; border: 0px; color: #555555; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">MySQL driver for node.js is available under node package manager (NPM). Use the following command to install node.js MySQL driver on your system.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo npm install mysql
</pre>
<h2 class="heading1" style="background-color: white; border: 0px; color: #ff3a00; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
Step 2 – Sample Node.js Program</h2>
<div style="background-color: white; border: 0px; color: #555555; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">Below is sample node.js program which will connection node.js application with MySQL server. It will show success and error messages according to connections results and close the connection at the end of program. Create a JavaScript file <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">app.js</span>.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ cd myApp
$ vim app.js
</pre>
<div style="background-color: white; border: 0px; color: #555555; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">and add the following content to above file.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; font-size: 0.9em; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">var mysql  = require('mysql');
var dbconn = mysql.createConnection({
  host     : 'localhost',
  user     : '<DB_USER>',
  password : '<DB_PASSWORD',
  database : '<DB_NAME>'
});

dbconn.connect(function(err){
  if(err){
    console.log('Database connection error');
  }else{
    console.log('Database connection successful');
  }
});

dbconn.end(function(err) {
  // Function to close database connection
});

</pre>
<h2 class="heading1" style="background-color: white; border: 0px; color: #ff3a00; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
Step 3 – Verify Connection</h2>
<div style="background-color: white; border: 0px; color: #555555; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">Now execute node.js script using command line and make sure Node.js is properly connecting with MySQL.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ node app.js

Database connection successful</pre>
</div>
<div>
<span style="background-color: white; color: #555555; font-family: "roboto slab"; font-size: 16px; line-height: 28px;"><br /></span></div>
</div>

How to Connect Node.js with MySQL

How to Connect Node.js with MySQL Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is mos...