安装
下载: https://dev.mysql.com/downloads/mysql/5.7.html.
percona下载: https://www.percona.com/doc/percona-server/5.7/index.html.
deb安装: https://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html.
修改/etc/mysql/mysql.conf.d中的配置文件
mysql -h localhost -u root -p
use mysql
# 设置访问权限
# 其中"*.*"代表所有资源所有权限, “'root'@%”其中root代表账户名,%代表所有的访问地址。IDENTIFIED BY '密码',这里换成数据库root用户的密码,WITH GRANT OPTION表示允许级联授权。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT
OPTION;
# 刷新访问权限表(不要忘了)
FLUSH PRIVILEGES;
# 验证
SELECT User, Host FROM user;
sudo /etc/init.d/mysql restart
卸载
# 首先在终端中查看MySQL的依赖项:
dpkg --list|grep 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
# 再次查看MySQL的剩余依赖项:
dpkg --list|grep mysql
# 继续删除剩余依赖项,如:
sudo apt-get autoremove --purge mysql-apt-config