Re: Big problem with MYSQL

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

 



On 6/14/06, Karl Larsen <k5di@xxxxxxxxxx> wrote:
Arthur Pemberton wrote:
> On 6/14/06, Karl Larsen <k5di@xxxxxxxxxx> wrote:
>>     I'm using FC4 and I installed a full mysql and it just will not
>> work! And I have tried all that the ref manual offers and I think this
>> problem is just RPM problem. MYSQL works in all ways except this critial
>> step. It comes up when loading mysqld and it is fine until I want to
>> show a DB. Then it fails totally!
>>
>> Here is an example:
>>
>> mysql> GRANT ALL ON test TO PUBLIC;
>> ERROR 1044 (42000): Access denied for user ''@'localhost' to database
>> 'test'
>> mysql>
>>
>> This is a problem NOT in the referance manual and I have no idea how to
>> fix it. The dam problem is just a just a FC4 problem? I don't think so.
>> I understand SQL well but this just defies understanding.
>>
>> Karl Larsen.
>
> First step would
>
> 1) do the grant tables allow what you want to do? Easy solution would
> be to move them and start fresh
    I have no idea what your talking about. What is a grant table? I
tried the sql grant and it doesn't work as shown. I tried mysqladmin
with several control letters to no avail.
>
Yah, sorry about that, I used the wrong terminology.

Okay, I am shooting in the dark here as I have never really had this
problem, so the best I can suggest is a work around.

1) go to /var/lib
2) make a copy of /var/lib/mysql (for backup purpose - just incase)
3) go into /var/lib/mysql
4) and eithe rmove,rename or delete the /var/lib/mysql/mysql folder

That wil remove ALL permission information that mysql uses. So next
time the mysql daemon starts up , all that information will be back to
just the fresh passwordless stuff. From there you can put back in your
mysql user information.

Its a bit crude, but it's the best solution I can think of....your
data should be safe... But that's why I put in step 2, just in case.



--
To be updated...

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux