Re: New Installation cannot view users table

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

 



Now you listen to me Craig and listen to me good. YOU ARE THE BEST!!!!!

Apparently the /var/lib/mysql directory somehow was causing this problem.

THANKS!!!!!

Evan

On Tue, December 19, 2006 7:23 pm, Craig White wrote:
> I would gather that after doing the yum remove mysql-server, that you
> probably also need to nuke /var/lib/mysql directory too since simply
> removing the rpm packages isn't likely to do anything to the data.
>
> Craig
>
> On Tue, 2006-12-19 at 19:03 -0500, Evan Panagiotopoulos wrote:
>> Thanks,
>>
>> I followed the directions and...
>>
>> [root@evanp ~]# mysql_install_db
>> Installing all prepared tables
>> Fill help tables
>>
>> then...
>>
>> [root@evanp ~]# /usr/bin/mysqladmin -u root password 'new-password'
>> /usr/bin/mysqladmin: Can't turn off logging; error: 'Access denied; you
>> need the SUPER privilege for this operation'
>> [root@evanp ~]#
>>
>> By the way, this is a brand new install. I did not drop any tables.
>> Using
>> Add/Remove software I removed mysql and reinstalled it. Tried the
>> instructions and still does not work. Why wouldn't install the mysql
>> database?
>>
>> Any suggestions?
>>
>> On Tue, December 19, 2006 5:50 pm, Dmitriy Kropivnitskiy wrote:
>> > Evan Panagiotopoulos wrote:
>> >> I just installed Fedora Core 6 and even though I selected mysql to be
>> >> installed I cannot get it to run properly.
>> >>
>> >> The output of: <rpm -qa|fgrep mysql> is ...
>> >>
>> >> libdbi-dbd-mysql-0.8.1a-1.2.2
>> >> mysql-server-5.0.27-1.fc6
>> >> mysql-connector-odbc-3.51.12-2.2
>> >> mysql-5.0.27-1.fc6
>> >>
>> >> The output of </etc/rc.d/init.d/mysqld status> is...
>> >>
>> >> mysqld (pid 23491) is running...
>> >
>> > So mysql seems to be running.
>> >
>> >> I do enter with <mysql -u root>
>> >> mysql> show databases;
>> >> +--------------------+
>> >> | Database           |
>> >> +--------------------+
>> >> | information_schema |
>> >> | test               |
>> >> +--------------------+
>> >> 2 rows in set (0.00 sec)
>> >
>> > This is a bit weird. Seems like the mysql database is missing.
>> >
>> >> mysql> use user
>> >> ERROR 1044 (42000): Access denied for user ''@'localhost' to database
>> >> 'user'
>> >> mysql> use users
>> >> ERROR 1044 (42000): Access denied for user ''@'localhost' to database
>> >> 'users'
>> >
>> > Why would this work? There is no user or users database by default.
>> >
>> > I would suggest the following:
>> > 1. Stop mysql (service mysqld stop)
>> > 2. Reinitialize main databases (mysql_install_db)
>> > 3. Next time don't drop the mysql database, it is actually needed :)
>> >
>> > --
>> > fedora-list mailing list
>> > fedora-list@xxxxxxxxxx
>> > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>> >
>>
>>
> --
> Craig White <craig@xxxxxxxxxxxxx>
>
> --
> fedora-list mailing list
> fedora-list@xxxxxxxxxx
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>


-- 
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