New Installation cannot view users table
Craig White
craig at tobyhouse.com
Wed Dec 20 00:23:10 UTC 2006
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 at evanp ~]# mysql_install_db
> Installing all prepared tables
> Fill help tables
>
> then...
>
> [root at 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 at 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 at redhat.com
> > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
> >
>
>
--
Craig White <craig at tobyhouse.com>
More information about the fedora-list
mailing list