MySQL Server Archives

April 16, 2019April 23, 2019

How To Install MySQL Server on Ubuntu 17.04

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is compatible with all major operating systems. MySQL can be used for a variety of applications, but is most commonly found on web servers.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation MySQL Server on a Ubuntu 17.04 Zesty Zapus server.

Install MySQL Server on Ubuntu 17.04 Zesty Zapus

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Installing MySQL.

Run the commands below to install MySQL:

apt-get install mysql-server mysql-client

Once complete, you can verify MySQL is installed by running the below command:

systemctl status mysql
systemctl start mysql
systemctl status mysql

After the installation of MySQL is complete, you may need to secure your new MySQL. By default, MySQL is not hardened. You can secure MySQL using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

To log into MySQL, use the following command (note that it’s the same command you would use to log into a MySQL database):

mysql -u root -p

One of the most important things when running MySQL on a production server is to get the most out of its performances. If you are a beginner and you do not know how to tune your MySQL server, you can start with a program called MySQLTuner. It will help you to analyze your server and to tune MySQL for better overall performances.

Congratulation’s! You have successfully installed MySQL. Thanks for using this tutorial for installing MySQL Server in Ubuntu 17.04 Zesty Zapus system. For additional help or useful information, we recommend you to check the official MySQL web site.

April 8, 2019April 24, 2019

How To Install MySQL Server on Ubuntu 16.04

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation MySQL server in Ubuntu 16.04 LTS (Xenial Xerus) server.

Install MySQL Server on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

apt-get update
apt-get upgrade

Step 2. Install MySQL server on Ubuntu 16.04 LTS (Xenial Xerus) server.

Installing MySQL is as simple as running just one command below, At the moment of writing this article it is version 5.7:

apt-get install mysql-server mysql-client

Once complete, you can verify MySQL is installed by running the below command:

systemctl status mysql
systemctl start mysql
systemctl status mysql

By default, MySQL is not hardened. You can secure MySQL using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

To log into MySQL, use the following command (note that it’s the same command you would use to log into a MySQL database):

mysql -u root -p

Congratulation’s! You have successfully installed MySQL. Thanks for using this tutorial for installing MySQL server in Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official MySQL web site.

June 25, 2018April 2, 2019

How To Reset Root Password on MySQL Server

By default, MySQL server will be installed with root account and password is blank. Have you ever forgotten the root password on one of your MySQL servers? If you have set the password for root and forget it, then you will need to reset the root password for MySQL. To reset your mysql password just follow these instructions and we assume that you already have a small amount of knowledge on MySQL.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The reset password MySQL is quite simple. I will show you through the step by step reset root password MySQL server.

Reset Root Password MySQL Server

Step 1. First thing to do is stop MySQL.

### CentOS 6 ###
service mysqld stop

### CentOS 7 ###
systemctl stop mysqld

Step 2. Next we need to start MySQL in safe mode with the –skip-grant-tables option so that it will not prompt for password.

 mysqld_safe --skip-grant-tables &

Step 3. Start the mysql client process using this command with root account and blank password.

 mysql -u root

Step 4. Change password for root account.

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where #User='root';
mysql> flush privileges;
mysql> quit

Step 5. Restart MySQL.

Once complete, you can restart MySQL is installed by running the below command:

### CentOS 6 ###
service mysqld restart

### CentOS 7 ###
systemctl restart mysqld

Congratulation’s! You have successfully reset password MySQL. Thanks for using this tutorial for reset root password MySQL on Linux system. For additional help or useful information, we recommend you to check the official MySQL web site

You Might Also Like: How To Backup and Restore MySQL Database Using Command Line

June 24, 2018April 2, 2019

How To Remove MySQL Server from CentOS

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The uninstall or removing is quite simple. I will show you through the step by step removing MySQL on CentOS server. May be it’s good idea to backup databases before doing this.

In this tutorial we will guide you how to completely remove of MySQL from your CentOS server.

Completely Removing MySQL Server in CentOS

Step 1: Check list the mysql rpm which is installed on server

#rpm -qa | grep mysql
or
#yum list installed | grep mysql

Step 2 : Removing all mysql-related packages (with “yum remove”)

 #yum remove mysql-client mysql-server mysql-common mysql-devel

Step 3: Delete the databases folder

#rm -rf /var/lib/mysql/
#rm -rf /etc/my.cnf

If you need to reinstall mysql database server, check out our tutorial, click here.

Congratulation’s! You have successfully removes MySQL. Thanks for using this tutorial for removing MySQL server on CentOS system. For additional help or useful information, we recommend you to check the official MySQL web site

You Might Also Like: How To Install MySQL Database Server on CentOS