How to install MySQL

Here is a step by step how to install MySQL and secure it for your unlimited bandwidth VPS. You will need to either be logged in as root or utilize SUDO.

CentOs installation:

sudo yum install mysql-server

 

Ubuntu or Debian installation:

apt-get install mysql-server mysql-client

 

Enable auto restart:

chkconfig --levels 235 mysqld on

 

Start up MySQL:

/etc/init.d/mysqld start

 

Now you need to secure your installation using this simple command:

mysql_secure_installation

You will be asked to set and change your root password to your MySQL installation. If you don't run this it will allow anyone to connect to your database without a password. You will also want to remove the test user that was created during the installation.

 

Now you can try logging in:

mysql -u root -p  

This will prompt you to enter the password.

  • 62 Users Found This Useful
Was this answer helpful?

Related Articles

How do I manage my VPS Server?

We provide you with a very simple interface for controlling your VPS hosting with unmetered...

How to Install Apache2 and PHP5 on Ubuntu

Installing Apache2 and PHP5 is super simple on Ubuntu: # apt-get install apache2# apt-get...

How to Install MySQL on Ubuntu

Learn how to install MySQL on your DDoS protected dedicated server or DDoS protected VPS if...

Installing Node.js on CentOs 5

Installing node.js on a cheap VPS with unlimited bandwidth is pretty simple. For more information...

Installing Apache, MySql 5.5 and PHP5.3 on CentOs 5

Learn how to install a LAMP environment on your server or a VPS with unlimited bandwidth from...