Have you forgotten MariaDB root password? You don’t know how to recover it. Not to worry, this tutorial will help you to reset MariaDB root password on Linux system. Let’s follow this step by step tutorial to reset MariaDB root password on your Linux systems. Step 1 – Start MariaDB in Safe Mode First...
MariaDB An enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and MySQL Features of MariaDB vs MySQL Compatibility between...
Many times we faced below issue when try to connect a remote MySQL server from client system and remote client is not allowed to access this MySQL server we faced issue like below. # mysql -h 192.168.1.10 -u root -p Enter password: [Output] ERROR 1130 (HY000): Host '192.168.1.12' is not allowed to connect to...
MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server. But it will not update Master if there are any changes done on slave server. Read this article to setup Master-Slave replication. This article will help you to set up Master-Master replication between MySQL...
This article will help you to setup master-slave replication between MySQL servers. We are using MySQL 5.5 on CentOS 6.3. I hope it will help you to setup replication. Setup Details: Master Server: 192.168.1.10 Slave Server: 192.168.1.20 Database: mydb If you are using different – different versions of MySQL on Master and Slave use...
How to Create MySQL User and Grant Permission. For the good security implementation, make sure to create separate user account rather than root to access database for each application. This will ensure that application can’t access other application’s database. You need MySQL administrator (root) privileges To create user accounts and assign privileges to the...
As a system administrator, you need to take backup on daily basis. Backups are very useful to recover data from any crashes or corruption. I have written a simple script to take database backup from MySQL server and upload to FTP server. Being a system administrator, I recommend keeping a remote copy of your...
Q. How to reset MySQL root password in Linux? How do I recover MySQL root password? I forgot MySQL root password, steps to change MySQL root password? How to reset MySQL root password using the command line. How to reset forgotten MySQL root password on Linux? How to reset MySQL 5.7 root password? MySQL...
MySQL is a database server for storing data permanently. If you are using MySQL server for an production use, then its necessary to create dataase backup for recovering from any crash. MySQL provides an utility mysqldump for taking backups. In this article you will learn, to taken databases backup in .sql format for archive...