Mysql Server Question

[Wade Smart]

11202005 1725 GMT-5

Tim - a question. Im still really new to linux so bear with me. My book 
on mysql says -> mysql will be installed as root but for security 
reasons dont run it as such. Its best to change the owner and group to 
something like mysqladm and mysqlgrp.

If that is the case, if I change one mysql file I'll have to change 
everything otherwise they wont be able to access each other - right?

Wade


Tim Frost wrote:

>On Sun, 2005-11-20 at 12:28 -0500, 'Forum Post wrote:
>
>  
>
>>I read in the installation doc's about using the mysql_install_db to
>>create the tables. I received errors: 
>>    
>>
>
>  
>
>>wadesmart at wadesmart:~$ mysql_install_db
>>
>>Installing all prepared tables
>>
>>051120 11:27:15 Warning: Can't create test file
>>/var/lib/mysql/wadesmart.lower-test
>>
>>Warning: One can only use the --user switch if running as root
>>
>>051120 11:27:15 /usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.009'
>>not found (Errcode: 13)
>>
>>051120 11:27:15 Could not use /var/log/mysql/mysql-bin for logging
>>(error 13). Turning logging off for the whole duration of the MySQL
>>server process. To turn it on again: fix the cause, shutdown the MySQL
>>server and restart it.
>>
>>051120 11:27:15 /usr/sbin/mysqld: Shutdown Complete
>>    
>>
>
>The errors are because you (user wadesmart) don't have permission to
>write to the system directories /var/lib/mysql and /var/log/mysql.
>
>What happens if you run the install via sudo:
>   sudo mysql_install_db
>
>  
>
>>Wade
>>
>>
>>-- 
>>wadesmart
>>
>>    
>>
>
>
>  
>