|
亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql
A4 f+ U# X4 R e+ a1 t交芸蒂摰鋆mysql嚗憒雿貉蝸CentOS蝟餌芸蒂mysql鞈摨恬 mysql-libs.x86_64 5.1.73-5.el6_6 @anaconda-CentOS-201508042137.x86_64/6.7 yum -y remove mysql-libs.x86_64嚗交憭靘鞈湔隞嗅靘甈∪貉 ) z& O; P' C. b& W1 a# U$ N
亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql* # @0 p1 x# a' |! { W' L5 b j
雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient
: Z, f' ?: ?8 T- t8 Z" F2 E. X憒頛詨 mysql 箇 error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 銵函內芸 mysqld 隞亥撓 service mysqld start,敺擐砌箇曆誑銝閮,雿銝鈭函閮: - To start mysqld at boot time you have to copy
- support-files/mysql.server to the right place for your system
- PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
- To do so, start the server, then issue the following commands:
- /usr/bin/mysqladmin -u root password 'new-password'
- /usr/bin/mysqladmin -u root -h video.yocoolnet.com password 'new-password'
- Alternatively you can run:
- /usr/bin/mysql_secure_installation
- which will also give you the option of removing the test
- databases and anonymous user created by default. This is
- strongly recommended for production servers.
- See the manual for more instructions.
- You can start the MySQL daemon with:
- cd /usr ; /usr/bin/mysqld_safe &
- You can test the MySQL daemon with mysql-test-run.pl
- cd /usr/mysql-test ; perl mysql-test-run.pl
亦摰鋆mysql唳桀砌縑: rpm -qi mysql-server d5 T: i" D; o# p; @1 w6 [5 }
閮剖 /etc/my.cnf
9 k; S3 ]; m# L% h; L0 X& t [mysqld]% u* r: g% ~# M& @
datadir=/var/lib/mysql/ E8 W2 F/ ?6 s' B& M {9 f
socket=/var/lib/mysql/mysql.sock1 d2 Q2 f. H! \8 k* G( n4 Y D
# Default to using old password format for compatibility with mysql 3.x/ t! t$ {! e2 x; E& T8 H" X2 `( @
# clients (those using the mysqlclient10 compatibility package).1 H6 A x* `" |0 K/ @/ `
old_passwords=1% i; V- X! }7 I2 g
default-character-set = utf85 i7 [& g" J2 b( k$ u- \9 R' P
" i, d* c# C; b5 j# H
[mysql.server]
! |3 x5 W' c9 c. Vuser=mysql, M1 D3 \) Y3 L" t# R: o$ E: T) O
basedir=/var/lib
. N8 o d/ B) D5 d: s; z* ] U8 c. u" `
[mysqld_safe]
% i D2 c* p& \4 b( [( Mlog-error=/var/log/mysqld.log6 m2 |+ s; G9 E
pid-file=/var/run/mysqld/mysqld.pid
7 M: i: E$ _9 C0 p$ c! ]2 e- g' B( h: D
[mysql]2 @# @. A8 S% F$ v, ~% R3 M
default-character-set = utf8( F: ]1 O' Z' U9 I, m. \
閮剖 MySQL 函頂蝯曹韏瑕
% K5 A e4 z. k* S$ @, X# W" L# chkconfig mysqld on5 t- W7 t1 _! a! Z o k
" O6 t4 V3 n0 x9 ~蝣箄 MySQL 芸
6 ?3 P, T( ]+ \! `0 w. ?, `/ e # chkconfig --list mysqld! N' t3 z: i. F* m
憒2--5榣n撠屠K0 ]5 Y0 [/ D8 I3 r( [. y* y% J
mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off& ^# C; i# G6 k$ ~
MySQL $ ~ |, ^( @) X# f
# service mysqld start /usr/bin/mysqld_safe & 蝣箄 MySQL 臬血歇 #service mysqld status mysqld (pid 33778) is running... cd /usr/mysql-test ; perl mysql-test-run.pl . i3 k( m* F- n! `$ Z2 x, |
MySQL 隞亙嚗敹閮剖 root 撖蝣
$ G& A3 o$ S2 Z$ D+ f/ K% @2 Z1 W # mysqladmin -u root password 'Your Password' 瑁隞 # /usr/bin/mysql_secure_installation 閰 root 臬血舀餃 mysql: mysql -u root -p Enter password: (頛詨叵oot 撖蝣) 蝝 MySQL database單 # mysql_upgrade -u root -p 頛詨亙蝣 ( x( V5 d2 m% g, |- ?. o
[啣鋆mysql] http://tecadmin.net/remove-mysql-completely-from-linux-system/ 閮: 隞句um摰鋆每entOS 5.11/i386 箇暸航炊,see /var/log/mysqld.log : 160414 10:07:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160414 10:07:57 [Note] /usr/libexec/mysqld (mysqld 5.5.49) starting as process 9426 ... 160414 10:07:57 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 160414 10:07:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 160414 10:07:57 InnoDB: The InnoDB memory heap is disabled 160414 10:07:57 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 160414 10:07:57 InnoDB: Compressed tables use zlib 1.2.3 160414 10:07:57 InnoDB: Using Linux native AIO 160414 10:07:57 InnoDB: Initializing buffer pool, size = 128.0M 160414 10:07:57 InnoDB: Completed initialization of buffer pool 160414 10:07:57 InnoDB: highest supported file format is Barracuda. 160414 10:07:57 InnoDB: Waiting for the background threads to start 160414 10:07:58 InnoDB: 5.5.49 started; log sequence number 1595675 160414 10:07:58 InnoDB: !!! innodb_force_recovery is set to 1 !!! 160414 10:07:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 160414 10:07:58 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 160414 10:07:58 [Note] Server socket created on IP: '0.0.0.0'. 160414 10:07:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist :mysqld⊥芸撱箇 /var/lib/mysql/鞈摨,甇日撱箇DB
( e" |) ^0 P! p3 s$ D1 M3 _mysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB9 M2 `0 ], T& C" O' X. M
7 g, {# b6 p* C/ z4 y& H
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |
潸” 2015-10-30 17:31:21
嗉
鈭
霈
