FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Redhat > Fedora User

 
 
LinkBack Thread Tools
 
Old 12-21-2007, 02:17 PM
 
Default mysql issue on Fedora 7

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!

jack

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 12-21-2007, 03:33 PM
Craig White
 
Default mysql issue on Fedora 7

On Fri, 2007-12-21 at 10:17 -0500, jlwallen@monkeypantz.net 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

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 12-24-2007, 10:25 AM
Simon Andrews
 
Default mysql issue on Fedora 7

jlwallen@monkeypantz.net 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.


This isn't by any chance a system you've updated to F7 from something
earlier? You can get strange permission errors the first time you try
to change the grant tables after a version update.


To see if this is the problem try running the:

mysql_fix_priviledge_tables

program (probably as mysql_fix_priviledge_tables --user=root
--password=[your password here])


If that helps then you should probably run the full:

mysql_upgrade

command to sort out any other problems in the install.

Hope this helps

Simon.

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 12-25-2007, 02:50 PM
jack wallen
 
Default mysql issue on Fedora 7

Simon Andrews wrote:


This isn't by any chance a system you've updated to F7 from something
earlier? You can get strange permission errors the first time you try
to change the grant tables after a version update.


To see if this is the problem try running the:

mysql_fix_priviledge_tables

program (probably as mysql_fix_priviledge_tables --user=root
--password=[your password here])


If that helps then you should probably run the full:

mysql_upgrade

command to sort out any other problems in the install.

Hope this helps

Simon.



thank you simon. fortunately i wound up getting it up and running with
the help of phpmyadmin. i started the db server with the:


mysqld_safe --skip-grant-tables --user=root &

and then went into the mysql database and changed the permissions within
some of the tables to get the root user privileges again. just took me a
long time to find the right the tables.



--
jack wallen, jr. www.monkeypantz.net
"To know recursion, you must first know recursion"

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 

Thread Tools




All times are GMT. The time now is 09:30 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org