[Deepin Liunx system] Install database MySQL and MySQL workbench

1. Install MySQL

1. Open the command lineALT CTRL T

2. Enter sudo apt-get install mysql-server and enter the administrator password as required

3. Enter apt-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. Enter mysql -u root -p

at the command line. 2. Enter the password

3. Display the database show 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. Select download

3. Select community

#4. Select MySQL Workbench

5. Select the drop-down menu (select platform) and select Ubuntu 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, press Ctrl 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!