一、安装
1、去官网查看最新安装包
https://dev.mysql.com/downloads/repo/yum/
2、下载MySQL源安装包
http://test.hexin.cn/software/mysql-5.7.9.tar.gz
http://test.hexin.cn/software/cmake-3.4.0.tar.gz
http://test.hexin.cn/software/boost_1_59_0.tar.gz
3、进行mysql的安装
可以通过# yum list | grep mysql命令查看yum上提供的MySQL数据库可下载的版本。
2
3
2
3
可以看到yum服务器上MySQL的可以下载的版本信息：
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
44
45
2[root@instance-rrkkmshy ~]# yun list | grep mysql
3-bash: yun: command not found
4[root@instance-rrkkmshy ~]# yum list | grep mysql
5akonadi-mysql.x86_64 1.9.2-4.el7 base
6apr-util-mysql.x86_64 1.5.2-6.el7 base
7calligra-kexi-driver-mysql.x86_64 2.9.10-2.el7 epel
8collectd-mysql.x86_64 5.8.1-1.el7 epel
9dmlite-plugins-mysql.x86_64 1.13.2-2.el7 epel
10dovecot-mysql.x86_64 1:2.2.36-3.el7_7.1 updates
11dpm-copy-server-mysql.x86_64 1.13.0-1.el7 epel
12dpm-name-server-mysql.x86_64 1.13.0-1.el7 epel
13dpm-server-mysql.x86_64 1.13.0-1.el7 epel
14dpm-srm-server-mysql.x86_64 1.13.0-1.el7 epel
15dspam-mysql.x86_64 3.10.2-12.el7 epel
16exim-mysql.x86_64 4.92.3-1.el7 epel
17freeradius-mysql.x86_64 3.0.13-10.el7_6 base
18fts-mysql.x86_64 3.8.4-2.el7 epel
19gnokii-smsd-mysql.x86_64 0.6.31-17.el7 epel
20holland-mysql.noarch 1.1.18-1.el7 epel
21holland-mysqldump.noarch 1.1.18-1.el7 epel
22holland-mysqllvm.noarch 1.1.18-1.el7 epel
23lfc-server-mysql.x86_64 1.13.0-1.el7 epel
24libdbi-dbd-mysql.x86_64 0.8.3-16.el7 base
25libgda-mysql.x86_64 1:5.2.2-7.el7 epel
26libnss-mysql.x86_64 1.5-19.el7 epel
27libodb-mysql.x86_64 2.3.0-1.el7 epel
28libodb-mysql-devel.x86_64 2.3.0-1.el7 epel
29lighttpd-mod_authn_mysql.x86_64 1.4.54-1.el7 epel
30lighttpd-mod_mysql_vhost.x86_64 1.4.54-1.el7 epel
31mysql++.x86_64 3.1.0-12.el7 epel
32mysql++-devel.x86_64 3.1.0-12.el7 epel
33mysql++-manuals.x86_64 3.1.0-12.el7 epel
34mysql-connector-java.noarch 1:5.1.25-3.el7 base
35mysql-connector-odbc.x86_64 5.2.5-8.el7 base
36mysql-connector-python.noarch 1.1.6-1.el7 epel
37mysql-mmm.noarch 2.2.1-15.el7 epel
38mysql-mmm-agent.noarch 2.2.1-15.el7 epel
39mysql-mmm-monitor.noarch 2.2.1-15.el7 epel
40mysql-mmm-tools.noarch 2.2.1-15.el7 epel
41mysql-proxy.x86_64 0.8.5-2.el7 epel
42mysql-proxy-devel.x86_64 0.8.5-2.el7 epel
43
44
45
通过yum install -y mysql-server mysql mysql-devel命令进行安装
2
3
2
3
4.mysql数据库的初始化及相关配置
1、MySQL的启动（如果我们是第一次启动mysql服务，mysql服务器首先会进行初始化的配置）
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
2初始化 MySQL 数据库： WARNING: The host 'xiaoluo' could not be looked up with resolveip.
3This probably means that your libc libraries are not 100 % compatible
4with this binary MySQL version. The MySQL daemon, mysqld, should work
5normally with the exception that host name resolving will not work.
6This means that you should use IP addresses instead of hostnames
7when specifying MySQL privileges !
8Installing MySQL system tables...
9OK
10Filling help tables...
11OK
12
13To start mysqld at boot time you have to copy
14support-files/mysql.server to the right place for your system
15
16PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
17To do so, start the server, then issue the following commands:
18
19/usr/bin/mysqladmin -u root password 'new-password'
20/usr/bin/mysqladmin -u root -h xiaoluo password 'new-password'
21
22Alternatively you can run:
23/usr/bin/mysql_secure_installation
24
25which will also give you the option of removing the test
26databases and anonymous user created by default. This is
27strongly recommended for production servers.
28
29See the manual for more instructions.
30
31You can start the MySQL daemon with:
32cd /usr ; /usr/bin/mysqld_safe &
33
34You can test the MySQL daemon with mysql-test-run.pl
35cd /usr/mysql-test ; perl mysql-test-run.pl
36
37Please report any problems with the /usr/bin/mysqlbug script![确定]
38正在启动 mysqld： [确定]
39
40
2、这时我们会看到第一次启动mysql服务器以后会提示非常多的信息，目的就是对mysql数据库进行初始化操作。然后我们重新启动后mysql
2
3
4
5
2停止 mysqld： [确定]
3正在启动 mysqld： [确定]
4
5
3、MySQL并没有开机开机自动启动，我们当然可以通过 chkconfig mysqld on 命令来将其设置成开机启动，这样就不用每次都去手动启动了
2
3
4
5
2[root@instance-rrkkmshy ~]# chkconfig --list | grep mysql
3mysqld 0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭
4
5
4、MySQL数据库安装完以后只会有一个root管理员账号，但是此时的root账号还并没有为其设置密码，在第一次启动MySQL服务时，会进行数据库的一些初始化工作，所以我们可以通过 该命令来给我们的root账号设置密码。
为root账号设置密码
2
3
2
3
通过该命令给root账号设置密码为 root
2
3
2
3
5、这时我们就可以通过 mysql -u root -p 命令来登录我们的mysql数据库了
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
2Enter password:
3Welcome to the MySQL monitor. Commands end with ; or \g.
4Your MySQL connection id is 4
5Server version: 5.5.36 MySQL Community Server (GPL)
6
7Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
8
9Oracle is a registered trademark of Oracle Corporation and/or its
10affiliates. Other names may be trademarks of their respective
11owners.
12
13Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
14
15mysql> show databases;
16+--------------------+
17| Database |
18+--------------------+
19| information_schema |
20| mysql |
21| performance_schema |
22| test |
23+--------------------+
244 rows in set (0.00 sec)
25
26mysql>
27
28
二、修改root密码的4种方法
方法1
： 用SET PASSWORD命令
mysql -u root
mysql> SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘newpass’);
方法2：用mysqladmin
mysqladmin -u root password “newpass”
如果root已经设置过密码，采用如下方法
mysqladmin -u root password oldpass “newpass”
方法,3： 用UPDATE直接编辑user表
mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD(‘newpass’) WHERE user = ‘root’;
mysql> FLUSH PRIVILEGES;
方法4，在丢失root密码的时候，可以这样
mysqld_safe –skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD(“new password”) WHERE user=‘root’;
mysql> FLUSH PRIVILEGES;。
三、MySQL的备份与还原
MySQL备份和还原,都是利用mysqldump、mysql和source命令来完成的。
1.Win32下MySQL的备份与还原
1.1 备份
开始菜单 | 运行 | cmd |利用“cd /Program Files/MySQL/MySQL Server 5.0/bin”命令进入bin文件夹 | 利用“mysqldump -u 用户名 -p databasename >exportfilename”导出数据库到文件，如mysqldump -u root -p voice>voice.sql，然后输入密码即可开始导出。
1.2 还原
进入MySQL Command Line Client，输入密码，进入到“mysql>”，输入命令"show databases；"，回车，看看有些什么数据库；建立你要还原的数据库，输入"create database voice；"，回车；切换到刚建立的数据库，输入"use voice；"，回车；导入数据，输入"source voice.sql；"，回车，开始导入，再次出现"mysql>"并且没有提示错误即还原成功。
