-
查看操作系统相关信息。
1
2
3
4
5
|
[root@bj_db1 ~]
# cat /etc/issue
CentOS release 6.5 (Final)
Kernel \r on an \m
[root@bj_db1 ~]
# uname -a
Linux bj_db1 2.6.32-431.el6.x86_64
#1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
|
1
|
[root@bj_db1 ~]
# mkdir -p /taokey/tools
|
1
2
3
4
5
|
[root@bj_db1 ~]
# rpm -qa | grep mysql
mysql-libs-5.1.71-1.el6.x86_64
[root@bj_db1 ~]
# yum -y remove mysql-libs-5.1*
[root@bj_db1 ~]
# rpm -qa | grep mysql
[root@bj_db1 ~]
#
|
1
2
3
4
5
6
7
|
MySQL-client-5.6.21-1.rhel5.x86_64.rpm
MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
MySQL-server-5.6.21-1.rhel5.x86_64.rpm
[root@bj_db1 ~]
# cd /taokey/tools/
[root@bj_db1 tools]
# wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.21-1.rhel5.x86_64.rpm
[root@bj_db1 tools]
# wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
[root@bj_db1 tools]
# wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.21-1.rhel5.x86_64.rpm
|
1
2
3
4
5
6
7
8
|
[root@bj_db1 tools]
# yum install -y libaio
[root@bj_db1 tools]
# rpm -ivh MySQL-server-5.6.21-1.rhel5.x86_64.rpm
[root@bj_db1 tools]
# rpm -ivh MySQL-client-5.6.21-1.rhel5.x86_64.rpm
Preparing...
########################################### [100%]
1:MySQL-client
########################################### [100%]
[root@bj_db1 tools]
# rpm -ivh MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
Preparing...
########################################### [100%]
1:MySQL-devel
########################################### [100%]
|
1
|
[root@bj_db1 tools]
# cp /usr/share/mysql/my-default.cnf /etc/my.cnf
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
[root@bj_db1 tools]
# /usr/bin/mysql_install_db
[root@bj_db1 tools]
# /etc/init.d/mysql start
[root@bj_db1 tools]
# ps -ef | grep mysql
root 2188 1 0 14:48 pts
/1
00:00:00
/bin/sh
/usr/bin/mysqld_safe
--datadir=
/var/lib/mysql
--pid-
file
=
/var/lib/mysql/bj_db1
.pid
mysql 2303 2188 30 14:48 pts
/1
00:00:02
/usr/sbin/mysqld
--basedir=
/usr
--datadir=
/var/lib/mysql
--plugin-
dir
=
/usr/lib64/mysql/plugin
--user=mysql --log-error=
/var/lib/mysql/bj_db1
.err --pid-
file
=
/var/lib/mysql/bj_db1
.pid
root 2331 1853 0 14:49 pts
/1
00:00:00
grep
mysql
[root@bj_db1 tools]
# netstat -anpt | grep 3306
tcp 0 0 :::3306 :::* LISTEN 2303
/mysqld
[root@bj_db1 tools]
# more /root/.mysql_secret
# The random password set for the root user at Thu Apr 9 14:43:59 2015 (local time): F6K3v_xggFoLQeiN
[root@bj_db1 tools]
# mysql -uroot -pF6K3v_xggFoLQeiN
Warning: Using a password on the
command
line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
id
is 1
Server version: 5.6.21
Copyright (c) 2000, 2014, Oracle and
/or
its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and
/or
its
affiliates. Other names may be trademarks of their respective
owners.
Type
'help;'
or
'\h'
for
help. Type
'\c'
to
clear
the current input statement.
mysql> SET PASSWORD = PASSWORD(
'123.com'
);
mysql>
exit
Bye
[root@bj_db1 tools]
# mysql -uroot -p123.com
Warning: Using a password on the
command
line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
id
is 6
Server version: 5.6.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and
/or
its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and
/or
its
affiliates. Other names may be trademarks of their respective
owners.
Type
'help;'
or
'\h'
for
help. Type
'\c'
to
clear
the current input statement.
mysql>
|
1
2
3
|
[root@bj_db1 tools]
# chkconfig mysql on
[root@bj_db1 tools]
# chkconfig mysql --list
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
|