{"id":685,"date":"2018-08-17T12:05:45","date_gmt":"2018-08-17T12:05:45","guid":{"rendered":"https:\/\/visworlditsolution.wordpress.com\/?p=685"},"modified":"2018-08-17T12:05:45","modified_gmt":"2018-08-17T12:05:45","slug":"how-to-install-phpmyadmin-in-ubuntu-18-04-1-lts-server-using-source-code","status":"publish","type":"post","link":"https:\/\/linux.thingsomething.com\/index.php\/2018\/08\/17\/how-to-install-phpmyadmin-in-ubuntu-18-04-1-lts-server-using-source-code\/","title":{"rendered":"How to install phpmyadmin in Ubuntu 18.04.1 LTS Server using source code."},"content":{"rendered":"

Hello guys in this tutorial we are going to learn how to install phpmyadmin application using source code in ubuntu\u00a018.04.1 LTS\u00a0 Server. so without wasting time now we will start this tutorial step by step .
\n1 update our system package through below commands.<\/strong><\/span><\/p>\n

#sudo apt-get update\u00a0<\/strong><\/span><\/pre>\n
2 now\u00a0 we will install Apache server through below Commands.<\/strong><\/span><\/p>\n
#sudo apt-get install apache2 -y\u00a0<\/strong><\/span><\/pre>\n
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.<\/strong><\/span><\/p>\n
# apt install php7.2<\/strong><\/span><\/pre>\n
4 Then we will install mysql-server through below commands.<\/strong><\/span><\/p>\n
#sudo apt-get install mysql-server -y<\/strong><\/span><\/pre>\n
5 Then now we will going to \/var\/www\/html directory and put phpadmin source code using wgit Command.<\/strong><\/span><\/p>\n
\u00a0#wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.8.0\/phpMyAdmin-4.8.0-all-languages.zip<\/strong><\/span><\/pre>\n
6 if you get error :Unable to establish SSL connection then you need to put below Commands\u00a0 then continue stap 5 commands.<\/span><\/strong><\/p>\n
#openssl s_client -connect minecraft.net:443 -tls1<\/strong><\/span><\/pre>\n
7 extract Phpmyadmin source code and rename the folder using below commands.<\/span><\/strong><\/p>\n
 \nl# unzip phpMyAdmin-4.8.0-all-languages.zip<\/strong><\/span>\n#rm -rf\u00a0 phpMyAdmin-4.8.0-all-languages.zip<\/strong><\/span>\n#mv phpMyAdmin-4.8.0-all-languages\/ phpmyadmin<\/strong><\/span><\/pre>\n
8 now we want to setup specify user for phpmyadmin directory we can do through below commands.<\/strong><\/span><\/p>\n
# sudo adduser phpmyadmin<\/strong><\/span>\nAdding user `phpmyadmin' ...<\/span>\nAdding new group `phpmyadmin' (1001) ...<\/span>\nAdding new user `phpmyadmin' (1001) with group `phpmyadmin' ...<\/span>\nCreating home directory `\/home\/phpmyadmin' ...<\/span>\nCopying files from `\/etc\/skel' ...<\/span>\nEnter new UNIX password:<\/span>\nRetype new UNIX password:<\/span>\npasswd: password updated successfully<\/span>\nChanging the user information for phpmyadmin<\/span>\nEnter the new value, or press ENTER for the default<\/span>\nFull Name []: admin<\/span>\nRoom Number []:<\/span>\nWork Phone []:<\/span>\nHome Phone []:<\/span>\nOther []:<\/span>\nIs the information correct? [Y\/n<\/span>] y\nroot@vishnuhost:\/var\/www\/html#\u00a0<\/strong><\/pre>\n
9 After finish user creating work we need to setup\u00a0phpMyAdmin install wizard in phpmyadmin directory we can do this through below commands.<\/strong><\/span><\/p>\n
# cd phpmyadmin\/<\/strong><\/span>\n# sudo mkdir config<\/strong><\/span>\n# sudo chmod o+rw config<\/strong><\/span>\n# sudo cp config.sample.<\/strong><\/span>inc.php config\/config.inc.php<\/strong><\/span> \n# sudo chmod o+w config\/config.inc.php<\/strong><\/span><\/pre>\n
10 now we will go\u00a0 to our machine localhost or ip address in browser and type following commands.<\/strong><\/span><\/p>\n
#sudo apt-get install php7.2-mysqlnd<\/strong><\/span><\/pre>\n
 11 then we need to create mysql super admin user we can do it through below commands<\/strong><\/span><\/p>\n
# mysql -u root -p<\/strong><\/span>\nEnter password:<\/span>\nWelcome to the MySQL monitor. Commands end with ; or \\g.<\/span>\nYour MySQL connection id is 2<\/span>\nServer version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)<\/span>\nCopyright (c) 2000, 2018, Oracle and\/or its affiliates. All rights reserved.<\/span>\nOracle is a registered trademark of Oracle Corporation and\/or its<\/span>\naffiliates. Other names may be trademarks of their respective<\/span>\nowners.<\/span>\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement<\/span>.\nmysql> CREATE USER 'admin'@'%' IDENTIFIED BY 'admin';<\/strong><\/span>\nQuery OK, 0 rows affected (0.06 sec)\nmysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;<\/strong><\/span>\nQuery OK, 0 rows affected (0.00 sec)\nmysql>\\q\u00a0<\/strong><\/span><\/pre>\n
12. Then we need to restart mysql service through below commands.<\/strong><\/span><\/p>\n
# sudo \/etc\/init.d\/mysql restart\u00a0<\/strong><\/span><\/pre>\n
13 . Now we are going in browser and type our server machine ip and phpmyadmin setup path like below screen short.<\/strong><\/span><\/p>\n
 <\/p>\n
\"phpmyadmin<\/p>\n
14 then we will going to new server option and create new server we will put mysql-server user name ans password<\/strong><\/span>
\n\"\"<\/p>\n
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<\/span> <\/strong>.\"phpmyadminDon’t worry we can easily fix this error through below\u00a0 commands .<\/strong><\/span><\/p>\n
sudo apt-get install php-mysqlnd  <\/span><\/pre>\n
Then refresh the browser and look your phpmyadmin application login screen.<\/p>\n
\"how \"how<\/p>\n
if you have any problem in this process please comments here I will see your problem or error. If\u00a0 possible i will gave you solution otherwise like and follow my blog<\/p>\n
Thank you<\/p>\n
By- Vishnu Sharma<\/p>\n","protected":false},"excerpt":{"rendered":"
Hello guys in this tutorial we are going to learn how to install phpmyadmin application using source code in ubuntu\u00a018.04.1 LTS\u00a0 Server. so without wasting … Read More<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[14,18],"tags":[110,134,137,182],"class_list":["post-685","post","type-post","status-publish","format-standard","hentry","category-server-configuration","category-ubuntu","tag-how-to-create-mysql-user","tag-how-to-install-apache2-in-ubuntu","tag-how-to-install-phpmyadmin-in-ubuntu-18-4","tag-phpmyadmin"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/posts\/685"}],"collection":[{"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/comments?post=685"}],"version-history":[{"count":0,"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:attachment":[{"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linux.thingsomething.com\/index.php\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}