尝试多次apt-get install报错,那就别偷懒,下载文件包一个一个安装吧。
首先彻底删除:
彻底卸载软件
# 删除软件及其配置文件
apt-get --purge remove mysql-server mysql-client
# 删除没用的依赖包
apt-get autoremove mysql-server mysql-client
# 此时dpkg的列表中有“rc”状态的软件包,可以执行如下命令做最后清理:
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
(然后...开工~)
(如果后续工作中有问题,考虑更换/etc/apt/sources.list:
deb http://mirrors.163.com/debian/ jessie main non-free contrib
deb http://mirrors.163.com/debian/ jessie-updates main non-free contrib
deb http://mirrors.163.com/debian/ jessie-backports main non-free contrib
deb-src http://mirrors.163.com/debian/ jessie main non-free contrib
deb-src http://mirrors.163.com/debian/ jessie-updates main non-free contrib
deb-src http://mirrors.163.com/debian/ jessie-backports main non-free contrib
deb http://mirrors.163.com/debian-security/ jessie/updates main non-free contrib
deb-src http://mirrors.163.com/debian-security/ jessie/updates main non-free contrib
)
1.下载deb-bundle文件包
首先登录服务器
执行: wget -c https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server_5.7.18-1ubuntu16.04_amd64.deb-bundle.tar
下载DEB-bundle包
然后执行解压
解压命令为:
tar –xvf mysql-server_5.7.18-1ubuntu16.04_amd64.deb-bundle.tar
解压完得到一大堆deb的文件:
mysql-testsuite_5.7.18-1ubuntu16.04_amd64.deb
mysql-community-client_5.7.18-1ubuntu16.04_amd64.deb
mysql-community-server_5.7.18-1ubuntu16.04_amd64.deb
mysql-community-test_5.7.18-1ubuntu16.04_amd64.deb
libmysqlclient20_5.7.18-1ubuntu16.04_amd64.deb
mysql-client_5.7.18-1ubuntu16.04_amd64.deb
libmysqld-dev_5.7.18-1ubuntu16.04_amd64.deb
mysql-community-source_5.7.18-1ubuntu16.04_amd64.deb
libmysqlclient-dev_5.7.18-1ubuntu16.04_amd64.deb
mysql-server_5.7.18-1ubuntu16.04_amd64.deb
mysql-common_5.7.18-1ubuntu16.04_amd64.deb
2.执行安装
然后按照顺序依次安装这些文件
sudo dpkg -i mysql-common_5.7.18-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.18-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.18-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-client_5.7.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-source_5.7.18-1ubuntu16.04_amd64.deb
(中间可能会让安装libaio等依赖包,可以使用apt-get install安装,如果版本不对,注意先apt-get update,apt-get upgrade,然后再install;或者实在版本不对,在网上找到包的下载地址,使用wget下载,再安装。)
3.下载安装libmecab2
剩下的这一步需要下载依赖库libmecab2,这块折腾了很久,因为第一次下载的版本是0.996-1.1的,而最新的mysql-community-server要求版本>=0.996-1.2
先执行命令 sudo dpkg -r libmecab2 删除旧版本
然后重下,但是最后安装不了,然后又换了几个下载地址才搞定...
安装最后一个文件:
sudo dpkg -i mysql-community-server_5.7.18-1ubuntu16.04_amd64.deb
然后就可以登录啦 :Mysql -u username -p【password】
4.开启远程访问
启动和停止的命令
/etc/init.d/mysql start
/etc/init.d/mysql stop
mysql安装之后,需要开启远程访问权限
创建用户并且赋予权限
脚本如下:
GRANT <ALL|priv1,priv2,.....privn> ON
[object] [IDENTIFIED BY 'password']
[WITH GRANT OPTION];
MAX_QUERIES_PER_HOUR count
MAX_UPDATES_PER_HOUR count
MAX_CONNECTIONS_PER_HOUR count
MAX_USER_CONNECTIONS count
说明:priv代表权限select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file等14个权限
示例:
grant select,insert,update,delete,create,drop on test.hr to user@192.168.10.1 identified by '123';
表示为用户user创建从地址192.168.10.1对数据库test的hr表进行select,insert,update,delete,create,drop的权限,其密码为123
grant select,insert,update,delete,create,drop on *.* to user@'%' identified by '123';
表示为用户user创建从任何远程地址对数据库的所有库和表进行select,insert,update,delete,create,drop的权限,其密码为123
执行完后需要刷新权限:
flush privileges;
然后发现还是访问不了...
查找资料得知下面的方法:
把/etc/mysql/my.cnf文件中的
bind-address = 127.0.0.1
修改为
bind-address = 0.0.0.0 或者注释掉
但是我打开这个文件发现没有这个参数,
然后发现远程无法访问,
后来查到运行这个命令:
netstat -apn|grep 3360
结果为:
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 26255/mysqld
3306端口绑定到了本地
最后然后终于在
/etc/mysql/mysql.conf.d/mysqld.conf
这个目录中找到了参数,修改完重启就OK了
如果是使用云服的同学,记得在管理端的安全策略中打开3306等端口的访问权限。
========
参考博客:
(https://blog.csdn.net/m0_37739193/article/details/78690593)
今天需要在Debian中安装mysql测试,可是一直安装不上,很是郁闷。。
root@h21:~# apt-get install mysql-server
root@h21:~# apt-get install mysql-client
注意:我在Debian8.6 64位中出现这个报错:
- root@debian:~# apt-get install mysql-server
- Reading package lists... Done
- Building dependency tree
- Reading state information... Done
- The following extra packages will be installed:
- libdbd-mysql-perl libdbi-perl libhtml-template-perl libterm-readkey-perl mysql-client-5.5 mysql-server-5.5
- Suggested packages:
- libmldbm-perl libnet-daemon-perl libsql-statement-perl libipc-sharedcache-perl tinyca
- The following NEW packages will be installed:
- libdbd-mysql-perl libdbi-perl libhtml-template-perl libterm-readkey-perl mysql-client-5.5 mysql-server mysql-server-5.5
- 0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded.
- Need to get 3,606 kB/4,517 kB of archives.
- After this operation, 72.4 MB of additional disk space will be used.
- Do you want to continue? [Y/n