centos 6.4 mysql 5.6_CentOS6.4 Install MySQL 5.6.45

下载源码包

解压并拷贝到/usr/local

tar -xvf mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.6.26-linux-glibc2.5-x86_64 mysql

sudo mv mysql /usr/local/mysql

创建用户和用户组

groupadd mysql

useradd -r -g mysql mysql

# 账号mysql 组mysql 密码mysql

# 给账号创建密码的方法

passwd 输入用户名

# 输入密码

改变目录权限

chown -R mysql:mysql *

╭─Mysticbinary@CentOSv64 /usr/local/mysql

╰─$ sudo chown -R mysql:mysql * 9 ↵

╭─Mysticbinary@CentOSv64 /usr/local/mysql

╰─$ ll

total 68K

drwxrwxr-x. 2 mysql mysql 4.0K Aug 8 15:11 bin

-rw-r--r--. 1 mysql mysql 18K Jun 10 18:25 COPYING

drwxrwxr-x. 3 mysql mysql 4.0K Aug 8 15:11 data

drwxrwxr-x. 2 mysql mysql 4.0K Aug 8 15:11 docs

drwxrwxr-x. 3 mysql mysql 4.0K Aug 8 15:11 include

drwxrwxr-x. 3 mysql mysql 4.0K Aug 8 15:11 lib

drwxrwxr-x. 4 mysql mysql 4.0K Aug 8 15:11 man

drwxrwxr-x. 10 mysql mysql 4.0K Aug 8 15:11 mysql-test

-rw-r--r--. 1 mysql mysql 2.5K Jun 10 18:25 README

drwxrwxr-x. 2 mysql mysql 4.0K Aug 8 15:11 scripts

drwxrwxr-x. 28 mysql mysql 4.0K Aug 8 15:11 share

drwxrwxr-x. 4 mysql mysql 4.0K Aug 8 15:11 sql-bench

drwxrwxr-x. 2 mysql mysql 4.0K Aug 8 15:11 support-files

安装

最好使用默认的/uer/local/mysql安装路径。我之前改过安装目录，导致报错太多，一个个处理真有点浪费时间的。

先了解安装的参数：

用法：/ usr / local / mysql / bin / mysql_install_db [OPTIONS]

--basedir = path MySQL安装目录的路径。

--cross-bootstrap供内部使用。在构建MySQL系统时使用

与目标不同的主机上的表。

--datadir = path MySQL数据目录的路径。

--force即使DNS没有，也会使mysql_install_db运行

工作。在这种情况下，通常授予表条目

使用主机名将使用IP地址。

--ldata = path MySQL数据目录的路径。

--rpm供内部使用。 RPM文件使用此选项

在MySQL安装过程中。

--skip-name-resolve创建时使用IP地址而不是主机名

授予表条目。如果，此选项非常有用

你的DNS不起作用。

--srcdir = path供内部使用。目录下的

mysql_install_db查找支持文件，如

错误消息文件和用于popoulating的文件

帮助表。

--user = user_name用于运行mysqld的登录用户名。

由mysqld创建的目录将由此拥有

用户。您必须是root才能使用此选项。默认情况下

mysqld使用您当前的登录名和文件运行

它创建的目录将归您所有。

所有其他选项都传递给mysqld程序

启动安装命令

./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

╭─Mysticbinary@CentOSv64 /usr/local/mysql

╰─$ ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

WARNING: The host 'CentOSv64' could not be looked up with /usr/local/mysql/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 !

Installing MySQL system tables...2019-08-08 15:33:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2019-08-08 15:33:18 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.

2019-08-08 15:33:18 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.45) starting as process 5975 ...

2019-08-08 15:33:18 5975 [Warning] Can't create test file /usr/local/mysql/data/CentOSv64.lower-test

2019-08-08 15:33:18 5975 [Warning] Can't create test file /usr/local/mysql/data/CentOSv64.lower-test

2019-08-08 15:33:18 5975 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2019-08-08 15:33:18 5975 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2019-08-08 15:33:18 5975 [Note] InnoDB: Using atomics to ref count buffer pool pages

2019-08-08 15:33:18 5975 [Note] InnoDB: The InnoDB memory heap is disabled

2019-08-08 15:33:18 5975 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-08-08 15:33:18 5975 [Note] InnoDB: Memory barrier is not used

2019-08-08 15:33:18 5975 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-08-08 15:33:18 5975 [Note] InnoDB: Using Linux native AIO

2019-08-08 15:33:18 5975 [Note] InnoDB: Using CPU crc32 instructions

2019-08-08 15:33:18 5975 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2019-08-08 15:33:18 5975 [Note] InnoDB: Completed initialization of buffer pool

2019-08-08 15:33:18 7fbde70ed720 InnoDB: Operating system error number 13 in a file operation.

InnoDB: The error means mysqld does not have the access rights to

InnoDB: the directory.

2019-08-08 15:33:18 7fbde70ed720 InnoDB: Operating system error number 13 in a file operation.

InnoDB: The error means mysqld does not have the access rights to

InnoDB: the directory.

# 报错了！

2019-08-08 15:33:18 5975 [ERROR] InnoDB: Creating or opening ./ibdata1 failed!

2019-08-08 15:33:18 5975 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!

2019-08-08 15:33:18 5975 [ERROR] Plugin 'InnoDB' init function returned error.

2019-08-08 15:33:18 5975 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2019-08-08 15:33:18 5975 [ERROR] Unknown/unsupported storage engine: InnoDB

2019-08-08 15:33:18 5975 [ERROR] Aborting

2019-08-08 15:33:18 5975 [Note] Binlog end

2019-08-08 15:33:18 5975 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

解决：

发现是没有加sudo,没有权限导致的，加上就搞定了；

╭─Mysticbinary@CentOSv64 /usr/local/mysql

╰─$ sudo ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

# ......

2019-08-08 15:54:51 6263 [Note] Binlog end

2019-08-08 15:54:51 6263 [Note] InnoDB: FTS optimize thread exiting.

2019-08-08 15:54:51 6263 [Note] InnoDB: Starting shutdown...

2019-08-08 15:54:53 6263 [Note] InnoDB: Shutdown completed; log sequence number 1625987

OK

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/local/mysql/bin/mysqladmin -u root password 'new-password'

/usr/local/mysql/bin/mysqladmin -u root -h CentOSv64 password 'new-password'

Alternatively you can run:

/usr/local/mysql/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/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

WARNING: Found existing config file /usr/local/mysql/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 /usr/local/mysql/my-new.cnf,

please compare it with your file and take the changes you need.

启动

sudo ./bin/mysqld & # 启动

sudo ./bin/mysqld_safe & # 安全模式启动

# mysql还有其他启动方式，这里不做过多研究，能启动就行；

The Difference Between mysqld and sqld_safe

人们会纠结mysqld与mysqld_safe的区别. 其实mysqld_safe是一个脚本，一个非常安全的启动、关闭MySQL服务的脚本。它实际上也是调用mysqld来启动、关闭MySQL服务。

关于mysqld_safe，可以参考官方文档 mysqld_safe — MySQL Server Startup Script。

添加mysql为系统服务

sudo cp support-files/mysql.server /etc/init.d/mysql

之后就可以使用/etc/init.d/mysql start|stop|restart来管理mysql了

添加环境变量

sudo vi /etc/profile

#修改PATH=$PATH:/usr/local/mysql/bin

source /etc/profile

# 重新加载profile

添加环境变量之后即可任意目录下直接输入mysql进行连接而不用在mysql/bin目录下了。

创建mysql用户

# 如给root添加密码

mysqladmin -u root password "you new password"

#添加新用户

mysql -u root -p

#name处用用户替换，passwd处用密码替换

mysql> GRANT USAGE ON *.* TO 'name'@'localhost' IDENTIFIED BY 'passwd' WITH GRANT OPTION;

连接mysql

mysql -uroot -p

#密码 root