Tag: mysql w linux

mysql w linux

Create a MySQL Database and User through cPanel

  There are different ways to create a MySQL database and user. In one of our previous blog articles about MySQL database administration, we described how to create a new MySQL database and user through the command line which is pretty easy. If you have a …

XWiki Installation in Linux

XWiki Xwiki is an open-source enterprise-ready wiki written in Java, runs on a servlet container like Tomcat, Jboss etc. which uses the relational database to store the information. In this article we will know about how to install Xwiki in Linux using .war file usable for …

Install and using netstat in Linux

How to install netstat netstat is a useful tool for checking your network configuration and activity. It is in fact a collection of several tools lumped together. Install “net-tools” package using yum $ sudo yum install net-tools Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile …

How to Setup MySQL Master-Master Replication

How to Setup MySQL Master-Master Replication This article consolidates information from several sources into the format I use to setup MySQL Master/Master Replication. The beauty of Linux and open source is that there are many different ways to do this. Please take a look at my …

How to Show All Users in MySQL

This is a common question most beginner MySQL users ask. We notice it all over the internet and on our blog too. It’s frequently asked because there are other MySQL commands for displaying information about the database, for example: SHOW DATABASES will list out all the …

Complete MySQL Backup from Linux command line

Backups are an essential part of any online system, if you don’t have any backups then you will end losing all your information, which will make you lose time, money and even customers. Today I will show you how to backup your databases using MySQLDump utility …

Install MySQL on Linux

Most of the Linux distro comes with MySQL.  If you want use MySQL, my recommendation is that you download the latest version of MySQL and install it yourself. Later you can upgrade it to the latest version when it becomes available. In this article, I will …

How to enable MySQL Log Slow Queries on Linux

Sometimes MySQL is a resource hog, and most of the time, it’s not a server related problem. 90% of the MySQL performance issues are related to inneficient queries / bad SQL programming. When we face this scenario, a simple top -c commands can reveal the big …

We use cookies to give you the best online experience. By agreeing you accept the use of cookies in accordance with our privacy policy.