LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 03-24-2011, 08:59 PM   #1
struggled_newbie
Member
 
Registered: Sep 2009
Posts: 125

Rep: Reputation: 15
phpmyadmin


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
 
Old 03-25-2011, 09:40 AM   #2
rafatmb
LQ Newbie
 
Registered: Feb 2011
Posts: 27

Rep: Reputation: 3
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
 
Old 03-26-2011, 03:41 AM   #3
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Ubuntu, Debian, OS X
Posts: 1,305

Rep: Reputation: 107Reputation: 107
Question

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.
 
1 members found this post helpful.
Old 03-27-2011, 02:00 AM   #4
routers
Member
 
Registered: Aug 2005
Location: Malaysia - KULMY / CNXTH
Distribution: Slackware, Fedora, FreeBSD, Sun O/S 5.10, CentOS
Posts: 787
Blog Entries: 6

Rep: Reputation: 75
Just info

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
 
2 members found this post helpful.
Old 03-27-2011, 10:12 PM   #5
struggled_newbie
Member
 
Registered: Sep 2009
Posts: 125

Original Poster
Rep: Reputation: 15
Smile

Quote:
Originally Posted by vikas027 View Post
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
phpMyAdmin error: client denied by server configuration: /usr/share/phpMyAdmin Kropotkin Linux - Server 2 05-15-2010 12:55 PM
phpmyadmin shows blank page; no "phpmyadmin" database in mysql qajaq Linux - Software 2 12-20-2009 12:23 PM
phpMyAdmin Frank Soranno Debian 3 03-09-2007 02:41 PM
phpmyadmin how to use? anwar Linux - Software 1 03-09-2007 02:24 AM
Need Help with phpmyadmin! Frank Soranno Debian 0 03-07-2007 08:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 08:57 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration