Install MySQL database server on Debian or Ubuntu
Article ID: 3156 Published: 23 Nov 2014 Updated: 15 Feb 2016 Authored by: Crazy Domains Support
This tutorial shows you how to install a MySQL database server on Debian/Ubuntu. You can install a MySQL database server on Debian/Ubuntu by doing the following:
| Step 1. | Open your VPS console from the Power Management control panel. |
| Step 2. | Log In to your VPS by entering your username and password. |
| Step 3. | Update the apt-get repository using the following command: # apt-get update && apt-get upgrade |
| Step 4. | Install the MySQL database server and client using the following command: # apt-get install mysql-server mysql-client Sample output: Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libxcb-render-util0-dev xulrunner-1.9.1 libxcb-render-util0 Use 'apt-get autoremove' to remove them. Selecting previously deselected package libnet-daemon-perl. (Reading database ... 159847 files and directories currently installed.) Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ... Selecting previously deselected package libplrpc-perl. Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ... Selecting previously deselected package libdbi-perl. Unpacking libdbi-perl (from .../libdbi-perl_1.612-1_amd64.deb) ... Selecting previously deselected package libdbd-mysql-perl. Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_amd64.deb) ... Selecting previously deselected package mysql-client-5.1. Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.49-3_amd64.deb) ... Selecting previously deselected package mysql-server-core-5.1. Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.49-3_amd64.deb) ... ... ,... |
| Step 5. | You will be prompted to enter and repeat a new MySQL root password during installation. |
|
|
|
| Step 6. | Confirm the new MySQL root password by repeating it. |
|
|
|
| If the installation was successful, the output will be as following: | |
|
|
|
| Step 7. | MySQL server service runs at port 3306 by default. You can check if port 3306 is open by using the following command:
# netstat -tulpn | grep :3306 |
Congratulations, you have installed MySQL database server on Debian/Ubuntu.