Article Source: http://blog.csdn.net/sunrier/article/details/7572299
Installation of MySQL administrator and MySQL Query browser under Linux
The following is my first installation process (Red Hat Enterprise Linux 5)
Download Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12-rhel4-i386.tar.gz/from/pick on the website first
The first login needs to be registered and then downloaded mysql-gui-tools-5.0r12-rhel4-i386.tar.gz
Unzip the downloaded file:
[Email protected] mysql]# TAR-XZVF mysql-gui-tools-5.0r12-rhel4-i386.tar.gz
[Email protected] mysql]#
Using the LS command to see the extracted four packages
mysql-administrator-5.0r12-1rhel4.i386.rpm
mysql-gui-tools-5.0r12-1rhel4.i386.rpm
mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm
mysql-query-browser-5.0r12-1rhel4.i386.rpm
Baidu the role of the above file is explained that MySQL administrator is used to manage MySQL Server, you can view the current system status, new users and so on. While MySQL Querybrowser can be used to view database content, create, execute, and optimize SQL queries for MySQL database servers with the simplest visualization tools. MySQL migration Toolkit database data format conversion software that can be migrated from databases such as Ms Sql,oracle to MySQL.
Start installing the package, which is also the first time I installed, generally in accordance with their own feelings to install
[Email protected] mysql]# RPM-IVH mysql-administrator-5.0r12-1rhel4.i386.rpm
error:failed dependencies:
Mysql-gui-tools = 5.0r12 is needed by mysql-administrator-5.0r12-1rhel4.i386
[Email protected] mysql]#
Look at the above information needs to rely on file Mysql-gui-tools, then I will install mysql-gui-tools this first package
[Email protected] mysql]# RPM-IVH mysql-gui-tools-5.0r12-1rhel4.i386.rpm
Preparing ... ########################################### [100%]
1:mysql-gui-tools ########################################### [100%]
[Email protected] mysql]#
Mysql-gui-tools This package was installed successfully
Continue to install Mysql-administrator, the beginning of the package
[Email protected] mysql]# RPM-IVH mysql-administrator-5.0r12-1rhel4.i386.rpm
Preparing ... ########################################### [100%]
1:mysql-administrator ########################################### [100%]
[Email protected] mysql]#
Continue to install Mysql-query-browser, the beginning of the package
[Email protected] mysql]# RPM-IVH mysql-query-browser-5.0r12-1rhel4.i386.rpm
Preparing ... ########################################### [100%]
1:mysql-query-browser ########################################### [100%]
[Email protected] mysql]#
After all the installation is complete, click "Application" and select "MySQL Administrator" in "programming" to open the GUI MySQL Administrator
MySQL Administrator Settings:
Server Hostname write localhost or 127.0.0.1
Username default to root (or other set of users)
Password fill in the user password when you install MySQL
Other items may not be filled in temporarily
MySQL Query Browser settings:
Server Hostname write localhost or 127.0.0.1
Username default to root (or other set of users)
Password fill in the user password when you install MySQL
Other items may not be filled in temporarily
So far my MySQL administrator and MySQL Query browser have all been successfully installed, and I will use these two tools to manage MySQL.
Other needs to be set according to the following document information
Http://wenku.baidu.com/view/ac9535c6bb4cf7ec4afed0ac.html
Http://wenku.baidu.com/view/c44c0700a6c30c2259019e54.html?from=rec&pos=0&weight=28&lastweight=7 &count=5
Or Baidu, Google, etc.
Linux install MySQL admin tool mysql administrator and MySQL Query Browser (reprint)