Ubuntu 安装&删除 mySql-server

Ubuntu 安装&删除 mySql-server

安装mySql-server
1.sudo apt-get install mysql-server-5.7
2.sudo apt-get install mysql-client

出现错误
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
解决方法:
使用/ect/mysql/debian.cnf里面的user和password

添加用户
1.进入mySql,执行
mysql> grant all on *.* to userName@"%" identified by "password" ;
UserName:用户名
%:匹配所有主机地址
password:密码

删除mySql-server
1.sudo apt-get autoremove –purge mysql-server
2.sudo apt-get remove mysql-common

清理残余文件
3.dpkg -l |grep ^rc|awk ‘{print $2}’ |sudo xargs dpkg -P