\u6b77\u53f2
1994\u745e\u5178\uff0c\u5f9e\u5546\u696d(AB\u516c\u53f8)\u5230\u958b\u6e90\uff0c\u4e26\u65bc2008\u5e74\u88abSUN\u82b110\u5104\u7f8e\u91d1\u6536\u8cfc<\/p>\n\n\n\n
……………………………………………………………….<\/p>\n\n\n\n
\u65b9\u6cd51 \u65b9\u6cd52 …<\/p>\n\n\n\n \u555f\u52d5mysql<\/strong> \u8a2d\u5b9aroot\u5bc6\u78bc<\/strong> \u767b\u5165mysql<\/strong> … <\/p>\n\n\n\n \u5b89\u88dd\u5f8c\u72c0\u614b<\/strong><\/p>\n\n\n\n \u6a94\u6848\u914d\u7f6e<\/strong>(\u4f9d\u7248\u672c\u53ef\u80fd\u5404\u6709\u4e0d\u540c) ps: ps: …<\/p>\n\n\n\n web\u7ba1\u7406\u8edf\u9ad4<\/strong> ……………………………………………………………………………………<\/p>\n\n\n\n ……………………………………………………………………………………<\/p>\n\n\n\n \u8a2d\u5b9auser\u5bc6\u78bc<\/strong> \u79fb\u9664\u9060\u7aef\u5b58\u53d6<\/strong> \u79fb\u9664\u7121\u4f7f\u7528\u8005<\/strong> \u7d66\u5e33\u865f<\/strong>user<\/strong>\u6240\u6709\u6b0a\u9650 \u7acb\u5373\u66f4\u65b0<\/strong> …<\/p>\n\n\n\n \u6e05\u9664mysql log<\/strong> \u53e6\u4e00\u65b9\u6cd5\u70ba …<\/p>\n\n\n\n …………………………………………………………………………………..<\/p>\n\n\n\n …………………………………………………………………………………..<\/p>\n\n\n\n \u4f7f\u7528dump<\/strong> \u4f7f\u7528outfile<\/strong> ……………………………..<\/p>\n\n\n\n \u532f\u5165\u8cc7\u6599\u5e38\u7528\u6709\u4ee5\u4e0b\u4e09\u7a2e<\/strong><\/p>\n\n\n\n \u4f7f\u7528mysqlimport<\/strong> …………………………………………………………………………….<\/p>\n\n\n\n …………………………………………………………………………….<\/p>\n\n\n\n \u66f4\u6539MySQL\u8cc7\u6599\u5eab\u76ee\u9304<\/strong> \u6b77\u53f21994\u745e\u5178\uff0c\u5f9e\u5546\u696d(AB\u516c\u53f8)\u5230\u958b\u6e90\uff0c\u4e26\u65bc2008\u5e74\u88ab …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[16],"tags":[],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-database"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/comments?post=577"}],"version-history":[{"count":0,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"wp:attachment":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
yum\u5b89\u88dd<\/strong>
yum install mysql
yum install mysql-server<\/p>\n\n\n\n
rpm\u5b89\u88dd<\/strong>
\u76f8\u95dc\u8cc7\u6599
glibc 2.0.7-19 \u6b64\u5bd2\u5f0f\u5eab\u4e4b\u524d\u7684\u7248\u672c\u5c0d\u5b89\u88ddmysql\u6709\u4e0d\u826f\u5f71\u97ff
perl-dbi*.rpm \u5b89\u88ddmysql-server*.rpm\u6642\u53ef\u80fd\u6703\u9808\u8981
mysql-server*.rpm \u4e3b\u4f3a\u670d\u5668\uff0c\u5b89\u88dd\u9806\u5e8f1 (\u5927\u90e8\u4efd\u5b89\u88dd\u5728\/usr\/bin\/*,\/usr\/share\/*)
mysql-client*.rpm \u5ba2\u6236\u7aef\u9023\u7dda\u7a0b\u5f0f\uff0c\u5b89\u88dd\u9806\u5e8f2 (\u5b89\u88dd\u5728\/usr\/bin\/*,\/usr\/share\/man\/*)
mysql-devel*.rpm \u5bd2\u5f0f\u5eab\u548c\u6a19\u982d\u6a94\uff0c\u5b89\u88dd\u9806\u5e8f3 (\u5927\u90e8\u4efd\u5b89\u88dd\u5728\/usr\/include\/mysql\/*,\/usr\/lib\/mysql\/*)
mysql-shared*.rpm \u52d5\u614b\u5ba2\u6236\u7aef\u5bd2\u5f0f\u5eab\uff0c\u5b89\u88dd\u9806\u5e8f4 (\u5b89\u88dd\u5728\/usr\/lib\/*)
mysql-test*.rpm \u6548\u80fd\u6e2c\u8a66\u5957\u4ef6,\u53ef\u7701\u7565\u7684\u5957\u4ef6<\/p>\n\n\n\n
mysql.server [start|stop] \/\/\u555f\u52d5\u95dc\u9589mysqld<\/p>\n\n\n\n
\/usr\/bin\/mysqladmin -u root password ‘newpwd’ \/\/\u8a2d\u5b9amysql\u88e1\u5e33\u865froot\u7684\u65b0\u5bc6\u78bc\u70banewpwd<\/p>\n\n\n\n
mysql -u root -p \/\/\u7528root\u8eab\u4efd\u9032\u5165mysql
ps:
mysql db -u root -p \/\/\u7528root\u8eab\u4efd\u9032\u5165mysql,\u4e26\u81ea\u52d5\u57f7\u884cuse db
mysql db -u root -p < file.sql \/\/\u4ee5root\u8eab\u4efd,\u5c07file.sql\u532f\u5165\u5230\u8cc7\u6599\u5eabdb<\/p>\n\n\n\n
\/etc\/my.cnf\u3000MySQL\u8a2d\u5b9a\u6a94
\/usr\/bin \u3000\u5ba2\u6236\u7aef\u7a0b\u5f0f
\/usr\/sbin \u3000mysqld\u4f3a\u670d\u5668
\/var\/lib\/mysql \u3000\u7d00\u9304\u6a94\u8207\u8cc7\u6599\u5eab\u6a94\u6848,\u5099\u4efdmysql\u6642\u9700\u9023\u540c\u6b64\u76ee\u9304
\/usr\/share\/doc\/packages \u3000\u6587\u4ef6<\/p>\n\n\n\n
\u5728\u8cc7\u6599\u5eab\u6a94\u6848\u5167\u8cc7\u6599\u6a94
\u3000\u8cc7\u6599\u8868\u540d.frm :\u8cc7\u6599\u8868\u5b9a\u7fa9\u6a94
\u3000\u8cc7\u6599\u8868\u540d.myd :\u8cc7\u6599\u6a94
\u3000\u8cc7\u6599\u8868\u540d.myi :\u7d22\u5f15\u6a94<\/p>\n\n\n\n
mysql\u8cc7\u6599\u8868\u683c\u5f0f
\u3000myisam \u901f\u5ea6\u5feb\uff0c\u9810\u8a2d\u4f7f\u7528\uff0c\u7121\u6cd5\u5bb9\u932f\u56e0\u6b64\u9700\u8981\u5e38\u5099\u4efd
\u3000heap \u7559\u5728\u8a18\u61b6\u9ad4\u7684\u8868\u683c\uff0c\u901f\u5ea6\u6700\u5feb
\u3000innodb \u5177\u6709\u4ea4\u6613\u7279\u6027\uff0c\u901f\u5ea6\u6162<\/p>\n\n\n\n
phpmyadmin\u5b89\u88dd\u6b65\u9a5f\u5982\u4e0b
1
download
ex:http:\/\/www.phpmyadmin.net\/home_page\/downloads.php
2 [optional]
#tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz
#mv phpMyAdmin_x.x.x-all-languages \/var\/www\/html\/phpmyadmin
#cd \/var\/www\/html\/phpmyadmin
3
#cp config.sample.inc.php config.inc.php
4
#vi config.inc.php
$cfg[‘blowfish_secret’] = ‘ba17c1ec07d65003’; \/\/ use here a value of your choice
$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;
ps:
$cfg[‘Servers’][$i][‘auth_type’] string [‘HTTP’|’http’|’cookie’|’config’|’signon’]
‘HTTP’ authentication (was called ‘advanced’ in previous versions and can be written also as ‘http’) ($auth_type = ‘HTTP’) as introduced in 1.3.0 allows you to log in as any valid MySQL user via HTTP-Auth.
5
open browser
http:\/\/ server ip \/phpmyadmin\/
login vaild mysql user<\/p>\n\n\n\n
\u53c3\u8003\u6587\u7ae0
http:\/\/www.phpmyadmin.net\/documentation\/<\/p>\n\n\n\n\u7ba1\u7406mysql\u5e38\u7528\u529f\u80fd<\/strong><\/h2>\n\n\n\n
mysql> set password for user@localhost=password(‘userpassword’);<\/p>\n\n\n\n
1 mysql> use mysql
2 mysql> delete from user where host=’%’
\u65b0\u589e\u4efb\u4f55\u5730\u65b9\u90fd\u53ef\u9023\u4e0amysql\u7684root\u5e33\u865f <\/strong>
INSERT INTO `user` (`Host`, `User`)values(‘%’, ‘root’);<\/p>\n\n\n\n
1 mysql> use mysql
2 mysql> delete from user where user=”<\/p>\n\n\n\n
<\/strong>mysql> GRANT ALL ON *.* TO user@localhost IDENTIFIED BY ‘userpasswd’;<\/p>\n\n\n\n
mysql> flush privileges<\/p>\n\n\n\n
\u6709\u6642\u56e0log\u6a94\u592a\u5927\uff0c\u53ef\u5c07mysql-bin.0000001…\u7b49log\u6e05\u9664
mysql> reset master
Query OK, 0 rows affected (3.56 sec)
ps:
\u82e5\u8981\u6c42mysq\u4e0d\u7522log,\u53ef\u5728my.cnf\u5167\u8a2d\u70ba\u4ee5\u4e0b
#log-bin=mysql-bin<\/p>\n\n\n\n
PURGE BINARY LOGS
ps:http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/purge-binary-logs.html
ex:
\u522a\u9664mysql-bin.010\u9019\u500blog\u6a94
PURGE BINARY LOGS TO ‘mysql-bin.010’;
ex:
\u522a\u96642012-01-01 12:00:00\u4e4b\u524d\u7684log
PURGE BINARY LOGS BEFORE ‘2012-01-01 12:00:00’;<\/p>\n\n\n\n
\u76f4\u63a5\u767b\u5165mysql\u4e14\u4e0d\u4f7f\u7528\u5bc6\u78bc<\/strong>
\u7576\u5fd8\u8a18\u5bc6\u78bc,\u6216\u51fa\u73feAccess denied for user ‘root’@’localhost’ (using password: NO)\u7684\u72c0\u6cc1\u6642
\u505a\u6cd5:
\u5148\u505c\u6b62mysql,\u4e26\u57f7\u884c\u4ee5\u4e0b
# mysqld_safe –user=mysql –skip-grant-tables –skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
\u91cd\u65b0\u555f\u52d5mysql<\/p>\n\n\n\n\u8cc7\u6599\u5099\u4efd\u90e8\u4efd<\/strong><\/h2>\n\n\n\n
\u532f\u51fa\u8cc7\u6599\u5e38\u7528\u6709\u4ee5\u4e0b\u5169\u7a2e<\/strong><\/p>\n\n\n\n
ex:
mysqldump -u test -h 192.168.0.100 -p testdb > alltable.sql
mysqldump -u test -h 192.168.0.100 -p testdb testtable > alltesttable.sql
mysqldump -u test -h 192.168.0.100 -d -p testdb testtable > schematesttable.sql
mysqldump -u test -h 192.168.0.100 -d -p testdb testtable1 testtable2 > schemasometable.sql
\u53c3\u6578\u8aaa\u660e
>: \u8868\u793a\u532f\u51fa\u8cc7\u6599
<: \u8868\u793a\u532f\u5165\u8cc7\u6599
-u: mysql\u4f7f\u7528\u8005
-h: \u9023\u7ddahost IP\u6216Domain Name
-d: \u53ea\u9700\u8981\u532f\u51fa(dump)Table\u7684\u7d50\u69cb, \u82e5\u6c92\u6709\u6b64\u53c3\u6578, \u6703\u5c07Table\u7684\u7d50\u69cb\u548c\u8cc7\u6599\u4e00\u4f75\u532f\u51fa
-p: \u9700\u8981\u5bc6\u78bc, \u6307\u4ee4\u57f7\u884c\u5f8c\u5f85\u6703\u6703\u8981\u6c42\u8f38\u5165
testdb: \u6307\u5b9a\u8981\u8655\u7406\u7684DB\u540d\u7a31
testtable: \u6307\u5b9a\u8981\u8655\u7406\u7684Table\u540d\u7a31
testtable.sql: \u532f\u5165\u6216\u662f\u532f\u51faTable\u8cc7\u6599\u7684SQL\u8a9e\u6cd5<\/p>\n\n\n\n
ex:
select * from data into outfile ‘\/tmp\/test.csv’ FIELDS TERMINATED BY ‘,’<\/p>\n\n\n\n
tablename\u5fc5\u9808\u548c\u4f86\u6e90\u6587\u5b57\u6a94\u4e00\u6a23,\u4e5f\u5c31\u662f\u5728\u532f\u5165\u4e4b\u524d\u9808\u5148\u5efa\u597d
\u683c\u5f0f
mysqlimport -u root [other parameter] -p < dbname> < tablename>.txt
\u5e38\u7528parameter
\u3000–fields-terminated-by=\u5206\u9694\u6b04\u4f4d\u7684\u5b57\u5143
\u3000–fields-enclosed-by=\u6b04\u4f4d\u908a\u754c\u7684\u5b57\u5143
\u3000–local \u8a2d\u5b9a\u70ba\u672c\u5730
\u3000–ignore-lines=N ,Ignore the first N lines of the data file.
ex:
mysqlimport -u root –local –fields-terminated-by=, -p kdd99 kddcupdata10.txt
refer\u3000
https:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/mysqlimport.html
<\/p>\n\n\n\n
\u4f7f\u7528 \u91cd\u5c0e\u5411<\/strong>
ex:
mysql -u test -p testdb < testtable.sql<\/p>\n\n\n\n
\u4f7f\u7528\u3000load data\u3000<\/strong>
\u683c\u5f0f
LOAD DATA INFILE ‘< filepath >’ INTO TABLE < tablename> [ paramanter]
\u5e38\u7528parameter
\u3000FIELDS TERMINATED BY \u4ee5\u90a3\u500b\u5b57\u5143\u505a\u5206\u9694
\u3000FIELDS ENCLOSED BY \u4ee5\u90a3\u500b\u5b57\u5143\u505a\u6b04\u4f4d\u7684\u524d\u5f8c\u908a\u754c
\u3000IGNORE 1 LINES \u5ffd\u7565\u7b2c1\u884c
ex:
LOAD DATA INFILE ‘\/root\/test.csv’ INTO TABLE ibtable FIELDS TERMINATED BY ‘,’
LOAD DATA INFILE ‘\/tmp\/test.txt’ INTO TABLE test IGNORE 1 LINES
ps:
LOAD DATA INFILE\u4e0d\u884c\u53ef\u7528LOAD DATA LOCAL INFILE\u4ee3\u66ff
refer\u3000
https:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/load-data.html
ps:
load data\u53c3\u6578\u7d50\u69cb\u5982\u4e0b
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name’
\u3000[REPLACE | IGNORE]
\u3000INTO TABLE tbl_name
\u3000[CHARACTER SET charset_name]
\u3000[{FIELDS | COLUMNS}
\u3000\u3000[TERMINATED BY ‘string’]
\u3000\u3000[[OPTIONALLY] ENCLOSED BY ‘char’]
\u3000\u3000[ESCAPED BY ‘char’]
\u3000]
\u3000[LINES
\u3000\u3000[STARTING BY ‘string’]
\u3000\u3000[TERMINATED BY ‘string’]
\u3000]
\u3000[IGNORE number LINES]
\u3000[(col_name_or_user_var,…)]
\u3000[SET col_name = expr,…]<\/p>\n\n\n\n\u5176\u4ed6\u90e8\u4efd <\/strong><\/h2>\n\n\n\n
\u5047\u8a2dMySQL\u8cc7\u6599\u5eab\u76ee\u9304\u5728linux\u4e0b\u9810\u8a2d\u70ba\/var\/lib\/mysql,\u82e5\u8981\u6539\u5230\/data\uff0c\u5982\u4e0b\u6240\u793a\uff1a
1
stop mysql service<\/strong>
mysqladmin -u root -p shutdown
2
move \/var\/lib\/mysql to \/data<\/strong>
mv \/var\/lib\/mysql\u3000\/data\/
3
edit \/etc\/my.cnf<\/strong>\u3000
vi\u3000 my.cnf\u3000\u3000\u3000
# The MySQL server
[mysqld]
port\u3000\u3000\u3000= 3306
#socket\u3000 = \/var\/lib\/mysql\/mysql.sock
socket\u3000 = \/data\/mysql\/mysql.sock\u3000\/\/\u6307\u5b9amysql.sock\u7684\u7522\u751f\u4f4d\u7f6e\u3000
4\u3000
edit MySQL start script <\/strong>
vi\u3000\/etc\/rc.d\/init.d\/mysqld
#datadir=\/var\/lib\/mysql\u3000\u3000\u3000
datadir=\/data\/mysql\u3000\u3000 \/\/\u6307\u5b9a\u5be6\u969b\u5b58\u653e\u7684\u8def\u5f91\u3000
5
restart mysql service <\/strong>
\/etc\/rc.d\/init.d\/mysqld\u3000start
\u82e5\u904b\u4f5c\u6b63\u5e38\u5247\u79fb\u52d5\u6210\u529f\u3000
ps
\u82e5\u6709\u4f7f\u7528phpmyadmin,\u9700\u4fee\u6539conf.inc.php\u4e2d\u7684socket\u8def\u5f91,\u4e26\u91cd\u65b0\u555f\u52d5\u7db2\u9801\u4f3a\u670d\u5668
vi \/etc\/conf.inc.php
$cfg[‘Servers’][$i][‘socket’] = ‘\/data\/mysql\/mysql.sock’;
ps
\u82e5\u6709\u767c\u751f\u627e\u4e0d\u5230mysql\u7684socket\u4e4b\u985e\u76f8\u95dc\u8a0a\u606f,\u53ef\u76f4\u63a5\u5c07\u820a\u7684mysql.sock\u5c0e\u5f15\u5230\u65b0\u7684\u8def\u5f91,\u5982\u4e0b
ln -s \/network\/mysql\/mysql.sock \/var\/lib\/mysql\/mysql.sock <\/p>\n","protected":false},"excerpt":{"rendered":"