Re: FC3, MySQL and PHP [SOLVED]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Arthur Pemberton wrote:

Trevor "TeC" Christian wrote:

Arthur Pemberton wrote:

Ankush Grover wrote:

The issue appears to have been between PHP and mysql - re
authentication. The PHP client does not yet use the new password format
coming with mysql-4.x servers. I guess there's something to be said for
walking away when frustrated.


SELinux was never fully identified as the "source" of the problems -
especially as i wasn't getting any messages all while i was trying that.


Thanx guys.






Hey ,

To make php work with mysql 4 or 5 do this.

at the command prompt mysql> means when ur at mysql command prompt.

set password for user@somedomain =OLD_PASSWORD('newpasswd).

For ex

set password for root@localhost=OLD_PASSWORD('ankush');

now mysql root has the password ankush

Set the password as per ur requirements and also the user.

Regards

Ankush



What is the purpose of doing all this?

The mysql 4 server has a new password hashing algorithm or something...

All mysql 4.x clients have upgraded to that password form. However, it seems the php 4 doesn't not have the updated mysql client and it is hoped /expected to be present in php 5.

As such the, for the php client to connect to the mysql db, the user accounts require a password in the old format.

This wasn't obvious to me, because all the tools i used to "check if the server was running" were compatible with the appropriate password scheme.

Did you do : # mysql_fix_privilege_tables ?

yes...hence

--
*Trevor "TeC" Christian*
Cell #: (767) 225 4472
IM
  MSN: trevorc98@xxxxxxxxxxx / trevor@xxxxxxxxxxxxxxxxx
  YM : trevorc01
  AIM: DoubleOTeC
------------------------------------------------------------------------
Curriculum Vitae (PDF) <http://bouyon.dalive.com/cv/curriculum_vitae.pdf>
Curriculum Vitae (HTML) <http://bouyon.dalive.com/cv/curriculum_vitae.html>


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux