PHP notes, Han Shunping php notes. PHP notes, Han Shunping php notes Mysql ----------------------------------------------------------------------------- Mysql changes the default password updatemysql. usersetPasswordPASSWORD
Mysql
-----------------------------------------------------------------------------
Change the default password for Mysql
Update mysql. user set Password = PASSWORD ('000000') WHERE User = 'root'
FLUSH PRIVILEGES
Remove the MYSQL paradigm, reverse paradigm, and hybrid paradigm
Index creation
Cmd command line
Full-text index
------------------------------
Alter tabletable_reg_c addfulltext (catalog)
Repair table tablename quick
Select * from table_reg_c where match ('catalog ') against ('2 in boolean mode ')
Select * fromtable_reg_c wherematch ('catalog ') against (2)
UPDATE 'Infinite _ Class'. 'Table _ reg_c 'SET 'catalog' = '0, comment, 20000, 30000 'where' table _ reg_c '. 'id' = 3;
ExplainSELECT * FROM 'Table _ reg_c 'WHEREmatch (catatch) against ('123 ')
Explain SELECT * FROM 'Table _ reg_c 'WHERE match (catalog) against ('20140901 ')
# Apache
------------------------------------------------------------------------------
Apache \ bin \ ApacheMonitor.exe
# Mysqld
----------------------------------------------------
Install mysqld install
Net start mysql startup service
Zend code style
----------------------------------------------------------------
Formatter {}
Ctrl + shift + f Select All. This will automatically typeset.
Upgrade Mysql ----------------------------------------------------------------------------- change Mysql default Password update mysql. user set PASSWORD = Password ('12...