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

This article shows you how to use the Mysql account and editor. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

SQL data and analysis

Professional perspective data speech data analysis

Mysql account password

It is convenient to learn SQL. A set of Mysql server accounts are provided here for free, which can be operated directly.

Hostname or IP address: 111.230.56.74

Port: 3306

User name: ministep

Password: datastep

Note: in order to facilitate the management of Mysql server, the user rights of ministep are limited here.

Ministep user rights:

Default_db database only has query permissions, but no other permissions to add, delete or delete. (default_db is a table created by an administrator and used as a data table for tutorials, and users can query it in this database.)

Temp_db users have all the permissions of this database, you can create new tables, modify, query, create indexes, and operate freely. If you break it, you won't find it.

No right to create a new database

There are no restrictions on encouraging anything you want to do in the temp_db database.

Risk: the database is public, so all content uploaded to temp_db is also public, so please pay attention to privacy protection

Mysql Editor

Encourage the use of navicat editors, better graphical management and development tools for MySQL databases

The official Chinese version is available for download and trial (for 30days), and the cracked version is available here.

Link: https://pan.baidu.com/s/11r7xKBxiPxzHLu4_VQlvqA password: fpky

The graphical interface is as follows

Navicat can easily connect to the database and manage queries graphically.

Navicat can easily import data in external excel, csv, txt and other formats.

Navicat usage actions:

Graphical Management and Development tools of Navicat for MySQL Database

Supplement

How does mysql create a database and give users permission to operate?

# create a database

Create database default_db default character set utf8 collate utf8_bin; # create default database

Create database temp_db default character set utf8 collate utf8_bin; # create temp_db database

# create a user ministep and give only select permission to the default_db database

Grant select on default_db.* to 'ministep'@'%' identified by' datastep' with grant option

# create a user ministep and grant all permissions to the temp_db database, including (all permissions for temp_db database operations such as select, insert,update, delete, etc.)

Grant all on temp_db.* to 'ministep'@'%' identified by' datastep' with grant option

# Refresh permissions

The above content of flush privileges; is how to use Mysql account and editor. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.