On Fri, 2007-12-21 at 10:17 -0500, jlwallen@xxxxxxxxxxxxxxx wrote:
> I know there is probably a better place to post this but I am at my wits end.
>
> I am running F7 with a website running Drupal and eGroupware. Both of
> these rely on MySQL 5.0.45-1.fc7 (obviously). I set up the databases on
> phpmyadmin.
>
> yesterday i was attempting to install a booking software and had to run a
> Bundle update on CPAN. after I ran that here's what is now happening.
>
> *the only way Drupal and eGroupware can connect to the database is if i
> start the database with the "mysqld_safe --skip-grant-tables --user=root
> &" command.
> *when i log into phpmyadmin as the root user i am getting the "No
> privileges" error.
>
> now i can run everything by starting the mysqld in the way described above
> but: A) it's not secure and B) i still can't use phpmyadmin to work on or
> add databases.
>
> i have tried the following:
>
> shell> mysql -u root
> mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
> -> WHERE User='root';
> mysql> FLUSH PRIVILEGES;
>
> this does not help (like i thought it would).
>
> if anyone can offer up any guidance to this issue i would greatly
> appreciate it.
>
> thank you!
----
you may not be changing the right 'root' user...you might need to change
'root@localhost' user
Also, and perhaps most seriously, why would use use CPAN to update when
you have an rpm based system and most perl packages are already build as
rpm's? If you stay with perl rpms packaged for your system, you
(theoretically at least) don't have issues where the CPAN updates over
write existing perl modules installed via rpm. It's not recommended to
use CPAN because of that issue.
here is an example of a method to see if the perl module exists in rpm
packaging...
# yum search perl|grep -i MailTools
perl-MailTools.noarch : Various mail-related perl modules
Craig
