Home > Tag Archives: mysql

Tag Archives: mysql

How to install HTTP Apache, MySql, PHP, PhpMyAdmin from source-Part 2

apache

Install HTTP Apache from source 1. Download source mysql-5.6.24-linux-glibc2.5-x86_64.tar.gz from http://dev.mysql.com/downloads/mysql/ 2. Copy the downloaded file to folder where you want to install MySql, for my case I copied in /opt/soft-install/ directory 3. Extract the file at this location, command to extract cp -av mysql-5.6.24-linux-glibc2.5-x86_64.tar.gz /opt/soft-install/ tar -zxvf mysql-5.6.24-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.24-linux-glibc2.5-x86_64 mysql-5.6 4. Go to the bin directory of the ... Read More »

How to install HTTP Apache, MySql, PHP, PhpMyAdmin from source-Part 1

apache

How to install HTTP Apache, MySql, PHP, PhpMyAdmin from source Install HTTP Apache from source 1. Download source httpd-2.2.29.tar.gz from http://httpd.apache.org/download.cgi2. Copy the downloaded file to folder where you want to install apache http server3. Extract the file at this location, command to extract 4. Download apr-1.5.2.tar.gz and apr-util-1.5.4.tar.gz and extract the files at httpd-2.4.12/srclib/ director a). Download apr-1.5.2.tar.gz and ... Read More »

MySQL DB import/export through the command line

MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL. Moving MySQL database is a frequent necessity. Servers migration/ disk space runs out etc are the main reasons where we need to migrate mysql database. ... Read More »

Create a New User and Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. This tutorial will give a short overview of options to grant specific users nuanced permissions within the tables and databases. How to Create a New User in MySQL Let’s start by making a new user within the MySQL shell: CREATE USER 'newuser'@'localhost' IDENTIFIED ... Read More »