MySQL |

How to Configure MySQL Master-Master Replication

Step 1: Install MySQL Server Install MySQL Server on both machines. # apt-get update # apt-get install mysql-server mysql-client Step[…]

Step 1: Login MySQL Server Use the mysql credentials to login in mysql server: # mysql -u root -p Step[…]

There are 2 methods in order to delete the database in mysql through Linux Shell. Method 1: Delete through mysqladmin[…]

Step 1: Prerequisites Install Web Server PHP MySQL Server Step 2: Create WordPress Database # mysql -u root -p Enter[…]

Step 1: Modify /etc/mysql/my.cnf File To enable mysql slow query logs add the lines in my.cnf file. #vi /etc/mysql/my.cnf log_slow_queries[…]

Step 1: Login MySQL Database Login to MySQL database using following command: # mysql -u root -p Enter password: Server[…]

Step 1: Remove mysql Server We can use apt-get command in order to remove both MySQL server and client in[…]

Step 1: Prerequisites Install Web Server PHP MySQL Server Step 2: Download Package Download rpm package for CentOS / RedHat[…]

Export MySQL database To export mysql database, use the mysqldump command. # mysqldump -u root -p database-name > backup.sql e.g[…]

Introduction MySQL Community Edition is a freely downloadable version of the world’s most popular open source database that is supported[…]