MySQL Basics Tips

Making MySQL software into a system service

3, the MYSQLD software into a system service note: Before making mysqld turn off C:\Windows\system32>Tasklist|findstr mysqld Mysqld.exe8372Console2    454,916K C:\Windows\system32>Taskkill/F/Pid8372success: The PID has been terminated to8372the process. Production: Mysqld--InstallView: Windows+r input Services.msc

making MySQL system services

To start the server and client:

Startup: The startup mode of the system service is not created:1, start the service-side mysqld2, start the client MySQL-Uroot-P-h127.0.0.1 -P3306If you are logged on to the MYSQLD server, you can: MySQL-Uroot-p after making the system services, you can click on the mouse to start or close mysql:windows+r input services.msc find MySQL, start or close

Crack password

Crack Administrator Password1, close the mysqld server first2to start the MYSQLD server on the command line in a way that bypasses the authorization table mysqld--Skip-grant-tables    3, the client log in to the root user directly without a password, modify the password MySQL-Uroot-p MySQL> UpdateMysql.User SetPassword=Password ("123")where User="Root" andHost="localhost"; Query OK,0Rows Affected (0.00sec) Rows matched:1Changed:0Warnings:0MySQL>FlushPrivileges; Query OK,0Rows Affected (0.00sec)4, kill the Mysqld service with Taskkill in the command line, and then start the mysqld normally Taskkill/F/Pid131312

cracked passwords on Windows

Fixed garbled, unified character encoding

Unified character Encoding1, create a new My.ini file in the MySQL installation directory2, modify My.ini[mysqld]        character-Set-Server=UTF8 Collation-Server=Utf8_general_ci[Client]        default-character-Set=UTF8[MySQL]        default-character-Set=UTF83, restart Mysqld4, client login, enter \s View results

Unified character Encoding

Basic SQL statements

1, folder (library) IncreaseCreate Databasedb1 CharSet UTF8; ChangeAlter DatabaseDB1 CharSet GBK;        Check the library name of all libraries show databases; View information for a library individually showCreate DatabaseDB1; DeleteDrop Databasedb1;2, file (table) switch folders first: UseDB1; Select Database(); #查看当前所在的文件夹 IncreaseCreate TableT1 (IDint, nameChar); ChangeAlter TableT1 Modify NameChar( -);        Check all the table names under the current library show tables; View details of the T1 table showCreate TableT1; View Table StructuredescT1; DeleteDrop TableT1;3, the file's line of contents (records) increasesInsert  intoDb1.t1Values        (1,'Egon'),        (2,'Alex'),        (3,'LXX'); ChangeUpdateDb1.t1SetName='SB' whereId> 1; CheckSelectId,name fromdb1.t1; DeleteDelete  fromDb1.t1whereName="SB";

Basic SQL Statements

MySQL Basics Tips