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.
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.
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 .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.
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
By- Vishnu Sharma