CentOS6.5启动MariaDB错误

最新推荐文章于 2022-05-06 08:58:22 发布
最新推荐文章于 2022-05-06 08:58:22 发布
阅读量356 收藏
点赞数
文章标签： 数据库 python jira
原文链接：https://my.oschina.net/2726276586/blog/889948
版权

2019独角兽企业重金招聘Python工程师标准>>> hot3.png

[root@localhost ~]# /etc/init.d/mysql start
Starting MySQL.170430 23:07:56 mysqld_safe Logging to '/home/mysql/db/mianbao/localhost.localdomain.err'.
170430 23:07:56 mysqld_safe Starting mysqld daemon with databases from /home/mysql/db/mianbao
/usr/bin/mysqld_safe_helper: Can't create/write to file '/home/mysql/db/mianbao/localhost.localdomain.err' (Errcode: 2 "No such file or directory")
. ERROR!

[root@localhost mianbao]# tail -f localhost.localdomain.err 
170430 23:08:57 [Note] InnoDB: Creating tablespace and datafile system tables.
170430 23:08:57 [Note] InnoDB: Tablespace and datafile system tables created.
170430 23:08:57 [Note] InnoDB: Waiting for purge to start
170430 23:08:57 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 0
170430 23:08:57 [Note] Plugin 'FEEDBACK' is disabled.
170430 23:08:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170430 23:08:57 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
170430 23:08:57 [Note] Server socket created on IP: '127.0.0.1'.
170430 23:08:57 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
170430 23:08:57 mysqld_safe mysqld from pid file /home/mysql/db/mianbao/localhost.localdomain.pid ended

初始化数据库，指定数据存储路径

[root@localhost mianbao]# mysql_install_db --user=mysql --datadir=/home/mysql/db/mianbao/
Installing MariaDB/MySQL system tables in '/home/mysql/db/mianbao/' ...
170430 23:14:18 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB) starting as process 46784 ...
170430 23:14:18 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170430 23:14:18 [Note] InnoDB: The InnoDB memory heap is disabled
170430 23:14:18 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170430 23:14:18 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
170430 23:14:18 [Note] InnoDB: Compressed tables use zlib 1.2.3
170430 23:14:18 [Note] InnoDB: Using Linux native AIO
170430 23:14:18 [Note] InnoDB: Using CPU crc32 instructions
170430 23:14:18 [Note] InnoDB: Initializing buffer pool, size = 128.0M
170430 23:14:18 [Note] InnoDB: Completed initialization of buffer pool
170430 23:14:18 [Note] InnoDB: Highest supported file format is Barracuda.
170430 23:14:18 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463
170430 23:14:18 [Note] InnoDB: Database was not shutdown normally!
170430 23:14:18 [Note] InnoDB: Starting crash recovery.
170430 23:14:18 [Note] InnoDB: Reading tablespace information from the .ibd files...
170430 23:14:18 [Note] InnoDB: Restoring possible half-written data pages 
170430 23:14:18 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600607
170430 23:14:18 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
170430 23:14:18 [Note] InnoDB: 128 rollback segment(s) are active.
170430 23:14:18 [Note] InnoDB: Waiting for purge to start
170430 23:14:18 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600607
170430 23:14:19 [Note] InnoDB: FTS optimize thread exiting.
170430 23:14:19 [Note] InnoDB: Starting shutdown...
170430 23:14:20 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
170430 23:14:22 [Note] InnoDB: Shutdown completed; log sequence number 1616707
OK
Filling help tables...
170430 23:14:22 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB) starting as process 46814 ...
170430 23:14:22 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170430 23:14:22 [Note] InnoDB: The InnoDB memory heap is disabled
170430 23:14:22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170430 23:14:22 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
170430 23:14:22 [Note] InnoDB: Compressed tables use zlib 1.2.3
170430 23:14:22 [Note] InnoDB: Using Linux native AIO
170430 23:14:22 [Note] InnoDB: Using CPU crc32 instructions
170430 23:14:22 [Note] InnoDB: Initializing buffer pool, size = 128.0M
170430 23:14:22 [Note] InnoDB: Completed initialization of buffer pool
170430 23:14:22 [Note] InnoDB: Highest supported file format is Barracuda.
170430 23:14:22 [Note] InnoDB: 128 rollback segment(s) are active.
170430 23:14:22 [Note] InnoDB: Waiting for purge to start
170430 23:14:22 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616707
170430 23:14:22 [Note] InnoDB: FTS optimize thread exiting.
170430 23:14:22 [Note] InnoDB: Starting shutdown...
170430 23:14:23 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
170430 23:14:25 [Note] InnoDB: Shutdown completed; log sequence number 1616717
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 MariaDB root USER !
To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:
'/usr/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 MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='/home/mysql/db/mianbao/'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

[root@localhost mianbao]# /etc/init.d/mysql start
Starting MySQL.170430 23:14:34 mysqld_safe Logging to '/home/mysql/db/mianbao/localhost.localdomain.err'.
170430 23:14:34 mysqld_safe Starting mysqld daemon with databases from /home/mysql/db/mianbao
 SUCCESS!

转载于:https://my.oschina.net/2726276586/blog/889948

weixin_34124939
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Linux学习之路--Mariadb（2）源码编译安装【19】---20180120
weixin_34236497的博客
02-06 330
一、源码编译安装mariadb生产环境中，大部分使用的都是二进制安装或者源码编译安装，yum安装很多要求和设置很繁琐，容易出现错误此次源码编译安装需要先安装 cmake 1、准备cmake[root@Centos6-server~]#rpm-qcmake packagecmakeisnotinstalled [root@Centos6-server~]#yum...
MariaDB10.x.x 初始化失败
weixin_33725807的博客
02-18 1031
背景 mariadb在docker中运行，采用yum安装mariadb server的形式，然后使用mysql_install_db初始化的时指定my.cnf路径 环境 centos 7.4 mariadb 10.1.38 问题 [root@test /]# mysql_install_db --defaults-file=/etc/my.cnf -...
装mysql和mariadb走过的坑 windows系统
qq_41908456的博客
07-14 841
一开始电脑上mysql装好之后，mariadb却无法使用了。 而且在创建mysql服务时mysqld --install 总会将服务创建到之前mysql5.7的目录下，但实际我进入目录创建地址为 我得解决方法是直接删掉mysql5.7的mysqld ...
记mysql 启动不了了的解决方法
u010227042的博客
07-21 541
系统: centos7 本地的环境，mysql启动不了，查看/var/log/mysqld.log有以下内容 2018-12-24T08:05:38.090527Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-1..
Mariadb [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
leo__1990的博客
06-25 5767
现象描述： [root@www.cndba.cn mysql]# service mysql start Starting MariaDB.180227 01:54:58 mysqld_safe Logging to '/data1/mysql/log/error.log'. 180227 01:54:58 mysqld_safe Starting mysqld daemon with da...
centos6.5 离线安装 crontabs rpm 系统定时任务
09-28
cronie-1.4.4-12.el6.x86_64.rpm cronie-anacron-1.4.4-12.el6.x86_64.rpm crontabs-1.10-33.el6.noarch.rpm procmail-3.22-25.1.el6.x86_64.rpm sendmail-8.14.4-8.el6.x86_64.rpm
Centos6.5 镜像文件下载
12-27
Centos6.5镜像文件 Linux。。
CentOS 6.5 最新可用的 Yum 源
最新发布
02-02
CentOS 6.5 的 软件源很多官方已经停止维护，该文件包内配置好的yum源是可以正常使用的。将原/etc/yum.repos.d/目录下原来的 .repo 备份, 然后把本文件包内的repo文件复制过去， yum clean all 后，再 yum ...
CentOS 6.5上的Tomcat启动报错问题解决方法
01-20
这里有两个错误： 1、第一个错误，APR的问题，错误详情： The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path 2、...
centos6.5通过yum安装nginx
09-15
主要为大家详细介绍了centos6.5通过yum安装nginx的相关步骤，linux安装nginx以及配置，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
Oracle Linux 7.1中安装Mariadb
06-04 343
在Oracle Linux 7.1中安装Mariadb 10.0.38，因为Mariadb是Mysql的分支，安装操作基本类似。 1.首先下载安装介质mariadb-10.0.38-linux-glib...
MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
热门推荐
ncafei的博客
02-02 2万+
http://www.android100.org/html/201406/19/27784.html 最近碰到一个 MySQL不能创建临时文件的错误，解决过程中学到一些知识，这里分享一下，希望对碰到类似问题的同学有所帮助~ 关于MySQL临时文件： 1、MySQL使用环境变量TMPDIR的值作为保存临时文件的目录的路径名。如果未设置TMPDIR，MySQL将
ERROR 1 (HY000): Can‘t create/write to file ‘/opt/test1‘ (Errcode: 13)
weixin_45574151的博客
05-06 637
数据库导出文件报错 MariaDB [tom]> select * from test into outfile "/opt/1.csv"; ERROR 1 (HY000): Can't create/write to file '/opt/1.csv' (Errcode: 13) 报上面的错是因为没有权限的问题： chown -R mysql:mysql /opt/ 【给目录加个权限】 或者换个目录： MariaDB [tom]> select * from a int.
MariaDB升级到10.1.22
沐雨聼風
03-21 1725
yum -y install cmake 安装 cmake 工具 执行 cmake 命令进行编译 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DMYSQL_DATADIR=/var/data/mariadb -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_XTRADB_
centos7.4下源码安装mariadb
u013308094的博客
10-06 942
一、卸载旧的mariadb 查询已安装的软件： rpm -qa | grep Maria* 卸载：yum -y remove mari* 删除数据库文件：rm -rf /var/lib/mysql/* 二、安装依赖包且源码安装cmake yum groupinstall “Development Tools” yum install libaio libaio-devel bison bison-...
freeswitch连接mysql报错_FreeSWITCH调试经验
weixin_34237703的博客
02-01 963
bug编号：No.0001bug现象：话机注册失败bug提示：1> 话机提示信息：Registration error: 403 - Forbidden2> FSlog信息：2015-10-19 07:32:57.384257 [WARNING] sofia_reg.c:2859 Cant register a pointer.bug解析：[403 Forbidden]的错误为用户名和...
mariadb启动报错的一个案例
辛星，前进的路上.
06-08 1万+
今天安装了mariadb，在启动时报错如下: [root@iZ284mvmum4Z bin]# mysqld_safe 160608 09:18:25 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. 160608 09:18:25 mysqld_safe Starting mysqld daemon with databases
关于Mysql数据导出时遇到的Can't create/write to file问题
lastmoon52的专栏
12-12 1万+
一般我们从Mysql导出数据有很多种方法，如使用MysqlDump，或者使用可视化工具。但是如果我们是内网环境，而且数据库是部署在Linux，甚至Unix环境下无图形化环境时就必须要使用命令行方式来导出数据了 在这里我使用的是以select * from tablename into outfile '/path/path/filename' what what what.的方式来导出数据的，一...
centos 6.5 如何启动rc-local服务
07-15
在 CentOS 6.5 中启动 rc.local 服务，您可以按照以下步骤进行操作： 1. 打开终端或登录到您的 CentOS 6.5 服务器。 2. 使用 root 用户或具有 sudo 权限的用户执行以下命令以编辑 /etc/rc.d/rc.local 文件： ```shell sudo vi /etc/rc.d/rc.local ``` 3. 在打开的文件中，您可以添加您想要在系统启动时运行的命令。例如，您可以添加以下内容： ```shell #!/bin/bash echo "Hello, World!" > /tmp/rc.local.log ``` 这个例子中，我们将 "Hello, World!" 写入 /tmp/rc.local.log 文件中。 4. 保存并关闭文件。在 vi 编辑器中，按下 `Esc` 键，然后输入 `:wq`，然后按下 `Enter` 键。 5. 接下来，您需要设置 rc.local 文件的权限以使其可执行。执行以下命令： ```shell sudo chmod +x /etc/rc.d/rc.local ``` 6. 最后，您需要启动 rc.local 服务并将其设为开机启动。执行以下命令： ```shell sudo chkconfig --add rc.local sudo chkconfig rc.local on ``` 这将添加 rc.local 到系统服务并设置为开机启动。 现在，当您的 CentOS 6.5 系统启动时，rc.local 中添加的命令将会自动执行。您可以通过检查/tmp/rc.local.log文件来验证命令是否被执行。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值