Tag Archives: how to install apache2 in ubuntu

How to install phpmyadmin in Ubuntu 18.04.1 LTS Server using source code.

Hello guys in this tutorial we are going to learn how to install phpmyadmin application using source code in ubuntu 18.04.1 LTS  Server. so without wasting time now we will start this tutorial step by step .
1 update our system package through below commands.

#sudo apt-get update 

2 now  we will install Apache server through below Commands.

#sudo apt-get install apache2 -y 

3 Then we will install php which one we want here in my case i want 7.2 version so i will be install 7.2 php version through below commands.

# apt install php7.2

4 Then we will install mysql-server through below commands.

#sudo apt-get install mysql-server -y

5 Then now we will going to /var/www/html directory and put phpadmin source code using wgit Command.

 #wget https://files.phpmyadmin.net/phpMyAdmin/4.8.0/phpMyAdmin-4.8.0-all-languages.zip

6 if you get error :Unable to establish SSL connection then you need to put below Commands  then continue stap 5 commands.

#openssl s_client -connect minecraft.net:443 -tls1

7 extract Phpmyadmin source code and rename the folder using below commands.

 
l# unzip phpMyAdmin-4.8.0-all-languages.zip
#rm -rf  phpMyAdmin-4.8.0-all-languages.zip
#mv phpMyAdmin-4.8.0-all-languages/ phpmyadmin

8 now we want to setup specify user for phpmyadmin directory we can do through below commands.

# sudo adduser phpmyadmin
Adding user `phpmyadmin' ...
Adding new group `phpmyadmin' (1001) ...
Adding new user `phpmyadmin' (1001) with group `phpmyadmin' ...
Creating home directory `/home/phpmyadmin' ...
Copying files from `/etc/skel' ...
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
Changing the user information for phpmyadmin
Enter the new value, or press ENTER for the default
Full Name []: admin
Room Number []:
Work Phone []:
Home Phone []:
Other []:
Is the information correct? [Y/n] y
root@vishnuhost:/var/www/html# 

9 After finish user creating work we need to setup phpMyAdmin install wizard in phpmyadmin directory we can do this through below commands.

# cd phpmyadmin/
# sudo mkdir config
# sudo chmod o+rw config
# sudo cp config.sample.inc.php config/config.inc.php 
# sudo chmod o+w config/config.inc.php

10 now we will go  to our machine localhost or ip address in browser and type following commands.

#sudo apt-get install php7.2-mysqlnd

11 then we need to create mysql super admin user we can do it through below commands

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE USER 'admin'@'%' IDENTIFIED BY 'admin';
Query OK, 0 rows affected (0.06 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql>\q 

12. Then we need to restart mysql service through below commands.

# sudo /etc/init.d/mysql restart 

13 . Now we are going in browser and type our server machine ip and phpmyadmin setup path like below screen short.

 

phpmyadmin install in ubuntu

14 then we will going to new server option and create new server we will put mysql-server user name ans password

15. Then we will put in browser server IP Address and phpmyadmin path like this. for example my ip address is 192.168.2.253/phjpmyadmin . Then maybe it’s possible you get error like this screen short .phpmyadmin configuration with source code Don’t worry we can easily fix this error through below  commands .

sudo apt-get install php-mysqlnd  

Then refresh the browser and look your phpmyadmin application login screen.

how to install phpmyadmin in linux how to install phpmyadmin in ubuntu

if you have any problem in this process please comments here I will see your problem or error. If  possible i will gave you solution otherwise like and follow my blog

Thank you

By- Vishnu Sharma

Advertisements