Linux MySql5.6.38安装过程详解数据库

[[email protected] ~]# cd / 
[[email protected] /]# ls 
bin dev home lib64 media opt root selinux sys usr 
boot etc lib lost+found mnt proc sbin srv tmp var 
[[email protected] /]# mkdir soft

[[email protected] soft]# tar ‐zxvf mysql‐5.6.38‐linux‐glibc2.12‐x86_64.tar.gz

[[email protected] soft]# ls 
mysql‐5.6.38‐linux‐glibc2.12‐x86_64 mysql‐5.6.38‐linux‐glibc2.12‐x86_64.tar.gz 
[[email protected] soft]# rm ‐rf mysql‐5.6.38‐linux‐glibc2.12‐x86_64.tar.gz 
[[email protected] soft]# mv mysql‐5.6.38‐linux‐glibc2.12‐x86_64/ mysql

[[email protected] soft]# rpm ‐qa|grep mysql 
mysql‐libs‐5.1.73‐5.el6_6.x86_64

[[email protected] soft]# rpm ‐e ‐‐nodeps mysql‐libs‐5.1.73‐5.el6_6.x86_64 
[[email protected] soft]# rpm ‐qa|grep mysql 
[[email protected] soft]#

[[email protected] soft]# groups mysql 
groups: mysql：无此用户

[[email protected] soft]# groupadd mysql 
[[email protected] soft]# useradd ‐r ‐g mysql mysql

[[email protected] soft]# mv mysql/ /usr/local/

[[email protected] soft]# cd /usr/local/ 
[[email protected] local]# chown ‐R mysql:mysql mysql 
[[email protected] local]# ll 
总用量 44 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 bin 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 etc 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 games 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 include 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 lib 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 lib64 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 libexec 
drwxr‐xr‐x. 13 mysql mysql 4096 1月 16 04:04 mysql 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 sbin 
drwxr‐xr‐x. 5 root root 4096 1月 16 02:15 share 
drwxr‐xr‐x. 2 root root 4096 9月 23 2011 src 
[[email protected] local]#

[[email protected] scripts]# vi /etc/hosts

192.168.1.110 master 
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

[[email protected] scripts]# ./mysql_install_db ‐‐basedir=/usr/local/mysql ‐‐ 
datadir=/usr/local/mysql/data ‐‐user=mysql ‐‐explicit_defaults_for_timestamp

1、数据初始化‐主机名解析错误 
系统‐Red Hat Enterprise Linux Server release 6.6 
软件‐源码安装mysql‐5.6.27.tar.gz 
环境‐Linux rhel6.myexample.com 2.6.32‐504.el6.x86_64 #1 SMP Tue Sep 16 01:56:35 EDT 2014 x86_64 
x86_64 x86_64 GNU/Linux 
报错：WARNING 
[[email protected] mysql]# scripts/mysql_install_db ‐‐user=mysql 
WARNING: The host 'rhel6.myexample.com' could not be looked up with ./bin/resolveip. 
This probably means that your libc libraries are not 100 % compatible 
with this binary MySQL version. The MySQL daemon, mysqld, should work 
normally with the exception that host name resolving will not work. 
This means that you should use IP addresses instead of hostnames 
when specifying MySQL privileges ! 
原因：主机名解析错误。 
解决：hosts文件中添加如下内容，ok！ 
[[email protected] mysql]# vi /etc/hosts 
192.168.56.20 rhel6.myexample.com 
总结： 
因为lib库不是很兼容当前MySQL版本。在主机名解析不起作用的情况下，会引起MySQL守护进程、mysqld工作异常，因 
此在MySQL中授权时需要使用IP地址，而不能使用主机名。 
（不解决该问题，依然可以正确执行scripts/mysql_install_db数据库初始化脚本。） 
2、数据初始化‐时间戳问题 
系统‐Red Hat Enterprise Linux Server release 6.6 
软件‐源码安装mysql‐5.6.27.tar.gz 
环境‐Linux rhel6.myexample.com 2.6.32‐504.el6.x86_64 #1 SMP Tue Sep 16 01:56:35 EDT 2014 x86_64 
x86_64 x86_64 GNU/Linux 
报错：Warning 
[[email protected] mysql]# scripts/mysql_install_db ‐‐user=mysql 
Installing MySQL system tables...2015‐11‐04 07:46:37 0 [Warning] TIMESTAMP with implicit DEFAULT 
value is deprecated. Please use ‐‐explicit_defaults_for_timestamp server option (see 
documentation for more details). 
2015‐11‐04 07:46:37 0 [Note] ./bin/mysqld (mysqld 5.6.27) starting as process 2867 ... 
原因：机器的系统时间与TIMESTAMP时间戳不匹配。 
解决：执行mysql_install_db数据初始化脚本时添加explicit_defaults_for_timestamp选项。 
[[email protected] mysql]# scripts/mysql_install_db ‐‐user=mysql ‐‐explicit_defaults_for_timestamp 
3、数据初始化‐重复安装引起多个配置文件，默认配置文件 
系统‐Red Hat Enterprise Linux Server release 6.6 
软件‐源码安装mysql‐5.6.27.tar.gz 
环境‐Linux rhel6.myexample.com 2.6.32‐504.el6.x86_64 #1 SMP Tue Sep 16 01:56:35 EDT 2014 x86_64 
x86_64 x86_64 GNU/Linux 
报错：Warning 
WARNING: Found existing config file ./my.cnf on the system. 
Because this file might be in use, it was not replaced, 
but was used in bootstrap (unless you used ‐‐defaults‐file) 
and when you later start the server. 
The new default config file was created as ./my‐new.cnf, 
please compare it with your file and take the changes you need. 
WARNING: Default config file /etc/my.cnf exists on the system 
This file will be read by default by the MySQL server 
If you do not want to use this, either remove it, or use the 
‐‐defaults‐file argument to mysqld_safe when starting the server 
原因： 
Warning1是因为重复安装，导致在安装目录下已经存在my.cnf文件。 
Warning2是指默认的my.cnf配置文件在/etc/目录下。 
启动Mysql server时，可指定‐‐default‐file=/path/my.cnf参数来启动mysql服务。

[[email protected] scripts]# cd .. 
[[email protected] mysql]# chown ‐R mysql:mysql data

/usr/local/mysql/bin/mysqladmin ‐u root password 'new‐password' 
/usr/local/mysql/bin/mysqladmin ‐u root ‐h master password 'new‐password'

[[email protected] bin]# ./mysqladmin ‐u root password 'root'

[[email protected] bin]# ./mysqladmin ‐u root password 'root' 
./mysqladmin: connect to server at 'localhost' failed 
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' 
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! 
[[email protected] bin]#

[[email protected] mysql]# cd support‐files/ 
[[email protected] support‐files]# ls 
binary‐configure magic my‐default.cnf mysqld_multi.server mysql‐log‐rotate mysql.server 
[[email protected] support‐files]# ./mysql.server start 
Starting MySQL.Logging to '/usr/local/mysql/data/master.err'. 
SUCCESS! 
[[email protected] support‐files]#

[[email protected] bin]# ./mysqladmin ‐u root password 'root' 
Warning: Using a password on the command line interface can be insecure. 
[[email protected] bin]#

[[email protected] bin]# ./mysql ‐uroot ‐p 
Enter password: 
Welcome to the MySQL monitor. Commands end with ; or /g. 
Your MySQL connection id is 4 
Server version: 5.6.38 MySQL Community Server (GPL) 
Copyright (c) 2000, 2017, 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>

update mysql.user set password=password('root') where user='root'; flush privileges;

mysql> update mysql.user set password=password('root') where user='root'; flush privileges; 
Query OK, 3 rows affected (0.00 sec) 
Rows matched: 4 Changed: 3 Warnings: 0 
Query OK, 0 rows affected (0.00 sec) 
mysql>

[[email protected] bin]# service iptables stop 
iptables：将链设置为政策 ACCEPT：filter [确定] 
iptables：清除防火墙规则： [确定] 
iptables：正在卸载模块： [确定] 
[[email protected] bin]#

D•Host '192.168.1.1' is not allowed to connect to 
遗失对主机的连接。 
C:/Users/Administrator>telnet 192.168.1.110 3306

mysql> grant all privileges on *.* to root@'%' identified by 'root'; 
Query OK, 0 rows affected (0.00 sec) 
mysql> flush privileges; 
Query OK, 0 rows affected (0.00 sec) 
mysql>

[[email protected] mysql]# cp support‐files/mysql.server /etc/init.d/mysqld 
[[email protected] mysql]# chkconfig ‐‐add mysqld 
[[email protected] mysql]# chkconfig mysqld on 
[[email protected] mysql]# service mysqld restart 
Shutting down MySQL.... SUCCESS! 
Starting MySQL. SUCCESS! 
[[email protected] mysql]#

[[email protected] mysql]# service mysqld status 
SUCCESS! MySQL running (21838) 
[[email protected] mysql]#

[[email protected] mysql]# vi my.cnf

[mysqld] 
# Remove leading # and set to the amount of RAM for the most important data 
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
# innodb_buffer_pool_size = 128M 
# Remove leading # to turn on a very important data integrity option: logging 
# changes to the binary log between backups. 
# log_bin 
default‐character‐set=utf8 
lower_case_table_names=1 
max_allowed_packet=100M 
# These are commonly set, remove the # and set as required. 
# basedir = ..... 
# datadir = ..... 
# port = ..... 
# server_id = ..... 
# socket = ..... 
# Remove leading # to set options mainly useful for reporting servers. 
# The server defaults are faster for transactions and fast SELECTs. 
# Adjust sizes as needed, experiment to find the optimal values. 
# join_buffer_size = 128M 
# sort_buffer_size = 2M 
# read_rnd_buffer_size = 2M

[[email protected] data]# service mysqld restart 
ERROR! MySQL server PID file could not be found! 
Starting MySQL... ERROR! The server quit without updating PID file 
(/usr/local/mysql/data/master.pid).

2018‐01‐16 04:49:52 22747 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'defaultcharacter‐ 
set=utf8' 
2018‐01‐16 04:49:52 22747 [ERROR] Aborting

[[email protected] mysql]# service mysqld restart 
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS! 
[[email protected] mysql]#