How to install mysql database in deepin 2014 system

Deepin 2014 download and installation

For downloading and installing Deepin 2014, you can refer to the following two articles. One is for downloading and installing the official version, and the other article shares with you the steps to install Deepin 2014 using a USB flash drive. Friends in need can refer to it for learning:

Deepin 2014.2 official version download and installation tutorial

Deepin 2014 USB installation method and precautions

Okay, let’s move on to the important content of this article: the steps to install the MySQL database under the deepin 2014 system. Let’s take a look.

1: Install mysql

Open deepin terminal:

During this process, you will be prompted to enter the password twice, which is the root account password. Just enter the same password twice. Then press Y all the way to install successfully.

Once the installation is successful, the MySql server will start automatically.

Manually start the mysql service

Manually stop the mysql service

Check whether the mysqld process is started

If the process is started, the command will return the process id.

After you modify the configuration file, you need to restart mysqld for the changes to take effect.

2. File structure

View MySQL configuration file

mysql configuration file, which indicates the data file storage path

Three: Enter mysql

4: MySQL server configuration

All known users on the MySQL server are listed in the user data table in its MySQL database. You can view MySQL accounts and log in as root account

Create an account to use:

MySQL account management operations:

1. CREATE USER: Create a new account and set a password for it (optional)

CREATE USER account [IDENTIFIED BY 'password'];

2. DROP USER: Delete an existing account and all privileges associated with the account:

DROP USER account;

3. RENAME USER: Change the name of an existing account

RENAME USER from_account TO to_account;

The value of account consists of a username and a host name given in the format 'user_name'@'host_name' . The username specifies who can connect, and the hostname specifies where to connect from.

Authorize the account:

To authorize an account, you need to use the GRANT statement:

GRANT privileges (columns)

 ON what

 TO account [IDENTIFIED BY 'password'];

Connect to the MySQL server:

mysql -h host_name -p -u user_name

-h host_name The host name of the server to be connected

-u user_name MySQL username

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.