Re: New Installation cannot view users table

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

 



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