Shulou(Shulou.com)06/01 Report--

With the development of the Internet, more and more people have entered the IT industry, so how to install database MySQL and MySQL workbench in the liunx system? You know what? In order to let you know more about the SQL database, the editor summarizes the following contents. Let's look down together.

one。 Install MySQL

1. Open the command line ALT+CTRL+T

two。 Enter sudo apt-get install mysql "target=" _ blank "href=" http://undefined">mysql-server and enter the administrator password as required

3. Enter apt-get install mysql-client

4. Enter sudo apt-get install libmysqlclient-dev

Remember to set the SQL password

5. Check sudo netstat-tap | grep mysql

Socket in listen status indicates success

Enter MySQL

1. Enter mysql-u root-p on the command line

two。 Enter password

3. Show database show dataases

Create a new database create database` database name

Enter the database use database name

(more operations are searched on their own, such as database names with naming restrictions)

two。 Install MySQL workbench

1. Search the official website MySQL

two。 Select download

3. Select the community below

4. Select MySQL Workbench

5. Select drop-down menu (select platform) Select Ubuntu Linux

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

7. Open the application and press + to add the database.

8. You can add management data to the database through code commands, or you can manipulate graphics with the mouse.

(if you run the command, press Ctrl+Enter)

After reading the appeal, do you have a general idea of how to install the databases MySQL and MySQL workbench on the liunx system? If you want to know more, welcome to follow the industry information channel!

During the Spring Festival this year, three new "cloud database" products and services were launched: cloud database MySQL, cloud database Redis and cloud database Memcached. Among them, cloud database MySQL is an "online database service" that is ready-to-use, stable, reliable and flexible, with multiple security protection measures and a perfect performance monitoring system, and provides professional database backup, recovery and optimization solutions, so that enterprises and users can focus more on application development and business development. On the other hand, cloud database Redis is a ready-to-use, stable and reliable high-performance data caching service, which supports "master-slave hot backup" and provides "automatic disaster recovery switching, instance monitoring, online capacity expansion" and other functions. Another cloud database product, Cloud Database Memcached, is a memory-level, persistent cache service that also supports "master-slave hot backup" and provides "automatic disaster recovery switching, instance monitoring, online capacity expansion" and other features.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.