how to install phpMyAdmin via yum?

[asif2k]

I tried installing phpMyAdmin on my FC4 via yum, Failed! Please, can anyone tell me what is the correct command to install phpMyAdmin? I tried these commands.

 yum install phpMyAdmin

 yum install phpmyadmin

thanks in advance

[AndrewB]

I dont think phpmyadmin is in the yum sources list

here are a few steps

• 1. Download the latest version of phpMyAdmin from www.phpmyadmin.net
  2. unpack the package
  > tar -xzvf phpMyAdmin-2.7.0-pl1.tar.gz
  3. Move it to the appropriate place.
  > mv phpMyAdmin-2.7.0-pl1 /usr/share/
  4. Configure phpMyAdmin
  > cd /usr/share/phpMyAdmin-2.7.0-pl1
  > cp config.default.php config.inc.php
  > nano -w config.inc.php
  5. Locate each of the following lines and be sure each has the following settings.
  $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (con$
  $cfg['Servers'][$i]['user'] = 'root'; // MySQL? user
  $cfg['Servers'][$i]['password'] = ''; // MySQL? password (only nee$
  6. Save the file.
  7. Create the apache config file for phpmyadmin and restart apache.
  > echo "alias /webdb /usr/share/phpMyAdmin-2.7.0-pl1" > /etc/httpd/conf.d/phpMyAdmin.conf
  > service httpd restart
  8. now test it out. Be sure to set a root password

They are from here.

[asif2k]

Thank you!
I am not sure how to do step #7?
when I create that config file, where do I place it?

vim phpMyAdmin.conf

  echo "alias /webdb /usr/share/phpMyAdmin-2.7.0-pl1"
 /etc/httpd/conf.d/phpMyAdmin.conf

[ImNeat]

Looks like #7 is three separate lines of code
is that how you entered it?

[asif2k]

ok, the problem is solved. I had to mess with it a little bit.

thank you

[AndrewB]

Should it not be...
May the SOURCE be with you

Also could you explain how.
Just for continuety

[Tony B]

Hi I am getting the following error

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I think it is because I am not sure how to implement step 7, please can you help

Thanks

Tony

[tom-tjtech]

This is a MySQL error, run these at the terminal:

first check to see if MySQL is available (which I suppose it must be in your case) on the MysQL server,

[root@localhost]# mysqladmin ping -u root -p
Enter password: your-root-mysql-adminpasswd-here
mysqld is alive

if you do get error: 'Access denied for for user ...etc'
then you are not using the correct root (mysql-admin) password.
Try just enter without any password (default installation)

if you get error:'Check that mysqld is running...' start the service
[root]# service mysqld start
Starting MySQL [OK]

Assuming you can get in, then try to get into MySQL itself...
[root@localhost]# mysql -u root -p
Enter password: the-passwd-you-used-above
Welcome to the MySQL monitor...
(--etc--)
mysql>

At this point you have successfully logged into the mysql prompt,
anything you do here is restricted by your GRANT privilages,
try...

mysql>show databases;
|---------|
|Database|
|---------|
|mysql ---|
|test-----|
|---etc---|
|---------|

mysql>use mysql;
Databse changed
mysql>select * from mysql.user;

(this will show you a list of stored users in MySQL)

If all is well at the shell.