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>
