How To Install Mysql, PHP Server on Ubuntu 14.043 min read
MySQL is a linux based open-source database management system. It’s a popular database management system on linux. It uses relational database management system and SQL (Structured Query Language). It can install easy process on ubuntu 14.04 or ubuntu 16.04.
Step #01: Now Change your machine hostname e.g mysql-server or another.
Open hosts file via vim editor
[email protected]:~# vim /etc/hosts
Press Esc type :wq then press enter.
Step #02: Configure static ip addres on your linux machine.
[email protected]:~# vim /etc/network/interface
auto lo iface lo inet loopback auto eth0 iface eth0 inet dhcp
auto lo iface lo inet loopback auto eth0 iface eth0 inet static address 126.96.36.199 netmask 255.255.0.0 gateway 188.8.131.52 dns-nameservers 184.108.40.206
Step #03: Ubuntu update & upgrade command.
[email protected]:~# apt-get update && apt-get upgrade
Step #04: Install mysql server via apt-get installer.
[email protected]:~# apt-get install mysql-server
Show popup message for configure mysql root password as like below:
Completed installation process about few minutes.
Step #05: Login mysql via root user.
[email protected]:~# mysql -u root -p
Then type your mysql password
Show as like below system for create database, delete database, create table, delete table, show database, show tables and more functionality.
Step #06: Create a new MySQL database.
mysql> create database testdb;
Step #07: Create a new MySQL user with password.
mysql> CREATE USER ‘newuser‘@’localhost’ IDENTIFIED BY ‘password‘;
Step #08: Using flush privileges for change update tables, database and user.
mysql> flush privileges;
Then exit command for leave mysql.
Step #09: Install php on ubuntu 14.04.
[email protected]:~# apt-get install php5 libapache2-mod-php5 php5-mcrypt php5-cli php5-xsl php5-intl libcurl3 php5-curl php5-gd mcrypt
Then goto /var/www/html/ create one php file for check php script run your server.
[email protected] :~# cd /var/www/html
Insert below text into index.php file.
<?php phpinfo () ; ?>
If face any problem then see my YouTube video and Subscribe my channel. Please subscribe my channel for more update.
- How To Install Apache Cloud Stack v4.15 On Centos 7 - January 21, 2021
- How To Install FreePBX 15 on CentOS 8 - January 20, 2021
- How To Install Jitsi Own Server For Video Conference On Ubuntu 20.04 - November 16, 2020
We really appreciate for your support for buying me a coffee.
It takes us a while to compose and upload new content, as they have to be checked to see if Properly works. We appreciate you if you help me for one cup of coffee to keep us awake and always deliver good quality content.
No contribution is small of an amount. We are grateful for any amount you support us with. Thank you!