27
Sep
2020
Deepak
In this guide, we will explain how to login phpMyAdmin on DirectAdmin server using screenshots for better understanding. We will also be showing how to create a Database and a User. phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. You can perform frequently used […]
09
Apr
2020
Deepak
This guide will help you install Nginx, MySQL, PHP (LEMP) Stack on CentOS machine i.e. Server. LEMP is a software stack comprised of Nginx as Web Server and MySQL as Database server along with PHP as the dynamic content processor for websites. LEMP term is actually an acronym that represents the Linux, ENginx (replaces ‘A’ […]
04
Apr
2020
BaseZap
We will be demonstrating on how to use MySQL from terminal of MAC OS which has MAMP installed on it. Some common functionalities will include : Selecting a database and running related commands Importing database Exporting database First step would be to run MAMP and make sure MYSQL server is ON Open terminal and run […]
26
Jan
2020
zapbase
If you have root access to your server and wish to change/ reset password of a MySQL user, then you can do via following method via terminal access to the server : Login into the server via root users. Type mysql (press enter) to enter into myql command prompt Here we have got MariaDB, since […]
01
Sep
2018
Deepak
The operating system provides ways of limiting the amount of resource that can be used. Limits are set for each user but are applied separately to each process that is running for that user. Administering Unix servers can be a challenge, especially when the systems you manage are heavily used and performance problems reduce availability. Linux itself […]
23
Aug
2018
Deepak
Wondering if you can connect your website’s Database on your Local Computer? Yes, absolutely you can. There are a few programs you can use to connect remotely to your database. You can utilize HTML editors like Adobe Dreamweaver for a fee, or there are free Open Source programs you can use like MySQL Workbench or Heidi […]
08
Aug
2018
Deepak
Facing issues like the crashing of MySQL server and unable to restart due to connection timed out when restarting? This problem can occur when your website’s database is large and have high traffic. Due to this when you or WHM wants to restart the MySQL, it sticks there and throws the timeout error. Above stated problems […]
27
Jun
2018
Deepak
Fix mysqld process using the same InnoDB data or log files Problem Own a MySQL server and facing Database connection failures and crashes? The reason could be duplicate SQL queries and Processes running on your server. There is an easy fix for this problem. MySQL Logs throws an error as below InnoDB: Check that you do not already […]
25
May
2018
BaseZap
Remote MYSQL database not connecting from a cPanel based interface even after whitelisting your remote IP from “remote MYSQL” ? It must be due to faulty MYSQL CNF file (my.cnf). Here are the quick steps to fix this : Open my.cnf file in terminal using following command : sudo nano /etc/my.cnf Locate the bind address […]
14
May
2018
Deepak
What is LAMP? LAMP stands for a cluster of open source software used to run servers. It is an acronym for Linux, Apache, MySQL, and PHP. Since the server already runs CentOS, the Linux part is taken care of. Below are the steps of installation of the rest. Set UP You need to have […]
