New Installation cannot view users table

[Evan Panagiotopoulos]

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
>