MySQL software is a database management system based on C/S mode, which can be associated with MySQL database management system through various client software. MySQL has developed numerous client software to help users manage MySQL software, the most famous of which is MySQL Command line client and Mysql-workbench software.
1. Command-line client software The simple command-line utility is typically installed after the installation of the MySQL software--mysql Command Lines (official)
. You can find and click on the Start menu to open it, then enter the password, login to the MySQL software (provided that the MySQL software service is in the boot state), you will see a welcome content, the Welcome content is:
Commands end with; or \g
command Terminator "; "or" \g ", and you can also use the" g\ "symbol to end.
Your mysql connection ID is 1
where ID represents the client's connection ID, which records the number of connections the MySQL service has so far, and each new connection automatically adds 1.
Server version:5.5.21
MySQL version number
MySQL Community Server (GPL)
means MySQL is Community edition
Type ' Help, ' or ' \h ' for help
Enter ' help; ' or the "\h" command to view the Help information
type ' \c ' to clear the current input statement
Enter the \c command to clear the previous command.
2. Connect the MySQL software via a DOS window
Open the DOS command window, enter Mysql-h 127.0.0.1-u root-p, and perform a newline entry password root.
in the above command, MySQL is logged into the MySQL software command,-H indicates the need to login to the MySQL software IP address,-u followed by the user name,-p followed by the password.
When executing the "mysql-h 127.0.0.1-u root-p" command in a DOS window, an error sometimes occurs: "' MySQL ' is not an internal or external command, it is not a running program or a batch file. ”
This is because when you configure the MySQL software, the Include Bin Directory in Windows PATH check box is not selected.
Workaround:
Method One:
Open My Computer, enter "C:\Program files\mysql Server 5.5\bin" in the Address bar and enter "CMD" again in the Address bar.
Method Two:
Go to the "C:\Program files\mysql Server 5.5\bin" directory, open the MySQLInstanceConfig.exe executable and reconfigure it.
Method Three:
Configure the PATH environment variable, "C:\Program files\mysql Server 5.5\bin".
3. To be proficient in using the MySQL command line client software, you must be familiar with the commands, which is difficult for the novice user. So MySQL officially developed the graphical client software mysql-workbench (official).
Download: Official website Click the Downloads (GA) navigation Bar-click the MySQL Workbench (GUI Tool) hyperlink in the left navigation bar-download.
Installation:
The Installation Type dialog box has two radio buttons:
Complete Full Installation Type
Custom Customized Installation Type
After installation, the last dialog box has the "Launch MySQL Workbench Now" check box, indicating whether to start the software.
4. mysql Common graphical management software--solyog
SQLyog client software was developed by the world-renowned Webyog company, specifically for the MySQL database.
Download, with Trial version trial (free 30 days) and paid version full.
MySQL client software