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.
★ How To Install mysql Community on Windows 10
★ How To Setup Mysql Master Slave Replication on Ubuntu 14.04
Step #01: Now Change your machine hostname e.g mysql-server or another.
Open hosts file via vim editor
root@mysql:~# vim /etc/hosts
Press Esc type :wq then press enter.
Step #02: Configure static ip addres on your linux machine.
root@mysql:~# vim /etc/network/interface
Before:
auto lo iface lo inet loopback auto eth0 iface eth0 inet dhcp
After:
auto lo
iface lo inet loopback
auto eth0
iface eth0 inet static
address 20.11.10.10
netmask 255.255.0.0
gateway 20.11.1.1
dns-nameservers 20.11.10.1
Step #03: Ubuntu update & upgrade command.
root@mysql:~# apt-get update && apt-get upgrade
Step #04: Install mysql server via apt-get installer.
root@mysql:~# 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.
root@mysql:~# 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.
root@mysql:~# 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.
root@mysql :~# cd /var/www/html
vi index.php
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.
Thanks to all.
- How To Install Zabbix Server 6.4 On AlmaLinux 8 Server - August 9, 2024
- How To Clear RAM Memory Cache Buffer Linux Server - February 29, 2024
- How To Install Apache Cloud Stack Management Server 4.17 On Ubuntu 22.04 - February 1, 2024
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!
