LinuxQuestions.org - [SOLVED] phpmyadmin

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - phpmyadmin (https://www.linuxquestions.org/questions/linux-server-73/phpmyadmin-870849/)

Hello Linux Guru's

I am really confused on phpmyadmin configurations, I downloaded phpmyadmin 3.3.10 (tar.gz format)untarred it and moved to /var/www/html directory as phpmyadmin folder.

1st I tested it on other machine then it worked then I saw an error below:
The configuration file now needs a secret passphrase (blowfish_secret).

I've read some advices on google to copy config.sample.inc.php to config.inc.php to the same location then after this I should place a password in the blowfish line from the config.inc.php.

After I finished it and test it again and logged in phpmyadmin screen the result is this:

Welcome to phpMyAdmin

Error
MySQL said:

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

what would be missing? any suggestions I'll be gratefull to your answers

Hi,

Probably, you are having an auth problem. Take a look at this link http://www.phpmyadmin.net/documentation/#quick_install

You must set properly the connection auth params, check if that is right.

Afterwards, if the problem persists, post here the config.php file.

[]'s

Rafa
Linux, Linux and Linux! Suporte Linux

Hi,

Follow the below steps to configure phpMyadmin.
I hope you have configured MySQL, if not use this link.

Download phpMyAdmin-2.11.11-english.tar.bz2 from here.

Code:

    # cp phpMyAdmin-2.11.11-english.tar.bz2 /var/www/html

    # cd /var/www/html

    # tar -xjvf phpMyAdmin-2.11.11-english.tar.bz2

    # mv /var/www/html/phpMyAdmin-2.11.11-english    /var/www/html/phpmyadmin

    # cp /var/www/html/phpmyadmin/config.sample.inc.php  /var/www/html/phpmyadmin/config.inc.php 

    # vim +17 /var/www/html/phpmyadmin/config.inc.php

      {

      ...

      ...

      Change Line 17 from

      $cfg['blowfish_secret'] = '';

      to

      $cfg['blowfish_secret'] = 'TypeSomeRandomStuffHere';

      ...

      ...

      }

    # service httpd restart

Then, open your http://yourIP/phymyadmin
and login using your MySQL credentials.

Hope this helps.

if everything working perfectly, i strongly suggest you to change the folder
http://yourIP/phymyadmin to be http://yourIP/somnething_else

so only you know the folder name, because phpmyadmin, phpadmin, admin, all these targetted
by security scanner

just one cent from me :)

Quote:

Originally Posted by vikas027 (Post 4303894)

Hi,

Follow the below steps to configure phpMyadmin.
I hope you have configured MySQL, if not use this link.

Download phpMyAdmin-2.11.11-english.tar.bz2 from here.

Code:

    # cp phpMyAdmin-2.11.11-english.tar.bz2 /var/www/html

    # cd /var/www/html

    # tar -xjvf phpMyAdmin-2.11.11-english.tar.bz2

    # mv /var/www/html/phpMyAdmin-2.11.11-english    /var/www/html/phpmyadmin

    # cp /var/www/html/phpmyadmin/config.sample.inc.php  /var/www/html/phpmyadmin/config.inc.php 

    # vim +17 /var/www/html/phpmyadmin/config.inc.php

      {

      ...

      ...

      Change Line 17 from

      $cfg['blowfish_secret'] = '';

      to

      $cfg['blowfish_secret'] = 'TypeSomeRandomStuffHere';

      ...

      ...

      }

    # service httpd restart

Then, open your http://yourIP/phymyadmin
and login using your MySQL credentials.

Hope this helps.

Thanks