Recently help a friend to make a small tool. Think about it. or Python to write it up faster. By the way, you can review python.The specific is to obtain from the database to all need to detect the IP. Then the multithreading is scanned.
database introductionWhat is a database?A database is a warehouse that organizes, stores, and manages data according to its structure.Each database has one or more different APIs for creating, accessing, managing, searching, and replicating the
log in and exit MySQLMysql-h-p-u-P-E-H Specify Host name-P Specify MySQL server port-U Specify user name-P means login password-e-Connect SQL statementsCreate user1.create user wing;Create user [email protected] ' localhost ' identified by ' 12345 ';
what is a storage engine?The storage engine is a set of programs that is responsible for translating the user's presentation layer (SQL statement) data into the physical layer (database data file) data. MySQL is a plug-in storage engine. What is a
Tools/Materials
Windows operating system
MySQL Database
Method/Step
1Use the Win+r shortcut key to open the DOS command window and locate the bin directory under the MySQL installation directory, such as D:\Program
Delimiter//create procedure OneKey (in NewName varchar (+), in oldname varchar (+), in Idnum INT) beginset @sqlStmt = CONCA T (' insert INTO ', NewName, ' (' Name ', ' age ', ' sex ', ' major ', ' Pass ', ' photo ') Select ' name ', ' age ', ' sex ',
1. Preparatory work① official website Download: https://dev.mysql.com/downloads/mysql/5.6.html#downloads Uploaded to the server after download.② creating a Linux group userGroupadd MySQLuseradd-g MySQL MySQL2. Installation① decompression, such as
Tag: Failed color Strong Sha Description Pen nbsp Success CosFirst, the situation description:Native environment MacOS 10.13.6MySQL version 8.0.12MySQL installed successfully, and the command line successfully ran trying to connect the Nawicat times
1. View all users in MySQL databasemysql> SELECT DISTINCT CONCAT(‘User: ‘‘‘,user,‘‘‘@‘‘‘,host,‘‘‘;‘) AS query FROM mysql.user;+---------------------------------+| query |+---------------------------------+| User: ‘root‘@‘10.
IndexAn index is a special kind of file that contains reference pointers to all the records in the data table. More generally, the database index is like a directory in front of a book, which can speed up the database query.Federated IndexAlso known
The last article just wrote the installation of MySQL, want to use Navicat to connect, and then error, here record error resolution.Navicat client does not support authentication protocol requested by server when connecting to MySQL Server8.0
MySQL Storage engine
A storage mechanism, different functions depending on the engine, and different performance1. Storage Engine Classification
The default database engine before Myisam:mysql 5.0 is most commonly used. Has a higher
MySQL simple operation one, view the database show DATABASES; for example: MariaDB [(None)]> show databases;+--------------------+| Database |+--------------------+| Information_schema | | MySQL | | Performance_schema | | Test |+--------------------+
Tag:cti copyright backup ati acl forgot root password match warning gre MySQL Forget root password does not restart Mysqld method 1, first there must be a MySQL database account can have Modify permissions, the current MySQL
To Configure environment variables:Variable name: mysql_homeVariable Value: E:\mysql-5.7.20-winx64Path added:%mysql_home%\bin;generate the data file:Run cmd as AdministratorInto the E:\mysql-5.7.20-winx64\bin.Execute command:
New My.iniCreate a new TXT document, Save as My.ini, and put it in the MySQL directory[MySQL]# Set the MySQL client default character setDefault-character-set=utf8[Mysqld]#设置3306端口Port = 3306# set up the MySQL installation
MySQL Command introductionMySQL is a database administration commandUse MySQL--help to view relevant parameters and instructionsMySQL--help#mysql Database Administration CommandsUsage:mysql [OPTIONS] [Database] # Syntax Format--help #
Yi, CONCAT (str1,str2,...)Returns the string that results from the connection parameter. If any one of the arguments is NULL, the return value is null.Mysql> Select Concat (' One ', ' one ', ' $ '); +------------------------+| Concat (' One ', ' a ',
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service