安装mysql workbench 5.2.37

首先安装软件依赖:

CentOS:

yum install pcre-devel libglade2-devel gtkmm24-devel libgnome-devel lua-devel libzip-devel mysql-devel libglade2-devel uuid-devel pexpect

Ubuntu:

sudo apt-get install g++ libctemplate0 libmysqlclient16 libzip1 python-paramiko mysql-client python-pysqlite2;

附:

安装支持openssl

sudo apt-get install openssl

sudo apt-get install libssl-dev

sudo apt-get install libssl0.9.8

sudo apt-get install libgtk2.0-dev

mysql操作

1.更改用户密码

update user set password=PASSWORD('sa') where user='root';