|
亦CentOS芸蒂mysql臬血歇摰鋆: yum list installed | grep mysql * n" q/ @2 x2 a% }/ R
交芸蒂摰鋆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嚗交憭靘鞈湔隞嗅靘甈∪貉 0 L+ T+ f+ M: d; c8 R# m7 n
亦yum摨思mysql砌縑: yum list | grep mysql yum -y list mysql*
7 H3 L1 V# T& }% ^5 X0 k: V, E0 A* `& V雿輻肘um摰鋆mysql鞈摨: yum -y install mysql-server mysql mysql-devel 瘜剁摰鋆mysql芣臬鋆鈭鞈摨嚗芣摰鋆mysql-server貊嗡摰鋆鈭serverclient
8 X6 |3 r7 [' E2 _2 O/ ]! e憒頛詨 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 ^$ Y" {# r( u$ `! I" }
閮剖 /etc/my.cnf: l( ?* ~- ^4 O3 S
[mysqld]
& E& A4 D0 N6 e' g3 Z; _) bdatadir=/var/lib/mysql4 Y, C' c2 G7 b. e5 { [2 Z8 l
socket=/var/lib/mysql/mysql.sock
: _) Z7 _6 ^# l# Default to using old password format for compatibility with mysql 3.x8 V: j0 S5 L7 _9 ]3 J
# clients (those using the mysqlclient10 compatibility package).
) b3 ], f0 ]4 R4 ^& f" L, Bold_passwords=1
6 S% G' Y. z" Zdefault-character-set = utf8+ k. a* u0 R' I0 @) W% x j) T" f! c
5 r. f' o1 l6 @, A( h5 @. m: H[mysql.server]
% b2 g4 d* V' Y" H% K% H( quser=mysql7 y: [6 I8 a5 v) U8 M) @) U1 L
basedir=/var/lib
4 `% L; P( a* A+ [- c E F: S# X
[mysqld_safe]
+ y( `* K5 x0 w2 d, f4 {/ H+ Ulog-error=/var/log/mysqld.log7 o& ^& S4 ~ u2 s5 Y6 a8 ]
pid-file=/var/run/mysqld/mysqld.pid
Y/ [0 ]+ O+ Q% L4 A- ?) T& [5 { W5 ]! l7 m
[mysql]2 p! A& |4 \1 g' I
default-character-set = utf87 T( \4 U6 n8 O9 x& m3 l# t" Q% U
閮剖 MySQL 函頂蝯曹韏瑕* F6 o2 R) m6 ^" O
# chkconfig mysqld on* Y I9 [7 h6 U9 E3 q( Q. n% l( ^
* D/ |6 y2 D# r* L& R1 @蝣箄 MySQL 芸! G/ b# L+ ]. m0 s/ @2 T0 }
# chkconfig --list mysqld/ O; l3 {1 ?& s; b4 D3 f
憒2--5榣n撠屠K
R% R1 r" m7 A2 c+ Y6 e mysqld 0: off 1: off 2: on 3: on 4: on 5: on 6: off5 ]& E5 O' D; ^
MySQL ; |" p! z$ O3 i; b4 Q: _; z7 w
# 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 q, b! t6 Y/ L( W u1 i& h
MySQL 隞亙嚗敹閮剖 root 撖蝣
7 G" n) Y, H2 u1 U/ ]1 r& [% \ # 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 頛詨亙蝣
7 ^/ ^8 |' e7 x9 c9 O; G
[啣鋆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
# I9 X# k- b9 D# vmysql_install_db --user=mysql --ldata=/var/lib/mysql/ ===>check /var/lib/mysql/批歇撱箇閮勗DB7 ~7 f$ Y( g* O) Y- B9 [
, `; K; I0 @& m; C( t6 v
蝝啁: https://www.cadch.com/modules/news/article.php?storyid=227 |
潸” 2015-10-30 17:31:21
嗉
鈭
霈
