Mysql Server Question

Tim Frost timfrost at xtra.co.nz
Sun Nov 20 23:13:10 UTC 2005


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
> 





More information about the ubuntu-users mailing list