MySQL management tools: swiss army knife that harnesses the database world

MySQL it is the most popular relational database management system today (RDBMS) one. it is known for its speed, reliability and scalability. manage effectively MySQL database, you need to use the appropriate tools. this article will discuss various MySQL manage tools and help you choose the one that best suits your needs.

graphical user interface (GUI) tool

GUI tools provide a user-friendly interface that can be easily managed even for database novice MySQL database. here are a few popular ones GUI tool:

• MySQL Workbench：MySQL official tools that provide a comprehensive set of features including database design, query editing and data management.
• Navicat： third-party tools that support various databases, including MySQL、MariaDB and Oracle。
• Sequel Pro：specially for macOS designed for free tools, known for their ease of use and powerful features.
• DBeaver： open source tools that support multiple databases, including MySQL、PostgreSQL and SQLite。

command line tools

command line tools provide management in terminal MySQL a more advanced way to databases. here are a few popular command line tools:

• mysql：MySQL official command line tool for execution SQL query and manage databases.
• mysqldump： for export MySQL database tools.
• mysqladmin： for management MySQL the server tool.

cloud hosting service

cloud hosting services provide a cloud-based platform for management MySQL database. here are a few popular cloud hosting services:

• Amazon RDS： amazon cloud technology (AWS) fully managed services provided for MySQL database.
• Google Cloud SQL：Google cloud platform (GCP) fully managed services provided for MySQL database.
• Azure Database for MySQL：Microsoft Azure fully managed services provided for MySQL database.

choose the right tool

choose the right one MySQL the management tool depends on your needs and preferences. here are some factors to consider:

• functionality: consider the tool features you need, such as database design, query editing, or data management.
• interface: choose a tool with a user-friendly interface that enables you to manage your database easily.
• support: make sure that the tool you choose is well supported and that you can get timely updates and troubleshooting help.
• cost: compare the costs of different tools and choose one that suits your budget.

in conclusion

MySQL the management tool is management MySQL an indispensable tool for databases. by using the right tools, you can simplify tasks, increase efficiency, and ensure the database runs smoothly. the various tools discussed in this article provide a range of features and interfaces that allow you to choose the most suitable tool according to your needs and preferences.

---

python how many components are there (2023latest answers in the year )

commonly used bioinformatics python what libraries are there

commonly used bioinformatics python library:

Python the default graphical interface interface. Tkinter is a and Tk interface Python module, Tkinter the library provides the right TkAPI the interface, which belongs to Tcl/Tk of GUI tool group.

for pythonGUI program development GTK+library. GTK it is used to achieve GIMP and Gnome library.

for python of Qt development library. QT that's achieved KDE the library of the environment is composed of a series of modules, qt,qtcanvas,qtgl,qtnetwork,qtsql,qttable,qtuiandqtxml，contains 300 classes and more than 5750 functions and methods. PyQt also support one qtext module, which contains a QScintilla library. this library is Scintillar editor class Qt interface.

GUI programming framework,familiarMFCpeople will like it very much, it is simply the same architecture (for beginners or users who have low design requirements, use it BoaConstructor can be carried out easily and quickly wxPython development)

python provides powerful graphics processing capabilities and provides a wide range of graphics file format support. this library can convert, print and display graphics formats. it can also perform some graphic effects processing, such as enlarging, reducing and rotating the graphics. yes Python a powerful tool for users to process images.

one Python code accelerator, can Python the execution speed of the code is increased to the same level as the compiled language.

Jabber the server is developed XMPP protocol, GoogleTalk also adopted XMPP the agreement IM system. exist Python one of them xmpppy the module supports this protocol. that is, we can use the module to Jabber server communication, isn't it very Cool。

for multimedia operations python module. it provides rich and simple interfaces for multimedia processing (wav,mp3,ogg,avi,divx,dvd,cddaetc)。 available in Windows and Linux used under the platform.

Pythonmegawidgets，Python super GUI component set, one in python utilization Tkinter advanced module building GUI components, each Pmw all merged one or more Tkinter components for more useful and complex functions.

use Python analyze and process XML documentation toolkit, 4 in the package DOM it is completely compatible with W3CDOM standardized. it contains the following:

xmlproc: a compliant with the specification XML parser. Expat: a fast, non-verified XML parser. there are other people of his level PyHtmlPySGML。

modules for multimedia development and game software development.

the module is encapsulated OpenGL application programming interface”, through this module python programmers can integrate 2 in the program D and 3 D graphic.

NumPy、NumArray、SAGE

NumArray yes Python an extended library is mainly used to handle fixed-type arrays of any dimension. simply put, it is a matrix library. its underlying code uses C come to write, so the advantage of speed is obvious. SAGE it is based on NumPy mathematics packages integrated with several other tools are aimed at replacing Magma,Maple,Mathematica and Matlab this type of tool.

for connection MySQL database. also used for zope of ZMySQLDA the module can be used in zope medium connection mysql database.

for connection sqlite database.

Python-ldap

provides a set of object-oriented API， can be conveniently located in python visit ldap directory service, it is based on OpenLDAP2.x。

send an email.

defined FTP classes and some methods for client side ftp programming. if you want to know ftp for details of the agreement, please refer to RFC959。

OpenCL of Python the interface can be used through this module GPU implement parallel computing.

10indivual Python image editing tools

these mentioned below Python tools provide simple and direct methods in editing images and manipulating underlying image data.

--ParulPandey

today's world is full of data, and image data is a very important part of it. however, only by processing and analyzing, improving the quality of the image and extracting effective information from it can these image data be utilized.

common image processing operations include displaying images, basic image operations, such as cropping, flipping, rotation; image segmentation, classification, feature extraction; image recovery; and image recognition, etc. Python as an increasingly popular scientific programming language, it is the best choice for these image processing operations. at the same time, Python there are also many excellent image processing tools that can be used for free in the ecosystem.

here are 10 items that can be used for image processing tasks Python libraries, they provide simple and direct methods in editing images and viewing underlying image data.

scikit-image it's a combination NumPy open source for array use Python tools that implement algorithms and applications that can be used for research, education, industrial applications. even for just contact Python for newbies in the ecosystem, it is also a library that is simple enough to use. at the same time, its code quality is also high because it is made by an active volunteercommunitydeveloped and passed peer review (peerreview)。

scikit-image the documentation is very well-established and contains a wealth of use cases.

can be imported skimage most of the functions can be found in its submodules.

image filtering (imagefiltering)：

use match_template()method to achieve template matching (templatematching)：

you can see more relevant examples on the display page.

NumPy provides support for arrays, Python a core library for programming. the essence of an image is actually a standard that contains pixel data points. NumPy arrays, so some basic NumPy operations (such as slices, masks (mask)、fancy indexing (fancyindexing)), you can edit the image from the pixel level. pass NumPy the images stored in the array can also be skimage load and use matplotlib show.

exist NumPy the official documentation provides a complete list of code documentation and resources.

use NumPy masked images (mask)operate:

picture NumPy same, SciPy yes Python a core scientific computing module can also be used for basic operation and processing of images. especially SciPyv1.1.0 submodule in which it provides n dimension NumPy running functions on an array. SciPy linear and nonlinear filtering are also available (linearandnon-linearfiltering)、binary morphology (binarymorphology)、B spline interpolation (B-splineinterpolation)、object measurement (objectmeasurements)functions of etc.

the complete list of functions that can be found in the official documentation.

use SciPy gaussian filtering blurs the image:

PIL(PythonImagingLibrary)it's a free Python programming library, which provides support for opening, editing and saving image files in multiple formats. but after 2009 PIL stop releasing new versions. fortunately, there is another one PIL actively developed branches Pillow， its installation process is more PIL simpler, supports most mainstream operating systems, and also supports Python3。 Pillow it contains basic processing functions of images, including pixel point operation, filtering using built-in convolution kernel, color space conversion, etc.

Pillow official documentation provided Pillow installation instructions for each module in your own code base.

use Pillow in-house ImageFilter the module implements image enhancement:

OpenCV（OpenSourceComputerVision library) is one of the most widely used libraries in the field of computer vision. OpenCV-Python yes OpenCV of PythonAPI。 OpenCV-Python it runs very fast, thanks to its use C/C++the background code written, and as it uses Python encapsulation, so calling and deploying is not difficult. these advantages make OpenCV-Python become a good choice for computing-intensive computer vision applications.

it is best to read before getting started OpenCV2-Python-Guide this document.

use OpenCV-Python pyramid fusion (PyramidBlending)fuel apples and oranges together:

SimpleCV it is an open source computer vision framework. it supports including OpenCV some high-performance computer vision libraries include, without understanding the bit depth (bitdepth)、file format, color space (colorspace)concepts like this, so SimpleCV ofstudycurve comparison OpenCV much smoother, as its slogan says, “make computer vision simpler.” SimpleCV the advantages are:

the official documentation is simple and easy to understand, and it also comes with a large number of learning use cases.

the documentation contains installation introduction, examples and some Mahotas getting started tutorial.

Mahotas strive to use a small amount of code to implement functions. for example this FindingWally game:

ITK（InsightSegmentationandRegistrationToolkit） it is an open source, cross-platform tool suite that provides developers with universal image analysis functions. SimpleITK it is based on ITK a simplified layer built to facilitate ITK application in rapid prototyping, education, and interpreted language. SimpleITK as an image analysis toolkit, it also comes with a large number of components that can support conventional filtering, image segmentation, and image registration. (registration)function. although SimpleITK use C++written, but it also supports including Python most programming languages ​​include.

there are many JupyterNotebooks use cases can be displayed SimpleITK applications in the fields of education and scientific research, through these use cases, you can see how to use it Python and R use SimpleITK to realize interactive image analysis.

use Python+SimpleITK implemented CT/MR image registration process:

pgmagick yes to use Python encapsulated GraphicsMagick library. GraphicsMagick often considered the swiss army knife in the image processing industry, because its powerful and efficient toolkit supports reading and writing operations on image files in up to 88 mainstream formats, including DPX、GIF、JPEG、JPEG-2000、PNG、PDF、PNM、TIFF etc.

pgmagick of GitHub there are relevant installation instructions, dependency lists, and detailed usage instructions in the warehouse.

image scaling:

edge extraction:

Cairo is a two-dimensional graphic library for drawing vector graphics, and Pycairo yes for Cairo a group of Python bind. the advantage of vector graphics is that the image's sharpness will not be lost during the process of scaling. use Pycairo can be Python called in Cairo related commands.

Pycairo of GitHub the warehouse provides detailed instructions on installation and use, as well as a brief introduction Pycairo getting started guide.

use Pycairo draw line segments, basic graphics, radial gradients (radialgradients)：

the above is Python some of the useful image processing libraries in it, whether you have heard of it or not, are worth trying it out and learning about them.

author: ParulPandey topic: lujun9972 translator: HankChow proofreading: wxy

exist python how many standard libraries are there in total?

Python the official language reference manual clock, introduced with Python a standard library issued together.

text processing services

string?--- common string operations

re?--- regular expression operations

difflib?--- auxiliary tools for calculating differences

textwrap?--- text wrapping and filling

unicodedata?---Unicode database

stringprep?--- internet string preparation

readline?---GNUreadline interface

rlcompleter?---GNUreadline complete function

binary data service

struct?--- deciphering a byte string as packaged binary data

codecs?--- codec registration and related base classes

data type

zoneinfo?---IANA time zone support

calendar?--- calendar related functions

collections?--- container data type

?---abstract base class for containers

heapq?--- heap queue algorithm

bisect?--- array binary search algorithm

array?--- efficient numerical arrays

weakref?--- weak quotes

types?--- dynamic type creation and built-in type names

copy?--- shallow (shallow)and deep (deep)copy operation

pprint?--- data beautification output

reprlib?--- another? repr()?accomplish

enum?--- support for enumeration

graphlib?--- functions for operating structures similar to diagrams

number and mathematics modules

numbers?--- abstract base class of numbers

math?--- mathematical functions

cmath?--- mathematical functions about complex numbers

decimal?--- decimal fixed point and floating point operations

fractions?--- fraction

random?--- generate pseudo-random numbers

statistics?--- mathematical statistical functions

functional programming module

itertools?--- functions that create iterators for efficient loops

functools?--- operations on advanced functions and callable objects

operator?--- standard operator alternative functions

file and directory access

pathlib?--- object-oriented file system path

?---common path operations

fileinput?--- iterate over rows from multiple input streams

stat?--- analysis? stat()?result

filecmp?--- comparison of files and directories

tempfile?--- generate temporary files and directories

glob?---Unix style pathname pattern extension

fnmatch?---Unix file name pattern matching

linecache?--- randomly read and write text lines

shutil?--- advanced file operation

data persistence

pickle?---Python object serialization

copyreg?--- register to cooperate? pickle? functions used by modules

shelve?---Python object persistence

marshal?--- internal Python object serialization

dbm?---Unix database interface

sqlite3?---SQLite database DB-API2.0 interface module

data compression and archive

zlib?--- and? gzip? compatible compression

gzip?--- right? gzip? format support

bz2?--- right? bzip2? support for compression algorithms

lzma?--- use LZMA algorithm compression

zipfile?--- use ZIP archive

tarfile?--- read and write tar archive files

file format

csv?---CSV read and write files

configparser?--- configuration file parser

tomllib?---ParseTOMLfiles

netrc?---netrc file processing

plistlib?--- generation and parsing Apple?? document

encryption services

hashlib?--- secure hash and message digest

hmac?--- key-based message verification

secrets?--- generate a secure random number of administrative passwords

general operating system services

os?--- multiple operating system interfaces

io?--- core tools for handling streams

time?--- access and conversion of time

argparse?--- command line options, parameters, and subcommand parser

getopt?---C style command line options parser

logging?---Python logging tool

?---logging configuration

?---log handler

getpass?--- portable password input tool

curses?--- processing of terminal character unit display

?---for curses the text input control for the program

?---for ASCII character tools

?---curses panel stack extension

platform?---getidentification data of the underlying platform

errno?--- standard errno system symbols

ctypes?---Python external function library

concurrent execution

threading?--- thread-based parallelism

multiprocessing?--- process-based parallelism

_memory?---Sharedmemoryfordirectaccessacrossprocesses

concurrent? bag

?---start a parallel task

subprocess?--- subprocess management

sched?--- event scheduler

queue?--- a synchronous queue class

contextvars?--- context variables

_thread?--- underlying multi-threading API

communication between network and process

asyncio?--- asynchronous I/O

socket?--- underlying network interface

ssl?---socket object's TLS/SSL packaging

select?--- wait I/O finish

selectors?--- advanced I/O multiplexing library

signal?--- set up an asynchronous event handler

mmap?--- memory mapped file support

internet data processing

email?--- email with MIME processing package

json?---JSON encoding and decoder

mailbox?--- operate emails in multiple formats

mimetypes?--- map file name to MIME type

base64?---Base16,Base32,Base64,Base85 data encoding

binascii?--- binary and ASCII code transfer

quopri?--- encoding and decoding MIME transcoded printable data

structured tag processing tools

html?--- hypertext markup language support

?---simple HTML and XHTML parser

?---HTML definition of general entities

XML processing module

?---ElementTreeXMLAPI

?---document object model API

?---minimized DOM accomplish

?---support build part DOM tree

?---support SAX2 parser

?---SAX base class for handling handles

?---SAX toolset

?---for XML interface of parser

?---use Expat fast XML analysis

internet protocol and support

webbrowser?--- convenient Web browser control tools

wsgiref?---WSGI tools and reference implementations

urllib?---URL processing module

?---used to open URL extensible library

?---urllib used Response kind

?for parsing URL

?the exception class raised

?psychology analysis program

http?---HTTP module

?---HTTP protocol client

ftplib?---FTP protocol client

poplib?---POP3 protocol client

imaplib?---IMAP4 protocol client

smtplib?---SMTP protocol client

uuid?---?RFC4122? defined UUID object

socketserver?--- framework for web servers

?---HTTP server

?---HTTP status management

?——HTTP client's Cookie deal with

xmlrpc?---XMLRPC server and client modules

?---XML-RPC client access

?---basic XML-RPC server

ipaddress?---IPv4/IPv6 operation library

multimedia services

wave?--- read and write WAV format file

colorsys?--- conversion between color systems

internationalization

gettext?--- multilingual international services

locale?--- international services

program framework

turtle?--- turtle drawing

cmd?--- supports line-oriented command interpreters

shlex?—— simple lexical analysis

Tk graphical user interface (GUI)

tkinter?——Tcl/Tk of Python interface

?---color selection dialog

?---Tkinter font encapsulation

Tkinter dialog box

?---Tkinter message prompt

?---scroll text control

?---drag and drop operation support

?---Tk style controls

cmd all commands in `````

winver examine Windows version opens Windows management architecture (wmi) wupdmgr Windows update the program wscript Windows script host settings write writing board winmsd system information wiaacmgr scanner and camera wizard winchat xp system configuration utility for lan chat display memory usage mplayer2 simple widnows media player mspaint drawing board mstsc remote desktop connection mplayer2 media player magnify magnifying glass utility mmc open the console mobsync synchronize commands dxdiag examine directx information drwtsn32 system doctor device manager disk defragmenter disk management utility dcomcnfg open system component services ddeshare open dde share settings dvdplay dvd player net stop messenger stop messenger service net start messenger start messenger service notepad open notepad nslookup network management tools wizard ntbackup system backup and restore narrator screen "narrator" mobile storage manager mobile storage administrator operation request netstat -an （tc） command check interface syncapp create a briefcase sysedit system configuration editor sigverif file signature verification program sndrec32 recorder shrpubw create a shared folder local security policy syskey system encryption, once encrypted, it cannot be unblocked, protection Windows xp the system's dual password local service settings sndvol32 volume control program system file checker sfc /scannow windows file protection tsshutdn 60 second countdown shutdown command tourstart xp introduction (roaming that appears after installation is completed xp program) taskmgr task manager eventvwr event viewer eudcedit word making program explorer open explorer packager object packaging program computer performance monitoring program progman program manager registry group policy result set regedt32 registry editor rononce -p 15 shut down in seconds regsvr32 /u * stop dll file running regsvr32 /u cancel zip support cmd command prompt chkdsk disk check certificate management utility calc start the calculator charmap start character mapping table cliconfg sql server client network utility clipbrd clipboard viewer conf start up netmeeting computer management cleanmgr garbage sorting indexing service program osk open the on-screen keyboard odbcad32 odbc data source manager oobe/msoobe /a examine xp whether to activate native users and groups logoff logout command iexpress trojan bundling tool, system comes with nslookup ip address detector shared folder manager utilman the following is the assistant tool manager group policy Windows commonly used running commands of the operating system. executing these commands can open the relevant utilities corresponding to the system. if you can basically use it, you can check and repair the most basic system failures. except for logging out and closing the system commands, you might as well give it a try!! running \enter CMD\enter the corresponding related utility: . open C:＼Documents and Settings＼XXX(currently logged in Windows XP username ) .. open Windows XP under the drive letter Documents and Settings folder... open the my computer option. the assistant tool wizard directly displays the installation tool allows the program to open the data display in the formulation directory and change the computer's computer's IP the corresponding list of hardware physical addresses schedules to run tasks ATM call manager statistics display and change file and folder attribute detection repair file system (XP not available ) automatically convert the system during startup (XP not available ) format the process during startup (XP not available ) use long filename format (XP not available ) show and change the computer's IP corresponding to hardware physical address calculator notification starts successful display and editing ACL CD player-related query with terminal server (XP not available ) character map starts or disables session logging (XP not available ) change port (terminal service) (XP not available ) change the user (terminal service) (XP not available ) disk detection program NTFS disk detection program composition Ci document service is in NTFS open index content transformation on the encrypted file or directory displayed or changed Cookie disk cleaning SQL customer network tools scrapbook viewer run Clipboard service creates a system file list displaying the cluster of domains (XP not available ) enter 2000 \XP DOS automatically download connection management connection manager connection manager monitor connection manager profile installer cluster comparison of the contents of two files and file sets conf start up netmeeting chat tools control userpasswords2 XP password management. computer management conversion display mode (XP not available ) start, run, input CMD\enter net config workstation computer name \complete computer name \username workstation is active (i.e. network description) \software version (i.e. software version number) \workstation domain workstation domain DNS name login domain \COM open time timeout (seconds) \COM send quantity (bytes) \COM send timeout (msec) CMD\enter net config workstation change the configurable workstation service settings. CMD\enter net config server can display the computer name of the server that cannot be configured \server comments \server version (i.e. software version number) the server is active (i.e. network description) \the server is hidden (i.e. /hidden settings) maximum number of logged-in users (that is, the maximum number of users who use the server shared resources) maximum number of files opened per session (that is, the maximum number of server files that users can open in one session) idle session time (minimum value) disk check. Chkdsk /r 2000 command in the console Chkdsk /r command to check and repair system files cleanmgr garbage sorting Clipbrd clipboard viewer opens the startup menu to display or change NTFS compressed status of files on partition IME console control panel NTFS convert file system to NTFS convert IIS log file format to NCSA format conversion display mode is better than this host version of the client server Runtime process (XP not available ) format converter (XP not available ) dcpromo active directory installation (XP not available ) drwtsn32 system doctor disk manager (and PowerQuest PartitionMagic 8.0) dvdplay DVD player device manager (check the computer hardware, driver ) dxdiag examine DirectX information DCOM configuration properties (console root directory ) installation wizard (XP not available ) DDE shared check DEBUG FAT partition disk defragmenter NTFS partition disk defragmenter (XP not available ) dfs_cmd_ configuration DFS tree (XP not available ) distributed file system initialization (XP not available ) distributed file system server (XP not available ) production CAB file disk performance counter part of disk management service (XP not available ) create macros on the command line DOS extended direct run help (XP not available ) watson error detection watson display and configuration management DVD play Direct-X text editing of the diagnostic tool command line MS database tool word maker event viewer conversion EXE file to binary decompression solution CAB tools shared folders quick access hard disk files in memory fax cover edit show fax queue send fax wizard starts fax service comparison of different findings text lines in files findings lines in files one user and shows statistical results fixes MAPI files allow or disable temporary file directories (XP not available ) show font mandatory files in font files DOS run in mode FTP download group policy graphic interface driver transformer administrator group display machine Hostname Internat input method icon iexpress trojan bundling tool, the system comes with a custom folder wizard iexpress restart the installation package IIS serve (not installed IIS, not available ) keyboard language indicator (XP not available ) check IP configuration IP security monitor IPX install or delete the routing and source routing control program wireless connection Service Control Manager services in Java4 debugger conversion Jet Engine database (XP not available ) compression Jet database (XP not available ) Java command line loader change drive's volume license wizard (XP not available ) LDIF directory exchange command line management (XP not available ) terminal service license agreement management (XP not available ) show connection status (XP not available ) Windows 2000 license agreement management (XP not available ) start the license server (XP not available ) RPC Locator remote positioning call performance count logout of the current user display remote LPD the status of the print queue, the display is sent to the Unix the server's printing task is used for Unix the customer printer sends the printing task to the connected printing device NT printer server. run LSAand Server of DLL specify the default Server new DNS domain (XP not available ) local account management mmc console mplayer2 player management MACFILES (XP not available ) magnifying glass production CAB file display memory status migration password console remote desktop sharing sync directory manager creates, deletes, or lists mount points for volumes. Media Player media player notification application information queue backup and recovery tool MSMQ Migration Utility information queue migration tool SNMP multicast routing installation MSCD dynamic transaction console send messages to local or remote clients HTML application host starts Windows installer open the drawing board task schedule program task schedule installation system configuration utility (configure startup options, service items ) show memory usage mspaint drawing board Net Stop Messenger stop messenger service Net Start Messenger restoring messenger services nslookup network management tools Nslookup IP address detector ntbackup system backup and restore use NBT（TCP/IP on NetBIOS） show protocol statistics and current TCP/IP connect. NDDE API server-side for configuration and monitoring Windows 2000 command line script interface (XP not available ) show protocol statistics and current TCP/IP network connection. load information for a specific country. Windows 2000 and MS-DOS the subsystem does not use the command to accept the command just for the purpose of MS-DOS file compatible. open notepad the diagnostic tool shows the domain name system (DNS) name server information. backup and troubleshooting tools NT file copy service (XP not available ) simulation 16-bit Windows environment NetWare steering device running Netware 32-bit script ODBC data source management (driver management ) command line configuration ODBC driver and data source object wrappers include Pingand Tracert program check Pentium floating point error system performance monitor validates connection with remote computers for compatibility Unix print text files or display the contents of the print queue. program manager Posix subsystem application displays the information of processes locally or remotely on the network (terminal service required) query processes and conversations (XP not available ) display user login information (terminal service required) display terminal service information rononce -p 15 shut down in seconds rasAdmin remote access service. registry editor starts remote access service (XP not available ) create a RAS connect to broadband, dial-up connection to run RAS connect (XP not available ) computer and running remote shell port monitoring program rshd copy files between the terminal and copy and paste files locally to recover readable information from bad or defective disks. run the redirection service. the 32-bit registration service uses script modification registration license registration wizard to replace the files in the target directory with the file with the same name in the source directory. rexec before executing the specified command, verify the user name on the remote computer. only installed TCP/IP this command can only be used after the protocol. run the remote installation wizard service (XP not available ) control the network routing table running RSH run commands on the service's remote computer remote storage notification echoes that allow users to run specified tools and programs with other permissions to start 32-bit DLL program resets the session subsystem hardware and software to the initial value Sndvol32 volume control program or CMD\ enter system file checker network connection service syskey system encryption, (once encrypted, it cannot be unblocked. protect windows xp double password of the system wupdmgr WIDNOWS UPDATE) SCANREG/RESTORE command recovery recent registry automation security configuration management control all service settings high contrast settings MS-DOS the subsystem reports to the program MS-DOS version number system file check monitoring another mid-range server session establishment and sharing folder file signature verification performance logs and alerts (XP not available ) simple network management protocol for displaying sound control information by recorder (XP not available ) SNMP tool (XP not available ) server manager (XP not available ) associate paths with drive letters system configuration editor NT account database encryption tool > Windows the installer runs at low privileges systray taskmgr task manager tasklist /svc(CMD)understand each SVCHOST how many system services does the process provide (2000\98 not available ) tlist -S(CMD) understand each SVCHOST how many system services does the process provide ( task manager (XP not available ) task manager telephone service customer installation TCP the service terminal service transfers files to running TFTP the service's remote computer or from running TFTP services remote computer transfer file desktop theme (XP not available ) Administrator Telnet service management displays the current Telnet session begins Telnet the service diagnostic utility will include different survival times (TTL) value Internet control message protocol (ICMP) echo packets are sent to the target to determine the route to reach the target Administrator terminal service manager (XP not available ) paste user session to terminal conversation disconnect terminal service user kill terminal service using terminal service to obtain query results close part of system performance monitor upgrade Jet database (XP not available ) UPS service UPS serve Windows core service open my document domain user manager specifies that 2000 will automatically open when starting. calling the machine IPX/SPX VDM time server decompression Windows file opening Windows chat tool run help system view system information display Windows version Windows management wizard (XP not available ) Java command line call Java open the writing board script tool Windows update run Windows update upgrade wizard winver examine Windows version Win98 system tools start, run, input Msconfig system configuration utility configures startup options, including,,, and startup items in the registry and program menus. and set whether the fault starts. start, run, input Regedit registry modification tool registration editor. if you are not sure, don’t modify the registry at will! start, run, input Regsvr32 dll registration tool cannot be found when prompted dll this is used to register the dynamic connection library when you are filed. start, run, input Regwiz the registration wizard is used for registration. verify the system files and restore the system files. if a similar appears at startup *file error, use this to restore the file vxd document. start, run, input Scandskw disk scanner, used to scan and repair disks. if there is an error in the disk or file, it can be used for a preliminary repair. start, run, input DxDiag DirectX diagnostic tools can be used for detection DirectX is it running normally? start, run, input NETSCAPE ESC： clear the current command line; F7： display the command history, give all the commands that have been entered in the form of a graphical list window, and use the up and down arrow keys to select to execute the command again. F8： search for the history of the command, looping out all commands that have been entered until the enter key is pressed; F9： select the command by number, and ask you to enter the corresponding number of the command in a graphical dialog box. (starting from 0 )，and display the command on the screen; Ctrl+H： delete a character on the left side of the cursor; Ctrl+C Ctrl+Break， forced abort the execution of the command; Ctrl+M： indicates the enter confirmation key; Alt+F7： clear all command history that has been entered; Alt+PrintScreen： screenshots the contents in the current command window on the screen. the virus has destroyed the system file. please use antivirus software to check the virus and then use it Windows 2000 in the "command console" provided Chkdsk /r just check and repair the system files DOS command dictionary.. collection net use \ip\ipc$ /user: establish IPC empty link net use \ip\ipc$ password /user: username creation IPC non-empty link net use h: \ip\c$ password /user: map the other party after logging in directly with the username C： go to local H: net use h: \ip\c$ map the other party after logging in C： go to local H: net use \ip\ipc$ /del delete IPC link net use h: /del delete the map to the local one H: mapping of net user username and password /add create a user net user guest /active:yes activation guest user net user check out which users are net user account name view the properties of the account net localgroup ***istrators username /add add "user" to the administrator to make it have administrator privileges, note: ***istrator add after s use plural numbers net start check which services are enabled net start service name to enable service; (like: net start telnet， net start schedule) net stop service name stops a service net time \target ip check the other person's time net time \target ip /set set local computer time and "target" IP” time synchronization of the host, plus parameters /yes cancel confirmation information net view check which sharing is enabled in the local lan net view \ip check which sharing is enabled on the other party's lan net config display system network settings net logoff disconnected sharing net pause service name suspends a service net send ip send text messages to the other party net ver types and information of network connections being used in the lan net share view locally enabled sharing net share ipc$ open ipc net share ipc$ /del delete ipc net share c$ /del delete C： shared net user guest use guest after logging in, change the password to net password password change system login password netstat -a check which ports are opened, commonly used netstat -an netstat -n check the network connection status of the port, commonly used netstat -an netstat -v view ongoing work netstat -p protocol name example: netstat -p tcq/ip check the usage of a certain protocol (see tcp/ip protocol usage) netstat -s view all protocol usage in use nbtstat -A ip if one of the other party's ports 136 to 139 is opened, you can view the other party's recently logged in username (the username before 03) - note: parameters - A to capitalize tracert - parameter ip(or computer name ) tracking route (packet), parameter: "- w number” is used to set the timeout interval. ping ip(or domain name ) send data with a default size of 32 bytes to the other host, parameter: "- l[spaces ]packet size”; n number of data sent"; t” refers to always ping。 ping -t -l ip death ping(send greater than 64 K the file and keep ping it becomes death ping) ipconfig (winipcfg) for windows NT and XP(windows 95 98)view local ip address, ipconfig available parameters" /all” show all configuration information tlist -t show process in a tree row list (it is an additional tool for the system, which is not installed by default, in the installation directory. Support/tools in the folder ) kill -F process name plus- F forced end of a process after parameters (it is an additional tool for the system, which is not installed by default, in the installation directory. Support/tools in the folder ) del -F file name plus- F after parameters, you can delete read-only files. /AR、/AH、/AS、/AA it means deleting read-only, hidden, system, and archive files, respectively. /A-R、/A-H、/A-S、/A-A indicates deletion of files other than read-only, hidden, system, and archive. for example" DEL/AR *.*”it means deletion of all read-only files in the current directory, " DEL/A-S *.*”indicates deletion of all files except system files in the current directory move drive letter \path \the file name to be moved holds the path to the moving file \after moving the file name, use parameters /y the prompt to cancel the mobile directory will be overwritten directly fc > compare the two files and output the differences to the files. > and > > it's a redirect command at id activate a registered scheduled task at /delete stop all scheduled tasks and use parameters /yes stop it without confirmation at id number /delete stop a registered scheduled task at view all scheduled tasks at \ip time program name (or a command ) /r run a program on the other party at a certain time and restart the computer finger username @host check out which users have logged in recently telnet ip port remote and login server, default port is 23 open ip connect to IP（ generic telnet command after login) telnet type directly on this machine telnet will enter the unit telnet copy path \file name 1 path \file name 2 /y copy file 1 to the specified directory as file 2, using parameters /y cancel confirm that you want to rewrite an existing directory file copy c:\ \ip\***$ copy local c:\to the other party ***down cppy /b+/a hidden content into it to generate a new file. note that the file header must be empty in three rows, parameters: /b refers to a binary file, /a refer to ASCLL format file copy \ip\***$\ c:\ or: copy\ip\***$\*.* copy the other party ***files (all files) to local C： xcopy the file or directory tree destination address to be copied \copy files and directory trees with parameters /Y there will be no prompt to overwrite the same file tftp -i own IP(when using a meat machine as a springboard, use a meat machine IP) get c:\ after logging in, IP” download to the target host c:\ parameter:- i refers to transmission in binary mode, such as transmission exe use when using the file, if not added- i then ASCII mode (transfer text file mode) for transfer tftp -i other side IP put c:\ after logging in, upload locally c:\to the host ftp ip the port is used to upload files to the server or perform file operations, and the default port is 21. bin refers to the transmission in binary mode (executable file); default is ASCII format delivery (when text file ) route print show IP routing will mainly display the network address Network addres， subnet mask Netmask， gateway address Gateway addres， interface address Interface arp view and process ARP cache, ARP it means name analysis, responsible for making one IP parsed into a physical MAC address. arp -a all information will be displayed start program name or command /max or /min open a new window and maximize (minimize) run a program or command mem check cpu usage attrib file name (directory name ) view the properties of a file (directory) attrib file name - A -R -S -H or +A +R +S +H remove (add to )archive, read-only, system, hidden attributes of a file; ＋add as a property dir view file, parameters: /Q show which user of the file and directory belongs to the system? /T:C show file creation time, /T:A shows the last time the file was accessed. /T:W last time it was modified date /t 、 time /t use this parameter to DATE/T”、“TIME/T” only the current date and time will be displayed without having to enter a new date and time set specify the environment variable name =set environment variables to be assigned to the character set show all current environment variables set p(or other words? /ca>

datagrip2017 how to chinese datagrip2017 the most comprehensive guide to the chinese version of english version

JetBrains DataGrip it is a software company from czech republic JetBrains released a brand new heavyweight product, known as the database and SQL swiss army knife in the field. DataGrip supports almost all mainstream relational database products, such as DB2、Derby、H2、MySQL、Oracle、PostgreSQL、SQL Server、Sqllite and Sybase etc. and JetBrains DataGrip it has a very simple and easy-to-use interface, so developers will hardly encounter any difficulties when they get started. if needed DataGripcrackedfriends of the version are welcome to download it!

datagrip2017 english version chinese method:

1、download and unzip it, and install the original program first.

2、after successfully installing the software, copy all the activation codes into the software activation interface to activate it for free.

3、next, carry out the chinese operation and C:Program Files (x86)JetBrainsDataGrip 2017lib in the directory resources_copy the file and change it to resources_。

4、double-click to open resources_(note that it is to open it instead of decompress it )，the chinese package to be downloaded zh_CN drag all files in the directory to the one you just opened resources_in the file messages and save it in the directory.

5、will resources_copy the file back C:Program Files (x86)JetBrainsDataGrip 2017lib the directory can be successfully chinese.

i hope everyone can get what they need here.

a must-have mobile phone for college students app artifact? please recommend

1. baicizhan is a must-have software for learning english, with many functions. supports word lock screen (can memorize words when unlocked) 2. the super swiss army knife integrates many gadgets, which is a must-have for installation 3. Adobe Photoshop Touch right now PS Touch。 the most professional photo editing software on mobile phone 4. SQLite Editor database editor on your phone 5. terminal emulator command line on your phone 6. tip launcher supports hidden apps. the key is that this name will not give the feeling of no silver here 7. XPOSED the frame makes mobile phones as many windows as computers 8. bochs simulator for running computers in simulator Windows system, run computer software and games in the system. 9. Shazam listening and music recognition software. in addition, kugou music also supports listening to music and knowing music 10. when it rains, you can see which cloud is raining. 11. AutoCAD 360 on your phone CAD12. panoramic camera can take panoramic photos 13. when the virtual key assistant is not easy to use, it can keep the phone using it 14. MyPantone color disc. you may use 15 when editing pictures. MySQL Manager connection management on your phone MySQL database 16. ScanbotPDF scanner 17. kingsoft shared elf does not require a data cable, it only needs to manage the mobile phone through the network 18. sunflower remote control can control each other with other smart devices. similar software Teamviewer19. free reading and listening to books can really make txt read out app20. AIDE development of android software and game on mobile phones 21. C4Droid run on your phone C code 22. touchbao input method other input methods are weak. let me explain slowly: support pinyin, wubi, stroke, english (support sliding input), voice (support mandarin, cantonese, english, sichuan dialect, henan dialect), handwriting, pronunciation, cangjie, chinese quick-forming and other input methods support rare characters, support simplified and traditional chinese conversion (can be entered simplified and then converted to traditional chinese) support intelligent error correction (error key correction) and clipboard function. it can lock the content of the clipboard (you can copy commonly used sentences and then lock it in the clipboard of the input method to quickly enter it when needed in the future). there are also other input methods, such as skinning, updating the vocabulary, adjusting the keyboard size, and switching keyboard layout 23. LittlePhoto volume keys take pictures 24. RE manager combination root permissions, you can make any modifications to the system

mysql how to use it mysqlbinlog tools generate log files txt file analysis

MySQL of Binlog recording MySQL all database changes to understand Binlog the structure can help us analyze Binlog， even right Binlog make some modifications, or "tampering", for example, implementing similar Oracle of flashback the function of recovering the wrongly deleted records, update restore the records and wait. this article will take you through the implementation of these magical features and you will find it much simpler than you think. this article refers to Binlog yes ROW mode Binlog， this is also MySQL 8 the default mode in STATEMENT because there are many restrictions in use, the mode is now used less and less. Binlog by event ( event） composition, please note that it is an event ( event） not a transaction ( transaction）， a transaction can contain multiple events. event descriptions the modifications to the database. now we've got it Binlog we can try to modify the structure of Binlog data in. for example, the previous example Binlog after deleting a record, we can try to restore this record. Binlog there is a delete line inside ( DELETE_ROWS_EVENT） the event is that this event deletes the record, this event and the line of writing ( WRITE_ROWS_EVENT） the data structure of the event is exactly the same, except that the type of deleted line event is 32, and the type of write line event is 30. we will put the corresponding Binlog change the position 32 to 30 and insert the deleted records back. from the front show binlog events” you can see this inside DELETE_ROWS_EVENT it starts at position 378, and the location here is Binlog the actual location of the file (in bytes). from the event ( event） you can see in the structure of type_code yes event let's write the 5th byte Python mini program no. 383 (378 +5=383）change the byte to 30. of course, you can also use binary editing tools to modify it. find out Binlog the big business in ROW mode Binlog every change records a log, so a simple SQL， exist Binlog a giant transaction may occur in the where of update or delete statement, modify all records in the entire table, and each record is Binlog recorded once inside, and the result is a huge transaction record. such big things are often the source of trouble. one of my clients once complained to me, Binlog go forward, there was no movement after two days, i put that one Binlog after analyzing, i found that a transaction generated 1.4. G 660,000 records have been modified! here is a simple find Binlog medicial international Python we know how to use the mini program mysqlbinlog analytical Binlog， every transaction is BEGIN start with COMMIT finish. let's find out BENGIN the previous "# at” location, check COMMIT the following "# at” position, subtracting these two positions can calculate the size of this transaction. the following is Python example of program. cut Binlog the big business in the big business, MySQL it will be broken down into multiple events (note that one is a transaction TRANSACTION， another is an event EVENT）， the size of the event is parameter binlog-row-event-max-size decide, this parameter is 8 by default K。 therefore we can cut several events into a single slightly smaller transaction ROW in mode, even if we only update one of the fields of a record, the value before and after each field changes will be recorded. this behavior is binlog_row_image parameter controlled, this parameter has 3 values, the default is FULL， that is, all modifications to the column are recorded, even if the field has not changed. this way we can achieve something like Oracle of flashback i personally estimate the function MySQL future versions may be based on Binlog launch such a feature. get it Binlog the structure, plus Python we can also implement many functions for this swiss army knife, such as we can count which table has the most modified? we can also Binlog cut into sections and then reorganize, which can be flexibly performed MySQL database modification and migration.

---

---

related tags: swiss army knife that steers the database world、 MySQL、 management tools、

previous article:10a must-have MySQL management tools, must unlock database performance

next article:master BackgroundWorker best practices to avoid common