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 >
