Phpmyadmin install on linux instance step by step

For installing phpmyadmin on linux server than follow below steps, you definitely will get install.
1. Follow below command to navigate to document root.
cd /var/www/html

2. follow this command: wget http://www.sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.4.1/phpMyAdmin-3.4.1-all-        languages.tar.bz2
3.  Unzip by typing: tar -jxf phpMyAdmin-3.4.1-all-languages.tar.bz2 -C /var/www/html
4.  rename the directory:mv phpMyAdmin-3.4.1-all-languages phpmyadmin
5.  Make a config directory in the phpmyadmin directory : cd /var/www/html/phpmyadmin and than mkdir config and than make copy by cp /var/www/html/phpmyadmin/config.sample.inc.php /var/www/html/phpmyadmin/config/config.inc.php.

6.  Open config.inc.php in VIM text editor by typing: sudo vim /var/www/html/phpmyadmin/config/config.inc.php

7.  Find the line that reads “$cfg[‘blowfish_secret’] = ”;” and change it so it reads:
$cfg[‘blowfish_secret’] = ‘type your secrete code';
secrete code has 60 character limit.
8.  Find the line that reads “$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;” if you have not set the password for root than set true for this option.
9.  Hit “Esc” to get out of insert mode in your text editor. Then type:
:wq
Type it just like that, including the semicolon, to save and exit the file.
10.  Go to http://your_public_DNS/phpmyadmin/ and enter you mysql admin username and password. You should have recorded these in your notes when setting up the database above in step 7 of the previous section(not this one).

If you getting the error like permission denied than you need to following step

1) open mysql propmt by typing mysql. or giving sudo su root you can use for giving root user to permission.
2) Or follow $ mysql -uroot -p
3)mysql> select host, user from user;
+——————–+———+
| host | user |
+——————–+———+
| 127.0.0.1 | root |
| localhost | |
| localhost | foobar |
| localhost | root |
+——————–+———+
4)mysql> grant select on yourDatabase.* to yourUser@’urMachine.domain.com’ identified by ‘urPassword';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)

5)mysql> select host, user from user;
+———————–+———+
| host | user |
+———————–+———+
| 127.0.0.1 | root |
| localhost | |
| localhost | redmine |
| localhost | root |
| urMachine.rovisys.com | urUser |
+———————–+———+

6) Now type http://yourdomain/phpmyadmin you can definitely open phpmyadmin.

6 thoughts on “Phpmyadmin install on linux instance step by step

  1. Pingback: luottoa
  2. We’re a group of volunteers and opening a new scheme in our community.
    Your site provided us with valuable information to work on. You have done a formidable
    job and our whole community will be thankful to you.

Leave a Reply

Your email address will not be published. Required fields are marked *