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 > -- fedora-list mailing list fedora-list@xxxxxxxxxx To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
