Databases

How To Set Up MySQL Master Slave Replication

May 29, 2019

In cloud computing, master-slave data replication refers to storing the same information on multiple servers. One server controls the group, and the other devices handle the work within the same node. This guide will walk you through how to set up master-slave replication in MySQL

Read more

How to Rename a MySQL Database

May 6, 2019

As an administrator, you may need to rename a database. However, for security, the command to rename a database directly was removed in MySQL 5.1.23. This guide will give three alternate methods to rename a database.

Read more

How to Connect to MySQL Using PHP


To access and add content to a MySQL database, you must first establish a connection between the database and a PHP script. In this guide learn how to use PHP to connect to MySQL.

Read more

How to Connect to MySQL from Windows Command Line

May 3, 2019

MySQL is a popular and open-source relational database application. Many servers make use of MySQL, to connect and use databases. This guide will walk you through using the Windows Command prompt to connect to a MySQL database.

Read more

How to Import and Export MySQL Databases in Linux

April 25, 2019

MySQL is a versatile application. It can be used for something as simple as a product database, or as complex as a Wordpress website. Exporting a database puts them in a dump file that can be transferred to another system. Importing brings an existing dump file into an empty installation of MySQL. This guide will walk you through how to export the database and import it from a dump file in MySQL.

Read more

How To Install MySQL on CentOS 7

February 6, 2019

MySQL is a popular free and open source database management application. It forms part of the LAMP stack (Linux, Apache, MySQL, PHP), a software collection used for servers. This guide will walk you through installing MySQL on CentOS 7 from third-party software repositories.

Read more

How to Install MySQL 8.0 in Ubuntu 18.04

December 12, 2018

MySQL is an open-source relational database server tool for Linux operating systems. It is widely used in modern web-based technology, and it forms part of the popular “LAMP” stack of software.  The LAMP stack includes the Linux operating system, Apache web services, MySQL database (or sometimes MariaDB), and the PHP programming language.

Read more

How to Back Up & Restore a MySQL Database

October 22, 2018

A MySQL database has been lost, and you’re scrambling to restore a copy from your last backup. This guide will help you become the hero your database needs. You’ll learn about the mysqldump command for creating and restoring backups.

Read more

How to Reset or Change MySQL Root Password on Linux or Windows

October 21, 2018

MySQL is a database management system. It’s operated under the Open Source software model and has become a very popular software package for web application software. Like many web services, MySQL has an administrator-level or root password. The root password allows a user to perform all top-level functions in the database.

Read more
1 12 13 14
© 2022 Copyright phoenixNAP | Global IT Services. All Rights Reserved.