亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql ; X8 j6 w: n# { H# q: @3 a
交芸蒂摰鋆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嚗交憭靘鞈湔隞嗅靘甈∪貉
! e# Z# G5 L1 m5 q& v: f) k/ Y, @亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql*
- j: s2 r1 K7 N+ U5 i' Q, {' v雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient " Q& U1 {4 C# H6 n' o9 K
憒頛詨 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
! `$ d0 }* d- i( d! }! h- ?# k+ k閮剖 /etc/my.cnf" u* Y! U& Z p( f7 h+ q' B6 d$ Y1 m0 ~3 o
[mysqld]
. ` H' W1 t& q9 l! c1 p( C2 Rdatadir=/var/lib/mysql
& [% k0 W! L. esocket=/var/lib/mysql/mysql.sock* A6 K* j- h. [& Y8 D0 E( S' v3 w. V/ o
# Default to using old password format for compatibility with mysql 3.x
' M8 |4 q1 z2 t2 p5 O+ J* B# clients (those using the mysqlclient10 compatibility package).
- k4 M, @' _( F8 Y$ fold_passwords=1$ d/ {! F& }, `) q0 a: j
default-character-set = utf8: C) h) `& G7 |% i+ S
, D' `0 E" N: W; X[mysql.server], R% x$ S2 _; i/ e6 ]
user=mysql
, ^, v, l0 Z6 g5 Z9 g( w0 }' v" Pbasedir=/var/lib0 u5 n) ]% L$ s2 {/ O
) G3 w; r3 ~1 f' N J[mysqld_safe]: Y& Q$ h: |& w" n: h
log-error=/var/log/mysqld.log
+ h0 D3 Q* N7 }$ J) ~+ j$ }pid-file=/var/run/mysqld/mysqld.pid
J& H$ k% i) g" Q+ Y/ ]# G
4 O7 m! A6 T9 l) E5 K[mysql]
1 ^3 |& I& U$ E$ gdefault-character-set = utf8
$ n+ G. ~$ [: ^- {! | 閮剖 MySQL 函頂蝯曹韏瑕1 t: n9 o6 {( {# E8 k& [) m
# chkconfig mysqld on
5 e7 W( Y C; K7 B) x Q& E+ @0 R! U* g* k; a4 w% a, R
蝣箄 MySQL 芸
8 [) }7 m; \. f) ^( y # chkconfig --list mysqld
, ^! } @5 N1 t7 M# J 憒2--5榣n撠屠K
: E" P4 k% Q7 M1 m( l+ L' j mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off3 V: r9 _( x* R" Y! Z W
MySQL
. a' _1 O) A i5 ? # 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
5 m" J/ d1 d' O. Y
MySQL 隞亙嚗敹閮剖 root 撖蝣
8 e8 D0 x: 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 頛詨亙蝣 1 \3 i1 u- A$ U% x( q+ [
[啣鋆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/鞈摨,甇日撱箇DB5 J" ?# ?# l% D C. `
mysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB
8 x/ \1 R8 e& O. O) W7 }$ P
. e! N0 h8 i+ [5 W
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |