在web后台开发中,往往会涉及到json数据的存储,我相信很多人都会将其转成json字符串的形式存到数据库中,比如mysql;而每次需要处理数据的时候都是取出来在应用程序来解析,这时候就会想要是能直接存储json多好。
mysql新版本5.7版新增加了这样的功能,专门设计了JSON数据类型以及关于这种类型的检索以及其他函数解析。下面将介绍安装mysql5.7:
卸载原先老版mysql:
sudo apt-get remove mysql-server sudo apt-get autoremove mysql-server sudo apt-get remove mysql-common //这个很重要
安装mysql5.7(ubuntu14.04):
1:注意:如果直接apt-get install 这种方式安装mysql的话都是安装的mysql5.5,所以一下操作都是手动安装,谢谢合作!
2:下载mysql5.7:点我点我点我,下载完之后放到linux对应文件夹下,我是放在/usr/local/src下面
3:解压之后你会发现很多文件,对没错,就是这么多,
tar -xf mysql-server_5.7.19-1ubuntu14.04_amd64.deb-bundle.tar libmysqlclient20_5.7.19-1ubuntu14.04_amd64.deb libmysqlclient-dev_5.7.19-1ubuntu14.04_amd64.deb libmysqld-dev_5.7.19-1ubuntu14.04_amd64.deb mysql-client_5.7.19-1ubuntu14.04_amd64.deb mysql-common_5.7.19-1ubuntu14.04_amd64.deb mysql-community-client_5.7.19-1ubuntu14.04_amd64.deb mysql-community-server_5.7.19-1ubuntu14.04_amd64.deb mysql-community-source_5.7.19-1ubuntu14.04_amd64.deb mysql-community-test_5.7.19-1ubuntu14.04_amd64.deb mysql-server_5.7.19-1ubuntu14.04_amd64.deb mysql-testsuite_5.7.19-1ubuntu14.04_amd64.deb mysql-community_5.7.19-1ubuntu14.04_amd64.changes
4:安装依赖包(先更新源):
apt-get update apt-get upgrade apt-get install libaio1 apt-get -f install apt-get -f install libmecab2
5:开始了啊,准备了这么久就等这一刻,安装上面出现的deb包:
dpkg -i mysql-common_5.7.19-1ubuntu14.04_amd64.deb dpkg-preconfigure mysql-community-server_5.7.19-1ubuntu14.04_amd64.deb //这步会配置mysql账户密码 dpkg -i libmysqlclient20_5.7.19-1ubuntu14.04_amd64.deb dpkg -i libmysqlclient-dev_5.7.19-1ubuntu14.04_amd64.deb dpkg -i libmysqld-dev_5.7.19-1ubuntu14.04_amd64.deb dpkg -i mysql-community-client_5.7.19-1ubuntu14.04_amd64.deb dpkg -i mysql-client_5.7.19-1ubuntu14.04_amd64.deb dpkg -i mysql-common_5.7.19-1ubuntu14.04_amd64.deb
6:进入mysql查看版本:
mysql -uroot -p密码 mysql> select version();//出现的是你的安装版本的话就说明成功了,比如这里:5.7.19