MySQLd Password

[Nicholas Evans]

Alexander Dalloz wrote:

>Am So, den 01.02.2004 schrieb Nicholas Evans um 22:40:
>  
>
>>Hello 
>>   
>>    I installed a mySQLd from the Fedora disc last night, and got it 
>>running. I did the mysql_install_db to set up the user table and stuff, 
>>and when I went to set a password for it it says...
>>
>>mysqladmin: unable to change password; error: 'Table 'user' is read only'
>>
>>I've tried running it as owlmanatt (user account), root, and mysql, but 
>>it refuses to work. Could it be a chmod problem? I can't find where 
>>mySQL keeps it's database files, so I don't know where to go to fix it. 
>>I've been looking on google and trying to make it work since last night, 
>>but I can't get it.
>>
>>Any pointers would be much appreciated!
>>
>>(And yes, servers don't seem to like me today.)
>>
>>Thanks!
>>Nicholas Evans
>>    
>>
>
>It would have been enough to run /etc/init.d/mysqld start to run the
>initial process for creating the base mysql database. Now after manual
>run of mysql_install_db you have to run manually "chown -R mysql.mysql
>/var/lib/mysql".
>
>Alexander
>
>
>  
>
Hey

    That didn't work, but I know why now. I was talking with Clint over 
AIM, and he gave me a few pointers which lead me to chmod the files, 
then I had to reload the grant tables.

Thanks all, you were a big help!

Regards,
Nicholas