In this tutorial you will learn How To Install Apache MySQL PHP on CentOS 7 (LAMP) Stack step by step in 10 minutes. By default in CentOS 7 from repositories available PHP 5.4 version. I will show how to install… Continue Reading
MySQL Allow Remote Connections To allow remote connection from remote to MySQL database lets create new user “[email protected]” with password -PaSSworD from command prompt: mysql> CREATE USER ‘remote’@’10.110.2.25’ IDENTIFIED BY ‘PaSSworD’; Grant all privilegies to user [email protected] with password… Continue Reading
MySQL Connect Remote Database For remotely access to mysql database use command: mysql -u User -p -h RemoteMySQLdatabaseIP Were: User – remote MySQL server user, RemoteMySQLdatabaseIP – remote MySQL database IP example: # mysql -u User_Name -p -h 11.22.33.44 Enter password:… Continue Reading
1. Login to MySQL with root credentials $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 Server version: 5.5.49-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2016, Oracle… Continue Reading
Install Apache, MySQL, PHP (LAMP) stack On CentOS 6 LAMP is software bundle of web service solution stacks, named as an acronym of the names of its original four components: the Linux operating system, the Apache HTTP Server, the MySQL… Continue Reading
How to Setup PowerDNS PowerAdmin Web GUI In this article i will show how to install PowerDNS PowerAdmin Web GUI. First I will show how to install PowerDNS on CentOS. Our PowerDNS setup will use MySQL database in backend.… Continue Reading
Update MySQL 5.5 to 5.6 Ubuntu 12.04 using PPA To update MySQL server from 5.5 to 5.6 login into server: # apt-get -y remove mysql-server # apt-get -y autoremove # apt-get -y install software-properties-common # add-apt-repository -y ppa:ondrej/mysql-5.6 # apt-get… Continue Reading