Thread: cannot create /usr/local/mysql/data/MachineName.err: Permission denied

i had installed binary while ago. time in march mysql stopped auto starting , when try manually start error message. seems permission problem , have been searching answer off , on months now. when trying start mysql error , .pid file never created.

code:

username@machinename:/usr/local/mysql/bin$ mysqld_safe --user=mysql & [2] 7674 aaron@aaron-inspiron-9300:/usr/local/mysql/bin$ 110605 18:32:21 mysqld_safe logging '/usr/local/mysql/data/machinename.err'. 110605 18:32:21 mysqld_safe starting mysqld daemon databases /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: 739: cannot create /usr/local/mysql/data/machinename.err: permission denied eval: 1: cannot create /usr/local/mysql/data/machinename.err: permission denied 110605 18:32:21 mysqld_safe mysqld pid file /usr/local/mysql/data/machinename.pid ended /usr/local/mysql/bin/mysqld_safe: 783: cannot create /usr/local/mysql/data/machinename.err: permission denied ^c [2]-  exit 2                  mysqld_safe --user=mysql

anyone have idea's?

what user owns /usr/local/mysql? user mysqld run as?

in standard configuration ubuntu's, server runs user:group "mysql:mysql" , user , group own entire /var/lib/mysql tree.

you're starting server user "aaron" appears.

why not run standard mysql available in ubuntu repositories , let handle you?

Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [ubuntu] cannot create /usr/local/mysql/data/MachineName.err: Permission denied

Ubuntu