服务器重启,莫名的原因导致mysql的user表坏掉,尝试了半天还是不能恢复,还是重新安装吧
sudo apt-get remove mysql-common
sudo apt-get autoremove --purge mysql-server-5.7
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
sudo apt-get install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev
#!/bin/bash
function uninstall(){
echo ">>> uninstalling mysql."
sudo apt-get remove mysql-common
sudo apt-get autoremove --purge mysql-server-5.7
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
echo "uninstall ok."
}
function install(){
echo ">>> installing mysql."
sudo apt-get install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev
echo "install ok."
}
uninstall
install
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。