Shulou(Shulou.com)05/31 Report--

This article is about how to install Mysql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

To learn mysql slowly, start with the installation of mysql.

Os version: windows7 Home ordinary version

Mysql version: 5.7.15.0

Download link for mysql: http://dev.mysql.com/downloads/mysql/

1. Download and install mysql

A. The version of mysql

B.mysql installation interface, according to the prompts step by step next.

two。 Add the C:\ Program Files\ MySQL\ MySQL Server 5.7\ bin directory to the system environment variable PATH of windows. Enter mysql-u root-p in the command line interface to enter the mysql interface, and I set the root user password to root.

3. The first table of the query select * from mysql.user

The user table describes:

User is a table under mysql that records the information of users and related permissions.

The primary key is: Host+User

Host: indicates the host from which the account is allowed to go online.

User: account number.

Password: password.

-the following parts are from copy directly on the Internet, ^ _ ^-

Select_priv . Determines whether the user can select data through the SELECT command.

Insert_priv . Determines whether the user can insert data through the INSERT command.

Update_priv . Determines whether the user can modify existing data through the UPDATE command.

Delete_priv . Determines whether the user can delete existing data through the DELETE command.

Create_priv . Determines whether users can create new databases and tables.

Drop_priv . Determines whether users can delete existing databases and tables.

Reload_priv . Determines whether users can perform specific commands to refresh and reload various internal caches used by MySQL, including logs, permissions, hosts, queries, and tables.

Shutdown_priv . Determine if the user can shut down the MySQL server. Great care should be taken when granting this permission to any user outside the root account.

Process_priv . Determine whether users can view the processes of other users through the SHOW PROCESSLIST command.

File_priv . Determine whether the user can execute the SELECT INTO OUTFILE and LOAD DATA INFILE commands.

Grant_priv . Determines whether a user can grant permissions that have been granted to the user himself to other users. For example, if a user can insert, select, and delete information from an foo database and grant GRANT permissions, the user can grant any or all of his or her privileges to any other user in the system.

References_priv . Currently it's just a placeholder for some future functionality; it doesn't work now.

Index_priv . Determines whether the user can create and delete table indexes.

Alter_priv . Determines whether the user can rename and modify the table structure.

Show_db_priv . Determines whether the user can view the names of all databases on the server, including those to which the user has sufficient access. Consider disabling this permission for all users, unless there is a particularly irresistible reason.

Super_priv . Determine whether the user can perform some powerful administrative functions, such as deleting the user process through the KILL command and using SET

GLOBAL modifies the global MySQL variable to execute various commands about replication and logging.

Create_tmp_table_priv . Determines whether the user can create a temporary table.

Lock_tables_priv . Determines whether the user can use the LOCK TABLES command to block access / modification to the table.

Execute_priv . Determines whether the user can execute the stored procedure. This permission only makes sense in MySQL 5.0 and later.

Repl_slave_priv . Determines whether the user can read the binary log files used to maintain the replicated database environment. This user is located in the main system and facilitates communication between the host and the client.

Repl_client_priv . Determines whether the user can determine the location of the replication slave server and the master server.

Create_view_priv . Determines whether the user can create a view. This permission only makes sense in MySQL 5.0 and later. For more information about views, see Chapter 34.

Show_view_priv . Determines whether the user can view the view or understand how the view is executed. This permission only makes sense in MySQL 5.0 and later. For more information about views, see Chapter 34.

Create_routine_priv . Determines whether the user can change or discard stored procedures and functions. This permission was introduced in MySQL 5. 0.

Alter_routine_priv . Determines whether the user can modify or delete storage functions and functions. This permission was introduced in MySQL 5. 0.

Create_user_priv . Determines whether the user can execute the CREATE USER command, which is used to create a new MySQL account.

Event_priv . Determines whether the user can create, modify, and delete events. This permission is new to MySQL 5.1.6.

Trigger_priv . Determine whether the user can create and delete triggers, which is new to MySQL 5.1.6.

In addition, mysql does not allow remote access by default, nor does it support remote access for root users, because the values of the host field: localhost and 127.0.0.1 both represent local access. The host field can also be assigned to an IP address or%, which means that you can connect anywhere.

Thank you for reading! This is the end of this article on "how to install Mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.