chown - Default owner of var 16.04 - Ask Ubuntu
my problem short. have typed
chown -r root:root /var and mysql server stopped working :/ tried searching solution, nothing helped me.
i have problem permissions in phpmyadmin. errors can found here.
i know, have ruined whole structure of ownerhsip, if have list of default users , groups in var gratefull.
that command harmful. changed ownership of objects (file , directories) inside /var directory root user. not programs expect, including mysql
mysql wants files inside /var/lib/mysql directory owned user mysql.
so, should change ownership of directory (recursively) again using command
sudo chown -r mysql:mysql /var/lib/mysql except file /var/lib/mysql/debian-5.7.flag. 1 owned root. after executing above command, can again change ownership of file
sudo chown root:root /var/lib/mysql/debian-5.7.flag also mysql wants log directory owned mysql user. so, again change ownership of too
sudo chown -r mysql:mysql /var/log/mysql fortuantely, had phpmyadmin installed. can give files list owned mysql in /var/lib/phpmyadmin directory. here list. change ownership of of these using sudo chown mysql:mysql filename command.
/var/lib/mysql/phpmyadmin /var/lib/mysql/phpmyadmin/pma__table_uiprefs.ibd /var/lib/mysql/phpmyadmin/pma__bookmark.frm /var/lib/mysql/phpmyadmin/pma__pdf_pages.ibd /var/lib/mysql/phpmyadmin/pma__usergroups.ibd /var/lib/mysql/phpmyadmin/pma__savedsearches.ibd /var/lib/mysql/phpmyadmin/pma__designer_settings.ibd /var/lib/mysql/phpmyadmin/pma__relation.ibd /var/lib/mysql/phpmyadmin/pma__export_templates.ibd /var/lib/mysql/phpmyadmin/pma__favorite.frm /var/lib/mysql/phpmyadmin/pma__column_info.ibd /var/lib/mysql/phpmyadmin/pma__userconfig.ibd /var/lib/mysql/phpmyadmin/pma__users.frm /var/lib/mysql/phpmyadmin/pma__relation.frm /var/lib/mysql/phpmyadmin/pma__table_coords.frm /var/lib/mysql/phpmyadmin/pma__navigationhiding.frm /var/lib/mysql/phpmyadmin/pma__column_info.frm /var/lib/mysql/phpmyadmin/pma__history.frm /var/lib/mysql/phpmyadmin/pma__userconfig.frm /var/lib/mysql/phpmyadmin/pma__tracking.frm /var/lib/mysql/phpmyadmin/pma__export_templates.frm /var/lib/mysql/phpmyadmin/pma__users.ibd /var/lib/mysql/phpmyadmin/pma__table_coords.ibd /var/lib/mysql/phpmyadmin/pma__table_info.ibd /var/lib/mysql/phpmyadmin/pma__table_info.frm /var/lib/mysql/phpmyadmin/pma__savedsearches.frm /var/lib/mysql/phpmyadmin/pma__central_columns.frm /var/lib/mysql/phpmyadmin/pma__central_columns.ibd /var/lib/mysql/phpmyadmin/pma__history.ibd /var/lib/mysql/phpmyadmin/pma__favorite.ibd /var/lib/mysql/phpmyadmin/pma__table_uiprefs.frm /var/lib/mysql/phpmyadmin/pma__recent.ibd /var/lib/mysql/phpmyadmin/pma__usergroups.frm /var/lib/mysql/phpmyadmin/pma__navigationhiding.ibd /var/lib/mysql/phpmyadmin/pma__bookmark.ibd /var/lib/mysql/phpmyadmin/pma__designer_settings.frm /var/lib/mysql/phpmyadmin/pma__tracking.ibd /var/lib/mysql/phpmyadmin/pma__pdf_pages.frm /var/lib/mysql/phpmyadmin/pma__recent.frm /var/lib/mysql/phpmyadmin/db.opt i've answered fix mysql related stuff. if need fix those, can check these questions
Comments
Post a Comment