首页 > 资讯 > 数据库 >安装mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz通用版

800

分享到

安装mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz通用版

2024-04-02 19:04:59 800人浏览薄情痞子

摘要

官网安装文档：https://dev.Mysql.com/doc/refman/5.6/en/binary-installation.html基础环境：Centos linux release 7.1.15

官网安装文档：

https://dev.Mysql.com/doc/refman/5.6/en/binary-installation.html

基础环境：

Centos linux release 7.1.1503 (Core)

一、添加mysql用户

[root@localhost local]# groupadd mysql

[root@localhost local]# useradd -r -g mysql -s /bin/false mysql

二、解压mysql，建立软链接

[root@localhost local]# cd /usr/local/

[root@localhost local]# tar -zxvf mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz -C /home/software/

软件默认的启动程序中，读取的是/usr/local/中的地址，所以不管在哪里安装，都在/usr/local中建个软链接比较好。

[root@localhost local]# ln -s /home/software/mysql-5.6.37-linux-glibc2.12-x86_64 mysql

三、添加环境变量

这是临时环境，如果多个窗口同时操作的话，需要都加上这个环境。

[root@localhost mysql]# export PATH=$PATH:/usr/local/mysql/bin

[root@localhost local]# cd mysql

[root@localhost mysql]# chown -R mysql:mysql .

这里全是root也可以的，看自己。

四、安装mysql

[root@localhost mysql]# scripts/mysql_install_db --user=mysql

Installing MySQL system tables...2017-09-21 09:30:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-09-21 09:30:16 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.

2017-09-21 09:30:16 0 [Note] ./bin/mysqld (mysqld 5.6.37) starting as process 3271 ...

2017-09-21 09:30:16 3271 [Note] InnoDB: Using atomics to ref count buffer pool pages

2017-09-21 09:30:16 3271 [Note] InnoDB: The InnoDB memory heap is disabled

2017-09-21 09:30:16 3271 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-09-21 09:30:16 3271 [Note] InnoDB: Memory barrier is not used

2017-09-21 09:30:16 3271 [Note] InnoDB: Compressed tables use zlib 1.2.3

2017-09-21 09:30:16 3271 [Note] InnoDB: Using Linux native AIO

2017-09-21 09:30:16 3271 [Note] InnoDB: Using CPU crc32 instructions

2017-09-21 09:30:16 3271 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2017-09-21 09:30:16 3271 [Note] InnoDB: Completed initialization of buffer pool

2017-09-21 09:30:17 3271 [Note] InnoDB: Highest supported file fORMat is Barracuda.

2017-09-21 09:30:17 3271 [Note] InnoDB: 128 rollback segment(s) are active.

2017-09-21 09:30:17 3271 [Note] InnoDB: Waiting for purge to start

2017-09-21 09:30:17 3271 [Note] InnoDB: 5.6.37 started; log sequence number 1625987

2017-09-21 09:30:17 3271 [Note] Binlog end

2017-09-21 09:30:17 3271 [Note] InnoDB: FTS optimize thread exiting.

2017-09-21 09:30:17 3271 [Note] InnoDB: Starting shutdown...

2017-09-21 09:30:18 3271 [Note] InnoDB: Shutdown completed; log sequence number 1625997

Filling help tables...2017-09-21 09:30:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-09-21 09:30:19 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.

2017-09-21 09:30:19 0 [Note] ./bin/mysqld (mysqld 5.6.37) starting as process 3294 ...

2017-09-21 09:30:19 3294 [Note] InnoDB: Using atomics to ref count buffer pool pages

2017-09-21 09:30:19 3294 [Note] InnoDB: The InnoDB memory heap is disabled

2017-09-21 09:30:19 3294 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-09-21 09:30:19 3294 [Note] InnoDB: Memory barrier is not used

2017-09-21 09:30:19 3294 [Note] InnoDB: Compressed tables use zlib 1.2.3

2017-09-21 09:30:19 3294 [Note] InnoDB: Using Linux native AIO

2017-09-21 09:30:19 3294 [Note] InnoDB: Using CPU crc32 instructions

2017-09-21 09:30:19 3294 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2017-09-21 09:30:19 3294 [Note] InnoDB: Completed initialization of buffer pool

2017-09-21 09:30:19 3294 [Note] InnoDB: Highest supported file format is Barracuda.

2017-09-21 09:30:19 3294 [Note] InnoDB: 128 rollback segment(s) are active.

2017-09-21 09:30:19 3294 [Note] InnoDB: Waiting for purge to start

2017-09-21 09:30:19 3294 [Note] InnoDB: 5.6.37 started; log sequence number 1625997

2017-09-21 09:30:19 3294 [Note] Binlog end

2017-09-21 09:30:19 3294 [Note] InnoDB: FTS optimize thread exiting.

2017-09-21 09:30:19 3294 [Note] InnoDB: Starting shutdown...

2017-09-21 09:30:21 3294 [Note] InnoDB: Shutdown completed; log sequence number 1626007

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:

./bin/mysqladmin -u root password 'new-password'

./bin/mysqladmin -u root -h qkettle password 'new-password'

Alternatively you can run:

./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 . ; ./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 ./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

这里更改了一下用户名qkettle（可忽略）。

注意：要将data变成mysql用户

[root@qkettle mysql]# chown -R root .

[root@qkettle mysql]# chown -R mysql data

五、复制启动程序：

[root@qkettle mysql]# cp support-files/mysql.server /etc/init.d/mysql.server

在这里，如果/usr/local没有mysql软链接的话，会报错，说找不到服务的。

六、启动MySQL服务，这里出来个错误：（没出错就直接查看下是否有MySQL进程，继续往下操作就好）

[root@qkettle mysql]# /etc/init.d/mysql.server start

Starting MySQL.170921 10:03:14 mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.

ERROR! The server quit without updating PID file (/var/lib/mysql/qkettle.pid).

解决：

[root@qkettle mysql]# vim /etc/my.cnf

[mysqld_safe]

log-error=/var/log/mysql/mariadb.log

pid-file=/var/run/mysql/mariadb.pid

再启动：成功

[root@qkettle mysql]# /etc/init.d/mysql.server start

Starting MySQL.Logging to '/var/log/mysql/mariadb.log'.

. SUCCESS!

查看进程

[root@qkettle mysql]# ps -ef |grep mysql

root 4998 1 0 10:05 pts/1 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/qkettle.pid

mysql 5159 4998 0 10:05 pts/1 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/mysql/mariadb.log --pid-file=/var/lib/mysql/qkettle.pid --Socket=/var/lib/mysql/mysql.sock

七、建立软链接，启动mysql。

[root@qkettle mysql]# ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

这里出错：

[root@qkettle bin]# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

解决方法：

先停止服务，然后修改一个地方。

[root@qkettle bin]# /etc/init.d/mysql.server stop

Shutting down MySQL.. SUCCESS!

[root@qkettle mysql]# vim /etc/my.cnf

socket=/tmp/mysql.sock

八、再次启动服务、可以登录了

[root@qkettle bin]# /etc/init.d/mysql.server start

初始登录

mysql -u root

修改root用户密码

mysql>use mysql;

mysql> update user set password=password("123456") where user='root';

mysql> flush privileges;

退出重新用密码登录一下

mysql> exit;

查看数据库的字符集情况

mysql> show variables like 'char%';

修改数据库字符集，其他的格式相同。

mysql> set character_set_database=utf8;

重启后，字符集并不好用。

需要修改配置文件/etc/my.cnf

在[mysqld]下添加一段话，不能写错了，否则会启动不了

character-set-server=utf8

因为我这里只有这么一个mysqld段落，所以没有再添加别的。

如果要是还有别的需要添加字符集的段落，也需要添加上。

您可能感兴趣的文档:

点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: 安装mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz通用版

本文链接: https://www.lsjlt.com/news/51987.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档

去做题

猜你喜欢

oracle怎么查询当前用户所有的表

要查询当前用户拥有的所有表，可以使用以下 sql 命令：select * from user_tables; 如何查询当前用户拥有的所有表要查询当前用户拥有的所有表，可以使...

99+

2024-05-14

oracle
oracle怎么备份表中数据

oracle 表数据备份的方法包括：导出数据 (exp)：将表数据导出到外部文件。导入数据 (imp)：将导出文件中的数据导入表中。用户管理的备份 (umr)：允许用户控制备份和恢复过程...

99+

2024-05-14

oracle
oracle怎么做到数据实时备份

oracle 实时备份通过持续保持数据库和事务日志的副本来实现数据保护，提供快速恢复。实现机制主要包括归档重做日志和 asm 卷管理系统。它最小化数据丢失、加快恢复时间、消除手动备份任务...

99+

2024-05-14

oracle 数据丢失
oracle怎么查询所有的表空间

要查询 oracle 中的所有表空间，可以使用 sql 语句 "select tablespace_name from dba_tablespaces"，其中 dba_tabl...

99+

2024-05-14

oracle
oracle怎么创建新用户并赋予权限设置

答案：要创建 oracle 新用户，请执行以下步骤：以具有 create user 权限的用户身份登录；在 sql*plus 窗口中输入 create user identified ...

99+

2024-05-14

oracle
oracle怎么建立新用户

在 oracle 数据库中创建用户的方法：使用 sql*plus 连接数据库；使用 create user 语法创建新用户；根据用户需要授予权限；注销并重新登录以使更改生效。如何在 ...

99+

2024-05-14

oracle
oracle怎么创建新用户并赋予权限密码

本教程详细介绍了如何使用 oracle 创建一个新用户并授予其权限：创建新用户并设置密码。授予对特定表的读写权限。授予创建序列的权限。根据需要授予其他权限。如何使用 Oracle 创...

99+

2024-05-14

oracle
oracle怎么查询时间段内的数据记录表

在 oracle 数据库中查询指定时间段内的数据记录表，可以使用 between 操作符，用于比较日期或时间的范围。语法：select * from table_name wh...

99+

2024-05-14

oracle
oracle怎么查看表的分区

问题：如何查看 oracle 表的分区？步骤：查询数据字典视图 all_tab_partitions，指定表名。结果显示分区名称、上边界值和下边界值。如何查看 Oracle 表的分区...

99+

2024-05-14

oracle
oracle怎么导入dump文件

要导入 dump 文件，请先停止 oracle 服务，然后使用 impdp 命令。步骤包括：停止 oracle 数据库服务。导航到 oracle 数据泵工具目录。使用 impdp 命令导...

99+

2024-05-14

oracle