Navicat for MySQL
1、Navicat for MySQL安装
$ wget http://download.navicat.com/download/navicat111_mysql_en.tar.gz
$ tar -xzvf navicat111_mysql_en.tar.gz
$ cd navicat_for_mysql //进入解压目录
$ ./start_navicat //启动
对于32位的CentOS7 来说上面的步骤应该就能用了。但是对于64位的系统,执行./start_navicat看不到任何效果。原因是缺少一些必要的包。
解决办法:
$ yum install --setopt=protected_multilib=false libgcc.i686
$ yum install --setopt=protected_multilib=false glibc.i686
$ yum install --setopt=protected_multilib=false freetype.i686
$ yum install --setopt=protected_multilib=false libSM.i686
$ yum install --setopt=protected_multilib=false libXext.i686
$ ./start_navicat #重新启动,看是否有反应
如果还是启动不了,直接运行下面yum就可以了:
yum install alsa-lib-devel audiofile-devel.i686 audiofile-devel cups-devel.i686 cups-devel dbus-devel.i686 dbus-devel fontconfig-devel.i686 fontconfig-devel freetype.i686 freetype-devel.i686 freetype-devel giflib-devel.i686 giflib-devel lcms-devel.i686 lcms-devel libICE-devel.i686 libICE-devel libjpeg-turbo-devel.i686 libjpeg-turbo-devel libpng-devel.i686 libpng-devel libSM-devel.i686 libSM-devel libusb-devel.i686 libusb-devel libX11-devel.i686 libX11-devel libXau-devel.i686 libXau-devel libXcomposite-devel.i686 libXcomposite-devel libXcursor-devel.i686 libXcursor-devel libXext-devel.i686 libXext-devel libXi-devel.i686 libXi-devel libXinerama-devel.i686 libXinerama-devel libxml2-devel.i686 libxml2-devel libXrandr-devel.i686 libXrandr-devel libXrender-devel.i686 libXrender-devel libxslt-devel.i686 libxslt-devel libXt-devel.i686 libXt-devel libXv-devel.i686 libXv-devel libXxf86vm-devel.i686 libXxf86vm-devel mesa-libGL-devel.i686 mesa-libGL-devel mesa-libGLU-devel.i686 mesa-libGLU-devel ncurses-devel.i686 ncurses-devel openldap-devel.i686 openldap-devel openssl-devel.i686 openssl-devel zlib-devel.i686 pkgconfig sane-backends-devel.i686 sane-backends-devel xorg-x11-proto-devel glibc-devel.i686 prelink fontforge flex bison libstdc++-devel.i686 pulseaudio-libs-devel.i686 gnutls-devel.i686 libgphoto2-devel.i686 openal-soft-devel openal-soft-devel.i686 isdn4k-utils-devel.i686 gsm-devel.i686 samba-winbind libv4l-devel.i686 cups-devel.i686 libtiff-devel.i686 gstreamer-devel.i686 gstreamer-plugins-base-devel.i686 gettext-devel.i686 libmpg123-devel.i686
启动Navicat
$ ./start_navicat
弹出安装自带的wine界面,点击安装,按照提示下一步即可完成安装,安装完成后弹出Navicat界面,由于是试用版本有14天使用限制,如14天到期,需删除隐藏【.navicat】文件夹中的system.reg、user.reg文件,相当于软件初始化了,需要重新配置相关的数据库链接信息,重新计算14天使用期限。
2、创建快捷方式(以放在应用程序为例)
$ cd /usr/share/applications #切换到应用程序存放快捷方式的文件夹
$ vim navicat.desktop
#(按i编辑模式,粘贴下面内容)
#******************************************************************************
[Desktop Entry]
Encoding=UTF-8
Name=Navicat Premium
Comment=The Smarter Way to manage dadabase
Exec=/bin/sh "/home/XXXXX/navicat111_mysql_en/start_navicat" #navicat安装路径
Icon=/home/XXXXX/navicat111_mysql_en/navicat.png #navicat快捷方式图标文件路径
Categories=Application;Database;MySQL;navicat
Version=1.0
Type=Application
Terminal=0
#******************************************************************************
#(添加上述内容后,按Esc键,输入:wq!回车即可保存退出vim)
$ sudo chmod 777 navicat.desktop
这里提供一个图标给大家(右键另存到所需存放的路径下即可)