Virtualmin mysql问题
今天我更改了 VPS 上的一些 chmod 设置，从那时起我就无法访问任何 mysql 数据库。就好像他们全部都消失了一样。我还必须重置 ssh 密钥。
我收到的错误之一是“SQL 显示字符集失败：无法创建/写入文件”
关于如何将所有内容恢复到以前的设置有什么想法吗？
Today i changed some chmod settings on my VPS and since then I haven't been able to access any of my mysql databases. It's like all of them dissapeared. And I also had to reset the ssh keys.
One of the errors im getting is "SQL show character set failed : Can't create/write to file"
any idea on how i can restore everything to my previous setup?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您不知道更改了哪些文件，最简单的解决方案是从最新的备份进行恢复。
否则，困难的方法是找出每个文件应具有哪些权限和所有权并手动设置它们。例如，MySQL 数据文件应由 MySQL 用户拥有。
我对 Webmin 不了解 - 作为系统管理员，学习命令行会让您受益匪浅。
If you don't know which files you've changed, the easiest solution is to restore from your latest backup.
The hard way is otherwise to figure out which permissions and ownerships each file should have and set them manually. MySQL data files should for example be owned by the MySQL user.
I have no idea about Webmin - you will benefit a lot as a sysadmin from learning the commandline.