[Deepin Liunx system] Install database MySQL and MySQL workbench

1. Install MySQL

1. Open the command lineALT CTRL T

2. Entersudo apt-get install mysql-serverand enter the administrator password as required

3. Enterapt-get install mysql-client

4. Entersudo apt-get install libmysqlclient-dev

Note to remember to set the SQL password

5.Checksudo netstat - tap | grep mysql

If the socket is in the listen state, it means success

Recommended: "mysql video tutorial"

Enter MySQL

1. Entermysql -u root -p

at the command line. 2. Enter the password

3. Display the databaseshow dataases;

Create a new databasecreate database` database name;

Enter the database use database name;

(More operations Search by yourself, if the database name has naming restrictions)

2. Install MySQL workbench

1. Search the official websiteMySQL

2. Selectdownload

3. Selectcommunity

#4. SelectMySQL Workbench

5. Select the drop-down menu (select platform) and selectUbuntu Linux

6. Click below to download directly, open the downloaded file, and select installation

7. Open the application and click Add Database.

8. You can add management data in the database through code commands or mouse graphics operations.

(To run the command, pressCtrl Enter)

The above is the detailed content of [Deepin Liunx system] Install database MySQL and MySQL workbench. For more information, please follow other related articles on the PHP Chinese website!