Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
howto:fix_self_corrupt_mysql [2016/07/28 17:28] bram |
howto:fix_self_corrupt_mysql [2016/07/29 19:34] bram this was breaking mysql because he couldn't read those file due to permission problems |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| # let's backup things | # let's backup things | ||
| cd .. | cd .. | ||
| - | cp -rv mysql mysql.backup | + | cp -rv mysql ../mysql.backup |
| cd mysql | cd mysql | ||
| | | ||
| Line 95: | Line 95: | ||
| | | ||
| # and to recreate agendav user | # and to recreate agendav user | ||
| - | insert into user values('localhost','agendav', PASSWORD('put the password here'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,NULL,'','N','N'); | + | insert into user values('localhost','agendav', PASSWORD('put the password here'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'','','N','N'); |
| GRANT ALL PRIVILEGES ON agendav.* TO 'agendav'@localhost; | GRANT ALL PRIVILEGES ON agendav.* TO 'agendav'@localhost; | ||
| | | ||
| Line 103: | Line 103: | ||
| # you can try a bash script like that: | # you can try a bash script like that: | ||
| # BUT I HAVEN'T TESTED IT | # BUT I HAVEN'T TESTED IT | ||
| - | for i in app1 app2 app3; do mysql -p$(cat /etc/yunohost/mysql) mysql -e "insert into user values('localhost','$i', PASSWORD('$(yunohost app setting $i mysqlpwd)'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,NULL,'','N','N'); GRANT ALL PRIVILEGES ON $i.* TO '$i'@localhost;"; done; mysql -p$(cat /etc/yunohost/mysql) mysql -e "FLUSH PRIVILEGES;" | + | for i in app1 app2 app3; do mysql -p$(cat /etc/yunohost/mysql) mysql -e "insert into user values('localhost','$i', PASSWORD('$(yunohost app setting $i mysqlpwd)'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'','','N','N'); GRANT ALL PRIVILEGES ON $i.* TO '$i'@localhost;"; done; mysql -p$(cat /etc/yunohost/mysql) mysql -e "FLUSH PRIVILEGES;" |