/ Mysqld Solution - Can't init databases /usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13) /usr/libexec/mysqld: Can't create/write to file '/tmp/ibyP1qUC' (Errcode: 13) 100215 7:02:24 InnoDB: Error: unable to create temporary file; errno - rtt - IT Resource

Mysqld Solution - Can't init databases /usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13) /usr/libexec/mysqld: Can't create/write to file '/tmp/ibyP1qUC' (Errcode: 13) 100215 7:02:24 InnoDB: Error: unable to create temporary file; errno

100215 07:02:24  mysqld started
/usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13)
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibyP1qUC' (Errcode: 13)
100215  7:02:24  InnoDB: Error: unable to create temporary file; errno: 13
100215  7:02:24 [ERROR] Can't init databases
100215  7:02:24 [ERROR] Aborting

100215  7:02:24 [Note] /usr/libexec/mysqld: Shutdown complete

100215 07:02:24  mysqld ended

One of my servers was rebooted for some reason and all sites and e-mail accounts were down because the database could not be connected.  The first thing I checked was mysqld of course and it was not running.  The above was revealed in /var/log/mysqld.log

I was starting to panic and wondered if the server was compromised and I even checked /var/lib/mysql to make sure all the database data was still there.

The solution for this MySQL Error is simple:

chown root.root /tmp

chmod 1777 /tmp

And of course be sure that you start MySQL again.


Tags:

mysqld, init, databases, usr, libexec, dir, tmp, errcode, ibyp, quc, innodb, unable, errno, aborting, shutdown, servers, rebooted, sites, database, revealed, var, server, compromised, lib, mysql, chown, chmod,

Latest Articles

  • How Does Cisco CUCM (Cisco Unified Communication Manager) Work?
  • What DNS Options Does Active Directory Offer in Windows Server 2008,2012,2016 ?
  • syntax error, unexpected T_SL in PHP Solution
  • grep regular expression match number range between specific numbers
  • bash how to print out lines of text within a range from the first occurrence
  • bash script how to to check LAN computers for open ports
  • MySQL Using mytop Debug Source of High IO and Slow Performance
  • How To Mathematically Convert and Calculate Binary Value To Decimal Value
  • systemd management using systemctl and journalctl to check systemd logs
  • css how to format code in the code tag
  • css br with extra blank line
  • What is /dev/pts and why do we need it in Linux?
  • Linux What is umask (user mask) for file and directory creation permissions and how to calculate umask and change the defaults
  • Linux Permissions and Groups Real Usecase for Group Access
  • Centos 7 python34 how to install the gi library
  • Centos 7 - Convert Minimal to Graphical GUI GNOME or KDE Desktop
  • AMD Set Fan Speed and Other Powerplay Memory/CPU Timings with a Linux script
  • Ethereum Mining Claymore Nanopool Error
  • genisoimage errors with long filenames and deep directory structures
  • Linux Kernel USB Export Errors