1.mysql\u81ea\u5e26\u7684\u5ba2\u6237\u7aef\u7a0b\u5e8f\uff08\/service\/mysql\/bin\uff09\n mysql\n mysqladmin\n mysqldump\n\n2.mysqld\u4e00\u4e2a\u4e8c\u8fdb\u5236\u7a0b\u5e8f\uff0c\u540e\u53f0\u7684\u5b88\u62a4\u8fdb\u7a0b\n \u5355\u8fdb\u7a0b\n \u591a\u7ebf\u7a0b<\/code><\/pre>\n1.1 \u542f\u52a8\u6570\u636e\u5e93<\/h3>\n1\u3001\/etc\/init.d\/mysqld start ---> mysql.server ---> mysqld_safe ---> mysqld\n2\u3001systemctl start mysql ---> mysqld_safe ---> mysqld\n3\u3001mysqld_safe --defaults-file=\/etc\/my.cnf ---> mysqld_safe ---> mysqld<\/code><\/pre>\n1.2 \u505c\u6b62\u6570\u636e\u5e93<\/h3>\n\/etc\/init.d\/mysqld stop\nsystemctl stop mysqld\n\n# \u5982\u679c\u662f\u81ea\u5df1\u7528\u547d\u4ee4\u5982mysqld_safe\u542f\u52a8\u7684mysql\uff0c\u53ef\u4ee5\u7528mysqladmin\u6765\u5173\u95ed\nmysqladmin -uroot -p123 shutdown \n\n# \u65e0\u8bba\u5982\u4f55\u90fd\u4e0d\u5efa\u8bae\u4f7f\u7528\nkill -9 pid\nkillall mysqld\npkill mysqld\n\n# \u76f4\u63a5kill\u6570\u636e\u5e93\u53ef\u80fd\u4f1a\u51fa\u73b0\u95ee\u9898\uff1a\n1.\u5982\u679c\u5728\u4e1a\u52a1\u7e41\u5fd9\u7684\u60c5\u51b5\u4e0b\uff0c\u6570\u636e\u5e93\u4e0d\u4f1a\u91ca\u653epid\u548csock\u6587\u4ef6\n2.\u53f7\u79f0\u53ef\u4ee5\u8fbe\u5230\u548cOracle\u4e00\u6837\u7684\u5b89\u5168\u6027\uff0c\u4f46\u662f\u5e76\u4e0d\u80fd100%\u8fbe\u5230\n3.\u5728\u4e1a\u52a1\u7e41\u5fd9\u7684\u60c5\u51b5\u4e0b\uff0c\u4e22\u6570\u636e\uff08\u8865\u6551\u63aa\u65bd\uff0c\u9ad8\u53ef\u7528\uff09<\/code><\/pre>\n\u4e8c MySQL\u8bbe\u7f6e\u5bc6\u7801<\/h2>\n
\u521d\u59cb\u72b6\u6001\u4e0b\uff0c\u7ba1\u7406\u5458root\uff0c\u5bc6\u7801\u4e3a\u7a7a\uff0c\u9ed8\u8ba4\u53ea\u5141\u8bb8\u4ece\u672c\u673a\u767b\u5f55localhost<\/p>\n
# \u8bbe\u7f6e\u521d\u59cb\u5bc6\u7801 \u7531\u4e8e\u539f\u5bc6\u7801\u4e3a\u7a7a\uff0c\u56e0\u6b64-p\u53ef\u4ee5\u4e0d\u7528\n[root@egon ~]# mysqladmin -uroot password "123" \n\n# \u4fee\u6539mysql\u5bc6\u7801,\u56e0\u4e3a\u5df2\u7ecf\u6709\u5bc6\u7801\u4e86\uff0c\u6240\u4ee5\u5fc5\u987b\u8f93\u5165\u539f\u5bc6\u7801\u624d\u80fd\u8bbe\u7f6e\u65b0\u5bc6\u7801\n[root@egon ~]# mysqladmin -uroot -p"123" password "456" <\/code><\/pre>\n\u4e09 mysql\u8fde\u63a5\u5de5\u5177\u4e0e\u65b9\u5f0f<\/h2>\n3.1 mysql\u81ea\u5e26\u7684\u8fde\u63a5\u547d\u4ee4 mysql<\/h3>\n
mysql\u547d\u4ee4\u4ecb\u7ecd<\/p>\n
mysql\n#\u5e38\u89c1\u7684\u7279\u5b9a\u4e8e\u5ba2\u6237\u673a\u7684\u8fde\u63a5\u9009\u9879\uff1a\n-u: \u6307\u5b9a\u7528\u6237 mysql -uroot\n-p: \u6307\u5b9a\u5bc6\u7801 mysql -uroot -p567\n-h: \u6307\u5b9a\u4e3b\u673a\u57df mysql -uroot -p567 -h127.0.0.1\n-P: \u6307\u5b9a\u7aef\u53e3 mysql -uroot -p567 -h127.0.0.1 -P3307\n-S: \u6307\u5b9asocket\u6587\u4ef6 mysql -uroot -p567 -S \/tmp\/mysql.sock\n-e: \u6307\u5b9aSQL\u8bed\u53e5(\u5e93\u5916\u6267\u884cSQL\u8bed\u53e5) mysql -uroot -p567 -e "show databases;"\n#--protocol: \u6307\u5b9a\u8fde\u63a5\u65b9\u5f0f mysql --protocol=TCP --protocol=socket<\/code><\/pre>\n\u4f7f\u7528\u5bc6\u7801\u767b\u5f55<\/p>\n
#1.\u6b63\u786e\u767b\u5f55\u547d\u4ee4\n[root@db01 scripts]# mysql -uroot -p123\n[root@db01 scripts]# mysql -u root -p123\n[root@egon ~]# mysql # \u4ee5root\u7528\u6237\u767b\u5f55\u672c\u673a\uff0c\u5bc6\u7801\u4e3a\u7a7a\n\n#2.\u9519\u8bef\u767b\u5f55\u547d\u4ee4\n[root@db01 scripts]# mysql -u root -p 123 # -p\u9009\u9879\u4e0e\u5bc6\u7801\u4e4b\u95f4\u4e0d\u8981\u6709\u7a7a\u683c<\/code><\/pre>\n\u4e24\u79cd\u8fde\u63a5\u65b9\u5f0f<\/p>\n
1.TCP\/IP\u7684\u8fde\u63a5\u65b9\u5f0f\n2.\u5957\u63a5\u5b57\u8fde\u63a5\u65b9\u5f0f\uff0csocket\u8fde\u63a5\n\n#\u67e5\u770b\u8fde\u63a5\u65b9\u5f0f\nmysql> status;\n--------------\nConnection: Localhost via UNIX socket\n\n3.\u4e3e\u4f8b\uff1a\n 3.1.TCP\/IP\u8fde\u63a5\uff0c\u901a\u5e38\u5e26\u6709-h\u9009\u9879\u7684\u90fd\u662fTCP\/IP\u94fe\u63a5\n mysql -uroot -p -h127.0.0.1 -P \u7aef\u53e3\u53f7\n mysql -uroot -p -h127.0.0.1 -S \/tmp\/mysql.sock\n\n 3.2.socket\u8fde\u63a5\n mysql -uroot -p123(\u9ed8\u8ba4\u8fde\u63a5\u65b9\u5f0f,socket)\n\n4.\u6ce8\u610f:\n 4.1.\u56e0\u4e3a\u4f7f\u7528TCP\/IP\u8fde\u63a5,\u9700\u8981\u5efa\u7acb\u4e09\u6b21\u63e1\u624b\n 4.2.\u4e0d\u4e00\u5b9a-h\u90fd\u662ftcp\uff0c-hlocalhost\u662fsocket\u8fde\u63a5\n mysql -uroot -p -hlocalhost<\/code><\/pre>\n3.2 \u7b2c\u4e09\u65b9\u7684\u8fde\u63a5\u5de5\u5177<\/h3>\n1.sqlyog\n2.navicat\n#\u6ce8\u610f\uff1a\u6570\u636e\u5e93\u662f\u6ca1\u6709\u5916\u7f51\u7684\uff0c\u60f3\u8fde\u63a5\u53ef\u4ee5\u4f7f\u7528\u901a\u9053\n3.\u5e94\u7528\u7a0b\u5e8f\u8fde\u63a5MySQL\n#\u6ce8\u610f\uff1a\u9700\u8981\u52a0\u8f7d\u5bf9\u5e94\u8bed\u8a00\u7a0b\u5e8f\u7684API<\/code><\/pre>\n\u56db \u914d\u7f6e\u6587\u4ef6<\/h2>\n4.1 mysql\u914d\u7f6e\u6587\u4ef6\u7684\u4f5c\u7528<\/h3>\n1.\u5f71\u54cd\u670d\u52a1\u7aef\u7684\u542f\u52a8\uff08mysqld\uff09\n2.\u5f71\u54cd\u5ba2\u6237\u7aef\u7684\u8fde\u63a5<\/code><\/pre>\n4.2 \u914d\u7f6e\u6587\u4ef6\u4ecb\u7ecd<\/h3>\n
\u5f3a\u8c03\uff1a\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u6ce8\u91ca\u53ef\u4ee5\u6709\u4e2d\u6587\uff0c\u4f46\u662f\u914d\u7f6e\u9879\u4e2d\u4e0d\u80fd\u51fa\u73b0\u4e2d\u6587<\/strong><\/p>\n1. \u5728\u6267\u884cmysqld\u547d\u4ee4\u65f6\uff0c\u4e0b\u5217\u914d\u7f6e\u4f1a\u751f\u6548\uff0c\u5373mysql\u670d\u52a1\u542f\u52a8\u65f6\u751f\u6548\n[mysqld]\n;skip-grant-tables\nport=3306\ncharacter_set_server=utf8\ndefault-storage-engine=innodb\ninnodb_file_per_table=1\n\n#\u89e3\u538b\u7684\u76ee\u5f55\nbasedir=E:\\mysql-5.7.19-winx64\n#data\u76ee\u5f55\ndatadir=E:\\my_data #\u5728mysqld --initialize\u65f6\uff0c\u5c31\u4f1a\u5c06\u521d\u59cb\u6570\u636e\u5b58\u5165\u6b64\u5904\u6307\u5b9a\u7684\u76ee\u5f55\uff0c\u5728\u521d\u59cb\u5316\u4e4b\u540e\uff0c\u542f\u52a8mysql\u65f6\uff0c\u5c31\u4f1a\u53bb\u8fd9\u4e2a\u76ee\u5f55\u91cc\u627e\u6570\u636e\n\n#2. \u9488\u5bf9\u5ba2\u6237\u7aef\u547d\u4ee4\u7684\u5168\u5c40\u914d\u7f6e\uff0c\u5f53mysql\u5ba2\u6237\u7aef\u547d\u4ee4\u6267\u884c\u65f6\uff0c\u4e0b\u5217\u914d\u7f6e\u751f\u6548\n[client]\nport=3306\ndefault-character-set=utf8\nuser=root\npassword=123\n\n#3. \u53ea\u9488\u5bf9mysql\u8fd9\u4e2a\u5ba2\u6237\u7aef\u7684\u914d\u7f6e\uff0c2\u4e2d\u7684\u662f\u5168\u5c40\u914d\u7f6e\uff0c\u800c\u6b64\u5904\u7684\u5219\u662f\u53ea\u9488\u5bf9mysql\u8fd9\u4e2a\u547d\u4ee4\u7684\u5c40\u90e8\u914d\u7f6e\n[mysql]\n;port=3306\n;default-character-set=utf8\nuser=egon\npassword=4573\n\n#\uff01\uff01\uff01\u5982\u679c\u6ca1\u6709[mysql],\u5219\u7528\u6237\u5728\u6267\u884cmysql\u547d\u4ee4\u65f6\u7684\u914d\u7f6e\u4ee5[client]\u4e3a\u51c6<\/code><\/pre>\n4.3 \u7edf\u4e00\u5b57\u7b26\u7f16\u7801<\/h3>\n
xshell —> linux —> mysql\u6570\u636e\u5e93<\/p>\n
\u7cfb\u7edf\u7f16\u7801<\/p>\n
#1.\u547d\u4ee4\u884c\u4e34\u65f6\u4fee\u6539 : \nLANG=us_EN.UTF-8\nLANG=zh_CN.UTF-8\n\n\u4e34\u65f6\u4fee\u6539\u62a5\u9519\u547d\u4ee4\u4e3a\u5e94\u6587 : LANG=us_EN.UTF-8\n#2.\u4fee\u6539\u7cfb\u7edf\u5b57\u7b26\u96c6\nCentos6 \u6c38\u4e45\u4fee\u6539\uff1a[root@db03 ~]# vim \/etc\/sysconfig\/i18n\nCentos7 \u6c38\u4e45\u4fee\u6539\uff1a[root@db03 ~]# vim \/etc\/locale.conf<\/code><\/pre>\n\u4fee\u6539mysql\u6570\u636e\u5e93\u9ed8\u8ba4\u5b57\u7b26\u96c6<\/p>\n
\n- \n
\u65b9\u6cd51\uff1acmake\u65f6\u5019\u6307\u5b9a<\/p>\n
cmake .\n-DDEFAULT_CHARSET=UTF8 \\\n-DDEFAULT_COLLATION=UTF8_GENERAL_CI<\/code><\/pre>\n<\/li>\n- \n
\u65b9\u6cd52\uff1a\u914d\u7f6e\u6587\u4ef6\u6307\u5b9a<\/p>\n
#1.\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\n[mysqld]\ncharacter-set-server=utf8\ncollation-server=utf8_general_ci\n\n[client]\ndefault-character-set=utf8\n[mysql]\ndefault-character-set=utf8\n\n#2. \u91cd\u542f\u670d\u52a1\n#3. \u67e5\u770b\u4fee\u6539\u7ed3\u679c\uff1a\n\\s\nshow variables like '%char%';<\/code><\/pre>\n\u6ce8\u89e3\uff1a<\/p>\n
\u6821\u9a8c\u89c4\u5219: utf8_general_ci\n1\uff09ci\uff1a\u5927\u5c0f\u5199\u4e0d\u654f\u611f\n2\uff09cs\u6216bin\uff1a\u5927\u5c0f\u5199\u654f\u611f\n\n#\u4e00\u4e2a\u8868\u91cc\u9762\u4e0d\u53ef\u80fd\u51fa\u73b0\u540c\u540d\u4e0d\u540c\u5927\u5c0f\u5199\u7684\u5b57\u6bb5\n\n#\u67e5\u770b\u6821\u9a8c\u89c4\u5219\nmysql> show collation\uff1b<\/code><\/pre>\n\u6ce8\u610f\uff1a\u6700\u597d\u5728[mysqld]\u4e0b\u4e5f\u52a0\u4e0a\u4e0b\u8ff0\u914d\u7f6e\uff0c\u89c4\u8303\u4e00\u4e9b<\/p>\n
# \u53cd\u5411\u89e3\u6790\nskip-name-resolve\n\n# \u5b89\u88c5\u76ee\u5f55\u548c\u6570\u636e\u76ee\u5f55\nbasedir= \u5b89\u88c5\u76ee\u5f55\ndatadir= \u6570\u636e\u76ee\u5f55<\/code><\/pre>\nmysql\u6570\u636e\u5e93\u600e\u4e48\u5b58\u5165emoji\u8868\u60c5<\/p>\n
# \u7b2c\u4e00\u6b65\uff1a\u8bbe\u7f6e\u6570\u636e\u5e93\u5b57\u7b26\u7f16\u7801\u4e3autf8mb4_general_ci \u8bbe\u7f6e\u76f8\u5e94\u8868\u5b57\u6bb5\u5b57\u7b26\u7f16\u7801\u4e3autf8mb4_general_ci\n\n# \u7b2c\u4e8c\u6b65\uff1a\u8bbe\u7f6emy.cnf\u589e\u52a0\u4ee5\u4e0b\u914d\u7f6e\u4fe1\u606f\n[client]\ndefault-character-set = utf8mb4\n\n[mysql]\ndefault-character-set = utf8mb4\n\n[mysqld]\ncharacter-set-client-handshake = FALSE\ncharacter-set-server = utf8mb4\ncollation-server = utf8mb4_unicode_ci\ninit_connect='SET NAMES utf8mb4'\n\n# \u7b2c\u4e09\u6b65\uff1a\u91cd\u542fMySQL \u4fdd\u5b58\u8868\u60c5\u6570\u636e\u67e5\u770b\u6570\u636e\u5e93\u5c31\u53ef\u4ee5\u770b\u5230\u6570\u636e\u5e93\u4e2d\u6709\u8868\u60c5\u5b57\u7b26\u7684\u5b58\u5728\u3002<\/code><\/pre>\n<\/li>\n<\/ul>\n\u5982\u679c\u6ca1\u6709\u914d\u7f6e\u9ed8\u8ba4\u7f16\u7801\uff0c\u4e5f\u53ef\u4ee5\u5728\u5efa\u5e93\u6307\u5b9a\uff0c<\/p>\n
#1\u3001\u521b\u5efa\u6570\u636e\u5e93\u6307\u5b9a\u5b57\u7b26\u96c6\u548c\u6821\u9a8c\u89c4\u5219\ncreate database if not exists db1 charset utf8 collate utf8_general_ci;\n\n#2\u3001\u4fee\u6539\nalter database db1 charset utf8mb4 collate utf8mb4_general_ci;<\/code><\/pre>\n\u521b\u5efa\u7684\u65b0\u8868\u9ed8\u8ba4\u7ee7\u627f\u5176\u6240\u5728\u5e93\u7684\u5b57\u7b26\u7f16\u7801\uff0c\u9664\u975e\u4f60\u81ea\u5df1\u6307\u5b9a<\/p>\n
# \u5efa\u8868\u65f6\u6307\u5b9a\u7f16\u7801\nCREATE TABLE `test` (\n`id` int(4) NOT NULL AUTO_INCREMENT comment 'id',\n`name` char(20) NOT NULL comment '\u540d\u5b57',\nPRIMARY KEY (`id`) comment '\u4e3b\u952e'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n# \u6539\u8868\u7684\u5b57\u7b26\u96c6:\nalter table test charset utf8;<\/code><\/pre>\n\u6279\u91cf\u4fee\u6539\u5e93\u548c\u8868\u7684\u5b57\u7b26\u7f16\u7801<\/p>\n
#1\u3001\u6279\u91cf\u4fee\u6539\u5b57\u7b26\u96c6\uff0c30\u4e2a\u5e93\uff0c300\u4e2a\u8868\n1.\u6211\u4eec\u5148\u521b\u5efa10\u4e2a\u5e93\nfor n in `seq 10`;do mysql -uroot -p123 -e "create database db$n charset gbk;";done\n\n#2\u3001\u5e93\u91cc\u521b\u5efa\u8868\nfor n in `seq 10`;do mysql -uroot -p123 -e "use db$n;create table user$n(id int,name varchar(10)) charset gbk";done\n\nfor n in `seq 10`;do mysql -S \/data\/3309\/mysql.sock -uroot -p3309 -e "use db$n;create table user$n(id int,name varchar(10)) charset gbk";done\n\n#3\u3001\u600e\u4e48\u6279\u91cf\u4fee\u6539\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\uff1f\uff1f\uff1f\uff1f\n\u5bf9\u4e8e\u65b0\u521b\u5efa\u7684\u8868\u4f1a\u7ee7\u627f\u5e93\u7684\u5b57\u7b26\u7f16\u7801\uff0c\u4f46\u5bf9\u4e8e\u5df2\u7ecf\u5b58\u5728\u7684\u8001\u8868\uff0c\u4fee\u6539\u5176\u6240\u5728\u5e93\u7684\u5b57\u7b26\u7f16\u7801\uff0c\u8868\u7684\u5b57\u7b26\u7f16\u7801\u662f\u4e0d\u4f1a\u4fee\u6539\u7684\nalter database db1 charset utf8;\nshow create database db1;\nshow create table user1;\n\n\u4fee\u6539\u65b9\u5f0f\nfor n in `seq 10`;do mysql -uroot -p123 -e "alter database db$n charset utf8;use db$n;alter table user$n charset utf8";done<\/code><\/pre>\n4.4 \u8bbe\u7f6e\u4e0d\u533a\u5206\u5927\u5c0f\u5199<\/h3>\n
\u6ce8\u610f\uff1a\u5f00\u53d1\u65f6\uff0c\u6570\u636e\u5e93\u7684\u5e93\u540d\u548c\u8868\u540d\u90fd\u8981\u5c0f\u5199\uff0c\u56e0\u4e3a\u5f88\u591a\u7814\u53d1\u4f7f\u7528\u7b2c\u4e09\u65b9\u5de5\u5177\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u800cwindows\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff0clinux\u533a\u5206\u5927\u5c0f\u5199\uff0c\u5f88\u5bb9\u6613\u8bfb\u5199\u9519\u6570\u636e\u5e93\uff1b<\/p>\n
mysql> show variables like '%lower%';\n+------------------------+-------+\n| Variable_name | Value |\n+------------------------+-------+\n| lower_case_file_system | OFF |\n| lower_case_table_names | 0 |\n+------------------------+-------+\n2 rows in set (0.00 sec)<\/code><\/pre>\n\u53ef\u4ee5\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u6765\u8ba9\u6570\u636e\u5e93\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff1a<\/p>\n
[root@egon ~]# vim \/etc\/my.cnf\n[mysqld]\nlower_case_table_names=1\n[root@egon ~]# systemctl restart mysql<\/code><\/pre>\n\u4e94 MySQL\u5b9e\u4f8b\u521d\u59cb\u5316\u914d\u7f6e\uff08\u4e86\u89e3\uff09<\/h2>\n5.1 \u521d\u59cb\u5316\u914d\u7f6e\u6587\u4ef6\u7684\u4f5c\u7528<\/h3>\n1.\u9884\u7f16\u8bd1\uff1acmake\u53bb\u6307\u5b9a\uff0c\u786c\u7f16\u7801\u5230\u7a0b\u5e8f\u5f53\u4e2d\u53bb\n\n2.\u5728\u547d\u4ee4\u884c\u8bbe\u5b9a\u542f\u52a8\u521d\u59cb\u5316\u914d\u7f6e\n--skip-grant-tables \n--skip-networking\n--datadir=\/application\/mysql\/data\n--basedir=\/application\/mysql\n--defaults-file=\/etc\/my,cnf\n--pid-file=\/application\/mysql\/data\/db01.pid\n--socket=\/application\/mysql\/data\/mysql.sock\n--user=mysql\n--port=3306\n--log-error=\/application\/mysql\/data\/db01.err\n\n3.\u521d\u59cb\u5316\u914d\u7f6e\u6587\u4ef6\uff08\/etc\/my.cnf\uff09<\/code><\/pre>\n5.2 \u914d\u7f6e\u6587\u4ef6\u8bfb\u53d6\u987a\u5e8f<\/h3>\n5.2.1 \u8bfb\u53d6\u987a\u5e8f<\/h4>\n\/etc\/my.cnf\n\/etc\/mysql\/my.cnf\n$basedir\/my.cnf\uff08\u524d\u63d0\u662f\u5728\u73af\u5883\u53d8\u91cf\u4e2d\u5b9a\u4e49\u4e86MYSQL_HOME\u53d8\u91cf\uff09\ndefaults-extra-file \uff08\u7c7b\u4f3cinclude\uff09\n~\/.my.cnf<\/code><\/pre>\n5.2.2 \u751f\u6548\u987a\u5e8f<\/h4>\n~\/.my.cnf\ndefaults-extra-file \uff08\u7c7b\u4f3cinclude\uff09\n$basedir\/my.cnf\uff08\u524d\u63d0\u662f\u5728\u73af\u5883\u53d8\u91cf\u4e2d\u5b9a\u4e49\u4e86MYSQL_HOME\u53d8\u91cf\uff09\n\/etc\/mysql\/my.cnf\n\/etc\/my.cnf<\/code><\/pre>\n5.2.3 \u751f\u6548\u987a\u5e8f\u9a8c\u8bc1<\/h4>\n#\u914d\u7f6e\/etc\/my.cnf\n[root@db01 ~]# vim \/etc\/my.cnf\n[mysqld]\nserver_id=1\n\n#\u914d\u7f6e\/etc\/mysql\/my.cnf\n[root@db01 ~]# mkdir \/etc\/mysql\n[root@db01 ~]# vim \/etc\/mysql\/my.cnf\n[mysqld]\nserver_id=2\n\n#\u914d\u7f6e$basedir\/my.cnf\n[root@db01 ~]# vim \/service\/mysql\/my.cnf \n[mysqld]\nserver_id=3\n\n#\u914d\u7f6e~\/my.cnf\n[root@db01 ~]# vim ~\/.my.cnf\n[mysqld]\nserver_id=4\n\n#\u91cd\u542f\u6570\u636e\u5e93\uff08\u6ce8\u610f\u8fd9\u91cc\u4e0d\u80fd\u4f7f\u7528systemctl restart mysql\u91cd\u542f\uff09\n[root@db01 ~]# systemctl stop mysql\n[root@db01 ~]# \/etc\/init.d\/mysqld start\n\n#\u67e5\u770bserver_id\nmysql> show variables like 'server_id';\n+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| server_id | 4 |\n+---------------+-------+\n1 row in set (0.00 sec)<\/code><\/pre>\n5.3 \u601d\u8003\u53c2\u6570\u6267\u884c\u4f18\u5148\u7ea7<\/h3>\n#cmake\uff1a\nsocket=\/service\/mysql\/tmp\/mysql.sock\n\n#\u547d\u4ee4\u884c\uff1a\n--socket=\/tmp\/mysql.sock\n\n#\u914d\u7f6e\u6587\u4ef6\uff1a\nvim \/etc\/my.cnf\n[mysqld]\nsocket=\/opt\/mysql.sock\n\n#default\u53c2\u6570\uff1a\n--defaults-file=\/tmp\/a.txt\nvim \/tmp\/a.txt\n[mysqld]\nsocket=\/tmp\/test.sock\n\n#\u542f\u52a8\u6d4b\u8bd5\nmysql_safe --defaults-file=\/tmp\/a.txt --socket=\/tmp\/mysql.sock<\/code><\/pre>\n\u4f18\u5148\u7ea7\u6d4b\u8bd5\u7ed3\u8bba\uff1a\n1\u3001\u547d\u4ee4\u884c\n2\u3001defaults-file\n3\u3001\u914d\u7f6e\u6587\u4ef6\n4\u3001\u9884\u7f16\u8bd1\n\n\u547d\u4ee4\u884c >> defaults-file >> ~\/.my.cnf >> defaults-extra-file >> $basedir\/my.cnf >> \/etc\/mysql\/my.cnf >> \/etc\/my.cnf >> cmake<\/code><\/pre>\n\u516d mysql\u76f8\u5173\u547d\u4ee4<\/h2>\n6.1 mysql\u8fde\u63a5\u540e\u547d\u4ee4\u884c\u5feb\u6377\u547d\u4ee4<\/h3>\n\\c\uff1a\u4e2d\u65ad\u5f53\u524d\u8f93\u5165\u8bed\u53e5\n \\r\uff1a\u91cd\u65b0\u8fde\u63a5\u5230\u670d\u52a1\u5668\n \\d\uff1a\u8bbe\u7f6e\u8bed\u53e5sql\u7ed3\u675f\u7b26 mysql> \\d ]\n \\e\uff1a\u7f16\u8f91\u547d\u4ee4 \u8f93\u51fa\u8f93\u5165\u7684\u5185\u5bb9 echo\n \\p\uff1a\u6253\u5370\u5f53\u524d\u547d\u4ee4\u5e76\u6267\u884c\n\\G\uff1a\u5782\u76f4\u663e\u793a\u7ed3\u679c\n\\q\uff1a\u9000\u51famysql \u7b49\u4e8e quit exit\n \\g\uff1a\u8868\u793a\u7ed3\u675f \u7b49\u4e8e ; \u7684\u4f5c\u7528\n\\h\uff1a\u663e\u793a\u6b64\u5e2e\u52a9 \u7b49\u4e8e help #help\u8fd8\u53ef\u4ee5\u67e5\u770b\u547d\u4ee4\u8bed\u6cd5 help create database;\n \\t\uff1a\u4e0d\u5199\u5165outfile\n\\T\uff1a\u5c06\u6240\u6709\u5185\u5bb9\u9644\u52a0\u5230\u7ed9\u5b9a\u7684\u8f93\u51fa\u6587\u4ef6\u4e2d\uff08\u53ea\u652f\u6301\u672c\u6b21\u4f1a\u8bdd\uff09 \\T \/tmp\/a.log\n #\\n\uff1a\u7981\u7528\u5bfb\u547c\u673a\uff0c\u6253\u5370\u5230\u6807\u51c6\u8f93\u51fa\u3002\n #\\P\uff1a\u8bbe\u7f6e\u5bfb\u547c\u673a[\u5230\u5bfb\u547c\u673a]\u3002\u901a\u8fc7\u5bfb\u547c\u673a\u6253\u5370\u67e5\u8be2\u7ed3\u679c\u3002\n\\R\uff1a\u66f4\u6539mysql\u63d0\u793a\u7b26 \\R mysql>>> \n\\.\uff1a\u6267\u884c\u4e00\u4e2asql\u6587\u4ef6 \u7b49\u4e8e source\n\\s\uff1a\u4ece\u670d\u52a1\u5668\u83b7\u53d6\u72b6\u6001\u4fe1\u606f \u7b49\u4e8e status\n\\u\uff1a\u5207\u6362\u6570\u636e\u5e93 \u7b49\u4e8e use #\u67e5\u770b\u5f53\u524d\u6240\u5728\u6570\u636e\u5e93select database();\n \\C\uff1a\u5207\u6362\u5230\u53e6\u4e00\u4e2a\u5b57\u7b26\u96c6 \u4e00\u822c\u4e0d\u4f7f\u7528\n \\W\uff1a\u5728\u6bcf\u4e2a\u8bed\u53e5\u540e\u663e\u793a\u8b66\u544a\n \\w\uff1a\u4e0d\u5728\u6bcf\u4e2a\u8bed\u53e5\u540e\u663e\u793a\u8b66\u544a<\/code><\/pre>\n6.2 help\u547d\u4ee4<\/h3>\nmysql> help\nmysql> help contents help \u7528\u6cd5\nmysql> help select\nmysql> help create\nmysql> help create user\nmysql> help status\nmysql> help show<\/code><\/pre>\n6.3 mysqladmin\u547d\u4ee4<\/h3>\n1.\u4fee\u6539\u5bc6\u7801,\u8bbe\u7f6e\u5bc6\u7801:password\n[root@db01 ~]# mysqladmin -uroot -p\u65e7\u5bc6\u7801 password '\u65b0\u5bc6\u7801'\n\n2.\u5173\u95edMySQL\u670d\u52a1:shutdown\n[root@db01 ~]# mysqladmin -uroot -p\u5bc6\u7801 -S socket\u6587\u4ef6 shutdown\n\n3.\u5e93\u5916\u5efa\u5e93:create\n[root@db01 ~]# mysqladmin -uroot -p\u5bc6\u7801 create egon\n[root@db01 ~]# mysql -uroot -p123456 -e 'create database egon'\n\n4.\u5e93\u5916\u5220\u9664\u6570\u636e\u5e93:drop\n[root@db01 ~]# mysqladmin -uroot -p123456 drop egon\nDo you really want to drop the 'egon' database [y\/N] y\nDatabase "egon" dropped\n\n5.\u67e5\u770b\u914d\u7f6e\u6587\u4ef6\u6240\u6709\u7684\u9ed8\u8ba4\u53c2\u6570:variables\n[root@db01 ~]# mysqladmin -uroot -p123456 variables\n[root@db01 ~]# mysqladmin -uroot -p123456 variables | grep server_id\n\n6.\u68c0\u6d4bMySQL\u8fdb\u7a0b\u662f\u5426\u5b58\u6d3b:ping\n[root@db01 ~]# mysqladmin -uroot -p123456 ping\n\n7.\u67e5\u770b\u6570\u636e\u5e93 \u6162\u67e5\u8be2,\u8d1f\u8f7d\u4fe1\u606f:status\n[root@db01 ~]# mysqladmin -uroot -p123456 status\nUptime MySQL\u670d\u52a1\u5668\u5df2\u7ecf\u8fd0\u884c\u7684\u79d2\u6570\nThreads \u6d3b\u8dc3\u7ebf\u7a0b\uff08\u5ba2\u6237\uff09\u7684\u6570\u91cf \nQuestions \u4ecemysqld\u542f\u52a8\u8d77\u6765\u81ea\u5ba2\u6237\u95ee\u9898\u7684\u6570\u91cf \u5df2\u7ecf\u53d1\u9001\u7ed9\u670d\u52a1\u5668\u7684\u67e5\u8be2\u7684\u4e2a\u6570\nSlow queries \u5df2\u7ecf\u8d85\u8fc7long_query_time\u79d2\u7684\u67e5\u8be2\u6570\u91cf \nOpens mysqld\u5df2\u7ecf\u6253\u5f00\u4e86\u591a\u5c11\u8868 \nFlush tables flush ..., refresh\u548creload\u547d\u4ee4\u6570\u91cf \nOpen tables \u73b0\u5728\u88ab\u6253\u5f00\u7684\u8868\u6570\u91cf\nQueries per second avg: 0.046 \u8d1f\u8f7d\n\n8.\u91cd\u8f7d\u6388\u6743\u8868,\u5237\u65b0\u7f13\u5b58\u4e3b\u673a:reload\uff0c\u76f8\u5f53\u4e8eflush privileges\n[root@db01 ~]# mysqladmin -uroot -p123456 reload\n\n9.\u5237\u65b0binlog\u65e5\u5fd7\n[root@db01 ~]# mysqladmin -uroot -p123456 flush-log<\/code><\/pre>\n\u4e03 \u521d\u59cbsql\u8bed\u53e5<\/h2>\n
\u6709\u4e86mysql\u8fd9\u4e2a\u6570\u636e\u5e93\u8f6f\u4ef6\uff0c\u5c31\u53ef\u4ee5\u5c06\u7a0b\u5e8f\u5458\u4ece\u5bf9\u6570\u636e\u7684\u7ba1\u7406\u4e2d\u89e3\u8131\u51fa\u6765\uff0c\u4e13\u6ce8\u4e8e\u5bf9\u7a0b\u5e8f\u903b\u8f91\u7684\u7f16\u5199<\/p>\n
mysql\u670d\u52a1\u7aef\u8f6f\u4ef6\u5373mysqld\u5e2e\u6211\u4eec\u7ba1\u7406\u597d\u6587\u4ef6\u5939\u4ee5\u53ca\u6587\u4ef6\uff0c\u524d\u63d0\u662f\u4f5c\u4e3a\u4f7f\u7528\u8005\u7684\u6211\u4eec\uff0c\u9700\u8981\u4e0b\u8f7dmysql\u7684\u5ba2\u6237\u7aef\uff0c\u6216\u8005\u5176\u4ed6\u6a21\u5757\u6765\u8fde\u63a5\u5230mysqld\uff0c\u7136\u540e\u4f7f\u7528mysql\u8f6f\u4ef6\u89c4\u5b9a\u7684\u8bed\u6cd5\u683c\u5f0f\u53bb\u63d0\u4ea4\u81ea\u5df1\u547d\u4ee4\uff0c\u5b9e\u73b0\u5bf9\u6587\u4ef6\u5939\u6216\u6587\u4ef6\u7684\u7ba1\u7406\u3002\u8be5\u8bed\u6cd5\u5373sql\uff08Structured Query Language \u5373\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\uff09<\/p>\n
SQL\u8bed\u8a00\u4e3b\u8981\u7528\u4e8e\u5b58\u53d6\u6570\u636e\u3001\u67e5\u8be2\u6570\u636e\u3001\u66f4\u65b0\u6570\u636e\u548c\u7ba1\u7406\u5173\u7cfb\u6570\u636e\u5e93\u7cfb\u7edf,SQL\u8bed\u8a00\u7531IBM\u5f00\u53d1\u3002\nSQL\u8bed\u8a00\u5206\u4e3a\uff1a\nDDL\uff1aData definition Language \u6570\u636e\u5b9a\u4e49\u8bed\u8a00\uff08CREATE\u3001DROP\u3001ALTER\uff09\nDCL\uff1aData control Language \u6570\u636e\u63a7\u5236\u8bed\u8a00\uff08GRANT\uff0cREVOKE\uff0cROLLBACK\uff0cCOMMIT\uff09\nDML\uff1aData Manipulation Language \u6570\u636e\u64cd\u4f5c\u8bed\u8a00\uff08INSERT\uff0cUPDATE\uff0cDELETE\uff09\nDQL\uff1aData Query Language \u6570\u636e\u67e5\u8be2\u8bed\u8a00\uff08SELECT\uff09<\/code><\/pre>\n![\"\"](\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\")
<\/div><\/p>\n\u5e93\u3001\u8868\u3001\u8bb0\u5f55\u7684\u589e\u5220\u6539\u67e5<\/p>\n
#1. \u64cd\u4f5c\u6587\u4ef6\u5939\n\u589e\uff1acreate database db1 charset utf8;\n \u6570\u636e\u5e93\u5df2\u5b58\u5728\u4f1a\u62a5\u9519\uff0c\u4f7f\u7528IF NOT EXISTS\n create database if not exists db1 charset utf8;\n\u67e5\uff1ashow databases;\n\u6539\uff1aalter database db1 charset latin1;\n\u5220\u9664: drop database db1;\n\n#2. \u64cd\u4f5c\u6587\u4ef6\n\u5148\u5207\u6362\u5230\u6587\u4ef6\u5939\u4e0b\uff1ause db1\n\u589e\uff1acreate table t1(id int,name char);\n\u67e5\uff1ashow tables\n\u6539\uff1aalter table t1 modify name char(3);\nalter table t1 change name name1 char(2);\n\u5220\uff1adrop table t1;\n\n#3. \u64cd\u4f5c\u6587\u4ef6\u4e2d\u7684\u5185\u5bb9\/\u8bb0\u5f55\n\u589e\uff1ainsert into t1 values(1,'egon1'),(2,'egon2'),(3,'egon3');\n\u67e5\uff1aselect * from t1;\n\u6539\uff1aupdate t1 set name='sb' where id=2;\n\u5220\uff1adelete from t1 where id=1;\n\n\u6e05\u7a7a\u8868\uff1a\ndelete from t1; #\u5982\u679c\u6709\u81ea\u589eid\uff0c\u65b0\u589e\u7684\u6570\u636e\uff0c\u4ecd\u7136\u662f\u4ee5\u5220\u9664\u524d\u7684\u6700\u540e\u4e00\u6837\u4f5c\u4e3a\u8d77\u59cb\u3002\ntruncate table t1;\u6570\u636e\u91cf\u5927\uff0c\u5220\u9664\u901f\u5ea6\u6bd4\u4e0a\u4e00\u6761\u5feb\uff0c\u4e14\u76f4\u63a5\u4ece\u96f6\u5f00\u59cb\uff0c\n\nauto_increment \u8868\u793a\uff1a\u81ea\u589e\nprimary key \u8868\u793a\uff1a\u7ea6\u675f\uff08\u4e0d\u80fd\u91cd\u590d\u4e14\u4e0d\u80fd\u4e3a\u7a7a\uff09\uff1b\u52a0\u901f\u67e5\u627e<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u6570\u636e\u5e93\u57fa\u672c\u7ba1\u7406 \u4e00 MySQL\u542f\u52a8\u5173\u95ed\u6d41\u7a0b mysql\u662f\u4e00\u4e2a\u5178\u578b\u7684C\/S\u670d\u52a1\u7ed3\u6784 1.mysql\u81ea\u5e26\u7684\u5ba2\u6237\u7aef\u7a0b […]<\/p>\n","protected":false},"author":3,"featured_media":472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[79],"tags":[21,19,99,22,100,20],"_links":{"self":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/471"}],"collection":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=471"}],"version-history":[{"count":1,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/471\/revisions"}],"predecessor-version":[{"id":11352,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/471\/revisions\/11352"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/media\/472"}],"wp:attachment":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/egonlin.com\/wp-content\/uploads\/2021\/07\/10-1024x321.png\")
<\/div><\/p>\n