World Financial Market

Tips and the rules in Chinese: https://www.cnblogs.com/zdz8207/p/7643658.html

If you want to get this domain, please contact me

The autocommit is ON when installed MySQL. Check the parameter： show variables like 'autocommit'; Set the parameter: OFF： SET autocommit=0; set autocommit = 'OFF'; ON： SET autocommit=0; set autocommit = 'ON';

Chinese page: http://1035054540-qq-com.iteye.com/blog/1499430

Version: Ubuntu: 14 MySQL: 5.5 1.Change the MYSQL Parameter: sudo vi /etc/mysql/my.cnf 32 # 33 # * Basic Settings 34 # 35 user = mysql 36 pid-file = /var/run/mysqld/mysqld.pid 37 socket = /var/run/mysqld/mysqld.sock 38 port = 3306 39 basedir = /usr 40 datadir = /var/lib/mysql 41 tmpdir = /tmp 42 lc-messages-dir = /usr/share/mysql 43 skip-external-locking Add "skip-grant-tables" 32 # 33 # * Basic Settings 34 # 35 user = mysql 36 pid-file = /var/run/mysqld/mysqld.pid 37 socket = /var/run/mysqld/mysqld.sock 38 port = 3306 39 basedir = /usr 40 datadir = /var/lib/mysql 41 tmpdir = /tmp 42 lc-messages-dir = /usr/share/mysql 43 skip-external-locking 44 skip-grant-tables 2.Restart mysql: sudo service mysql restart 3.Change mysql Password: use mysql describe user; select host, user, password from user; upd...

1.Mysql Login Command mysql -h127.0.0.1 -uroot -ppassword 2.Mysql Modify Password mysqladmin -uroot -poldpassword password newpassword

Use the commands: sudo apt-get update sudo apt-get dist-upgrade It will ignore the problem of “Not enough free disk space when upgrading” Maybe the disk volume calculation methods are different.(Because update methods are different?)