Linux安装MySQL-server-5.6.22日志

最新推荐文章于 2025-10-28 15:48:24 发布
原创 最新推荐文章于 2025-10-28 15:48:24 发布 · 850 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql

本文记录了Mysql5.6.22版本在Linux系统的安装过程及随机生成的root用户密码位置。安装过程中，系统会在指定路径下生成随机密码，并提示用户首次登录必须更改密码。

最近在学习Mysql安装，看了好多网上的资料，说了好多第一次用root登陆的方式，都没有成功。

仔细查看了一下安装日志，其实人家是给创建了一个随机密码，并且有提示如何修改密码，完全没那么麻烦。


[root@localhost src]# rpm -ivh MySQL-server-5.6.22-1.rhel5.i386.rpm
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
2015-01-29 09:51:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-29 09:51:25 28245 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-01-29 09:51:25 28245 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-29 09:51:25 28245 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-01-29 09:51:25 28245 [Note] InnoDB: Memory barrier is not used
2015-01-29 09:51:25 28245 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-29 09:51:25 28245 [Note] InnoDB: Using Linux native AIO
2015-01-29 09:51:25 28245 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-29 09:51:25 28245 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-29 09:51:25 28245 [Note] InnoDB: Completed initialization of buffer pool
2015-01-29 09:51:25 28245 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2015-01-29 09:51:25 28245 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2015-01-29 09:51:25 28245 [Note] InnoDB: Database physically writes the file full: wait...
2015-01-29 09:51:25 28245 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-01-29 09:51:25 28245 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-01-29 09:51:26 28245 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-01-29 09:51:26 28245 [Warning] InnoDB: New log files created, LSN=45781
2015-01-29 09:51:26 28245 [Note] InnoDB: Doublewrite buffer not found: creating new
2015-01-29 09:51:26 28245 [Note] InnoDB: Doublewrite buffer created
2015-01-29 09:51:26 28245 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-29 09:51:26 28245 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-01-29 09:51:26 28245 [Note] InnoDB: Foreign key constraint system tables created
2015-01-29 09:51:26 28245 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-01-29 09:51:26 28245 [Note] InnoDB: Tablespace and datafile system tables created.
2015-01-29 09:51:26 28245 [Note] InnoDB: Waiting for purge to start
2015-01-29 09:51:26 28245 [Note] InnoDB: 5.6.22 started; log sequence number 0
A random root password has been set. You will find it in '/root/.mysql_secret'.
2015-01-29 09:51:26 28245 [Note] Binlog end
2015-01-29 09:51:26 28245 [Note] InnoDB: FTS optimize thread exiting.
2015-01-29 09:51:26 28245 [Note] InnoDB: Starting shutdown...
2015-01-29 09:51:28 28245 [Note] InnoDB: Shutdown completed; log sequence number 1625977


2015-01-29 09:51:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-29 09:51:28 28267 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-01-29 09:51:28 28267 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-29 09:51:28 28267 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-01-29 09:51:28 28267 [Note] InnoDB: Memory barrier is not used
2015-01-29 09:51:28 28267 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-29 09:51:28 28267 [Note] InnoDB: Using Linux native AIO
2015-01-29 09:51:28 28267 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-29 09:51:28 28267 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-29 09:51:28 28267 [Note] InnoDB: Completed initialization of buffer pool
2015-01-29 09:51:28 28267 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-29 09:51:28 28267 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-29 09:51:28 28267 [Note] InnoDB: 5.6.22 started; log sequence number 1625977
2015-01-29 09:51:28 28267 [Note] Binlog end
2015-01-29 09:51:28 28267 [Note] InnoDB: FTS optimize thread exiting.
2015-01-29 09:51:28 28267 [Note] InnoDB: Starting shutdown...
2015-01-29 09:51:30 28267 [Note] InnoDB: Shutdown completed; log sequence number 1625987




A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.

You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

  /usr/bin/mysql_secure_installation

which will also give you the option of removing the test database.
This is strongly recommended for production servers.

See the manual for more instructions.

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

New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

CentOS-7下安装MySQL5.6.22
jiq•钦's technical Blog
01-18 2917
CentOS-7下安装MySQL5.6.22(当前最新版本：2015-01-17) 转载请注明出处：jiq•钦's technical Blog 一安装环境 （1）CentOS版本：CentOS-7 查看方法： [root@bogon 桌面]# cat /etc/redhat-release CentOS Linux release 7.0.1406 (Core) 来源：官网下载
linux-centos6.4安装mysql5.6.14数据库
子柚的博客
10-20 363
本文详细介绍了在Linux系统中卸载旧版MySQL并安装配置MySQL 5.6.14的全过程。主要内容包括：1）卸载旧版MySQL的两种方法；2）安装编译所需的依赖包并下载MySQL源码；3）使用cmake进行编译安装；4）配置MySQL用户权限和初始化数据库；5）设置MySQL服务和开机启动；6）配置root密码和远程访问权限；7）防火墙设置以开放3306端口。文章还特别说明了CentOS 7中需要使用firewalld来配置端口。整个安装过程约30分钟，最后提供了完整的MySQL服务配置方案。
liunx安装mysql简单易懂教程
qq_42903710的博客
08-30 239
教程地址： https://blog.csdn.net/lizy928/article/details/82531749 创建用户并且给予权限地址：https://blog.csdn.net/hqmln/article/details/84917915
linux mysql 5.6.22_LinuxCentOS6.0下编译安装MySQL5.6.22
weixin_35458961的博客
02-17 198
Linux CentOS6.5下编译安装MySQL 5.6.22【给力详细教程】 一、编译安装MySQL前的准备工作 安装编译源码所需的工具和库(安装过程注意有没出错) yum install gcc gcc-c++ ncurses-devel perl 安装cmake，从http://www.cmake.org下载源码并编译安装 我下的版Linux CentOS6.5下编译安装MySQL 5.6...
清除入侵痕迹(win&Linux&web)
最新发布
缘友一世的博客
10-28 915
清除入侵痕迹(win&Linux&web)
linux安装mysql-server
水逆呱的博客
03-28 3861
1、安装mysql-server 报错：Failed to start mariadb.service: Unit not found. 需要执行以下命令安装mysql-server： # yum install -y mariadb-server 安装mysql-server后，修改以下文件进行配置： # vi /etc/my.cnf 在[mysqld]部分增加以下内容： c...
linux系统安装mysql服务器
qq_43240682的博客
09-29 890
linux系统安装mysql服务器
Linux CentOS6.0下编译安装MySQL 5.6.22
lovemysea的专栏
09-01 686
Linux CentOS6.5下编译安装MySQL 5.6.22【给力详细教程】 一、编译安装MySQL前的准备工作 安装编译源码所需的工具和库（安装过程注意有没出错） yum install gcc gcc-c++ ncurses-devel perl   安装cmake，从http://www.cmake.org下载源码并编译安装 我下的版本：http://www.cmake...
Neokylin-Server离线环境、跨主机、使用Docker部署PXC集群
weixin_43538901的博客
02-14 2011
Neokylin-Server离线环境、跨主机、使用Docker部署PXC集群Neokylin-Server离线环境、跨主机、使用Docker部署PXC集群一、说明二、部署过程：1. 切换root账号或所有语句加sudo;2. 关闭6个节点防火墙（或打开端口）;3. 6个节点导入rpm包后安装基础环境：4. 设置所有节点;5. 启动docker并导入images;6. 时间同步;7. etcd集群配置;8. 部署flannel网络;9. n1-n3部署pxc;10. m1-m3部署Haproxy+Keepa
[root@localhost ~]# head -100 /var/log/mysqld.log 250922 00:47:45 mysqld_safe Logging to '/var/log/mysqld.log'. 250922 00:47:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2025-09-22 00:47:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-09-22 00:47:45 0 [Note] /usr/sbin/mysqld (mysqld 5.6.51) starting as process 41577 ... 2025-09-22 00:47:45 41577 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2025-09-22 00:47:45 41577 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2025-09-22 00:47:45 41577 [Note] Plugin 'FEDERATED' is disabled. 2025-09-22 00:47:45 41577 [Note] InnoDB: Using atomics to ref count buffer pool pages 2025-09-22 00:47:45 41577 [Note] InnoDB: The InnoDB memory heap is disabled 2025-09-22 00:47:45 41577 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-09-22 00:47:45 41577 [Note] InnoDB: Memory barrier is not used 2025-09-22 00:47:45 41577 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-09-22 00:47:45 41577 [Note] InnoDB: Using Linux native AIO 2025-09-22 00:47:45 41577 [Note] InnoDB: Using CPU crc32 instructions 2025-09-22 00:47:45 41577 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2025-09-22 00:47:45 41577 [Note] InnoDB: Completed initialization of buffer pool 2025-09-22 00:47:45 41577 [Note] InnoDB: Highest supported file format is Barracuda. 2025-09-22 00:47:45 41577 [Note] InnoDB: 128 rollback segment(s) are active. 2025-09-22 00:47:45 41577 [Note] InnoDB: Waiting for purge to start 2025-09-22 00:47:45 41577 [Note] InnoDB: 5.6.51 started; log sequence number 1625987 2025-09-22 00:47:45 41577 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 482452ca-976f-11f0-a3ab-000c2932bbd7. 2025-09-22 00:47:45 41577 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. 2025-09-22 00:47:45 41577 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. 2025-09-22 00:47:45 41577 [Note] Server hostname (bind-address): '*'; port: 3306 2025-09-22 00:47:45 41577 [Note] IPv6 is available. 2025-09-22 00:47:45 41577 [Note] - '::' resolves to '::'; 2025-09-22 00:47:45 41577 [Note] Server socket created on IP: '::'. 2025-09-22 00:47:45 41577 [Note] Event Scheduler: Loaded 0 events 2025-09-22 00:47:45 41577 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.51' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2025-09-22 02:09:26 41577 [Note] /usr/sbin/mysqld: Normal shutdown 2025-09-22 02:09:26 41577 [Note] Giving 0 client threads a chance to die gracefully 2025-09-22 02:09:26 41577 [Note] Event Scheduler: Purging the queue. 0 events 2025-09-22 02:09:26 41577 [Note] Shutting down slave threads 2025-09-22 02:09:26 41577 [Note] Forcefully disconnecting 0 remaining clients 2025-09-22 02:09:26 41577 [Note] Binlog end 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'partition' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_METRICS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMPMEM' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_LOCKS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_TRX' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'InnoDB' 2025-09-22 02:09:26 41577 [Note] InnoDB: FTS optimize thread exiting. 2025-09-22 02:09:26 41577 [Note] InnoDB: Starting shutdown... 2025-09-22 02:09:27 41577 [Note] InnoDB: Shutdown completed; log sequence number 1625997 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'BLACKHOLE' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'ARCHIVE' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'MRG_MYISAM' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'MyISAM' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'MEMORY' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'CSV' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'sha256_password' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'mysql_old_password' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'mysql_native_password' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'binlog' 2025-09-22 02:09:27 41577 [Note] /usr/sbin/mysqld: Shutdown complete 250922 02:09:27 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 250922 02:09:28 mysqld_safe Logging to '/var/log/mysqld.log'. 250922 02:09:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2025-09-22 02:09:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-09-22 02:09:28 0 [Note] /usr/sbin/mysqld (mysqld 5.6.51) starting as process 41965 ... 2025-09-22 02:09:28 41965 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2025-09-22 02:09:28 41965 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2025-09-22 02:09:28 41965 [Note] Plugin 'FEDERATED' is disabled. 2025-09-22 02:09:28 41965 [Note] InnoDB: Using atomics to ref count buffer pool pages 2025-09-22 02:09:28 41965 [Note] InnoDB: The InnoDB memory heap is disabled 2025-09-22 02:09:28 41965 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-09-22 02:09:28 41965 [Note] InnoDB: Memory barrier is not used 2025-09-22 02:09:28 41965 [Note] InnoDB: Compressed tables use zlib 1.2.11
09-23
我们在分析MySQL 5.6.51日志中的警告信息。用户提到了三个主要问题：TIMESTAMP隐式默认值弃用、max_open_files和table_open_cache更改限制。我们结合引用和MySQL知识来解答。 1. TIMESTAMP隐式默认值弃用警告： ...
软件管理（redhat 8.0）
system_rookie的大佬成长之路
08-19 868
软件管理 软件包分类 二进制格式（编译好的，装上就可以用） rpm包作者下载源程序，编译配置完成后，制作成rpm包 why would we do that? because： 有些特性是编译时选定的，如果编译时未选定此特性，将无法使用 rpm包的版本会落后于源码包，甚至落后很多 源码格式（需要编译，也叫定制） 命名方式：name-VERSION.tar.gz VERSION：major.minor.release rpm包名规范 bash-4.2.46-28.el7.x86_6
阿里云linux安装MySQL Server
srg2000的博客
06-11 284
阿里云服务器安装mysql服务
Linux搭建Mysql-server
dt13487442072的博客
05-26 639
在官网下载安装mysql-server wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
linux mysql 5.6.22_Linux安装MySQL-server-5.6.22日志
weixin_35989968的博客
01-27 184
最近在学习Mysql安装，看了好多网上的资料，说了好多第一次用root登陆的方式，都没有成功。仔细查看了一下安装日志，其实人家是给创建了一个随机密码，并且有提示如何修改密码，完全没那么麻烦。[[emailprotected] src]# rpm -ivh MySQL-server-5.6.22-1.rhel5.i386.rpmPreparing... #######...
LINUX安装MySQL
柳鲲鹏
10-11 408
安装mysql-server sudo apt-get install mysql-server 提示设置MySQL的root密码： 再输入一次： 安装MySQL-client sudo apt install mysql-client sudo apt install libmysqlclient-dev  ...
如何在linux上安装mysql服务
m0_63199267的博客
02-08 281
如何在linux上安装mysql服务 容器安装 本地安装 仓库安装 源码安装
CentOS上mysql-server的安装指南(Linux安装mysql实战指南)[张振华-Jack]
张振华.Jack
11-24 1709
Linux的CentOS系统上安装mysql-server和mysql-client实战指南及其全过程
mysql5.6.22.0安装_linux下安装mysql 5.6.22
weixin_39627361的博客
12-20 252
一、卸载旧版本MySQL(如果重新安装，此步略过)1、查看已经安装的mysql[root@yxq app]#ps -ef | grep mysqlroot 2007 1 0 08:54 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql...
linux mysql 5.6.22_linux下MySQL5.6.2安装过程
weixin_42515739的博客
01-21 279
MySQL是一个关系型数据库管理系统，并且又是开源的，现在很多系统和网站都在使用它，今天给大家分享下我在linux下安装MySQL5.6.2的过程以及遇到的问题。环境：CentOS release 6.6 (Final)MySQL：5.6.2MySQL官方下载地址：http://downloads.mysql.com/archives/community/你可以根据自己想要的版本下载，不过每个版本...
解决Linux下安装MySQL错误：使用ncurses-5.6.tar.gz
描述“linux 安装mysql错误 安装ncurses-5.6.tar.gz”告诉我们，这个文件可能是在安装MySQL时遇到问题时所需要的一个步骤。MySQL是一个流行的开源关系型数据库管理系统（RDBMS），它通常用于Web应用和企业环境。在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值