Hướng dẫn bảo mật MongoDB Server

If MongoDB is your document store of choice, then this article should help you configure everything securely and properly for a production-ready environment. The MongoDB Installation Tutorial covers how to install MongoDB on a droplet. As always, please read the official documentation on Security and Authentication. Steps There are two differently recommended paths that are […]

Hướng dẫn cơ bản về MySQL

MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL How to Install MySQL on Ubuntu and CentOS If you don’t have MySQL installed on your droplet, you can quickly […]

Hướng dẫn tạo user mới và Grant Permissions in MySQL

What the Red Means The lines that the user needs to enter or customize will be in red in this tutorial! The rest should mostly be copy-and-pastable. About MySQL MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific […]

Hướng dẫn Import ,Export Databases và Reset a Root Password của MySQL

Export To Export a database, open up terminal, making sure that you are not logged into MySQL and type, mysqldump -u [username] -p [database name] > [database name].sql The database that you selected in the command will now be exported to your droplet. Import To import a database, first create a new blank database in […]

Hướng dẫn cài đặt Linux, nginx, MySQL, PHP (LEMP) stack trên CentOS 6

LEMP stack is a group of open source software to get web servers up and running. The acronym stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. Since the server is already running CentOS, the linux part is taken care of. Here is how to install the rest. Step One—Install the Required Repositories We […]

How To Install a Fresh Percona Server or Replace MySQL

Percona Server has a number of benefits over a basic MySQL installation: XtraDB: One of the key benefits of switching to Percona Server is XtraDB, a backwards compatible fork of the InnoDB engine with great improvements in performance and efficiency, allowing you to get better query throughput from your current hardware. As it is built […]