Web lists-archives.com

Re: Fresh install of MySQL 5.6.23 fails to start on CentOS 7.0

Am 13.02.2015 um 00:03 schrieb Bruce Ferrell:
If the datadir is empty. you have to execute a different utility  mysql_install_db.  This will create a correct initial database.

Jesus!  I HATE systemd.  The sysV init script handled this correctly.

tell me *one* reason why it is the job of the init-system to check and fire up "mysql_install_db" at each start? guess what happens when that shell snippet makes a mistake and does that on a existing install

frankly my "mysql" database was installed in 2003 on a windows machine and is the root for every mysql setup from then on Windows, OSX and Linux from MySQL 3.x to MariaDB 5.x up to MariaDB 10.x

why would i want to do all the crap about set a sane default password for each and every install when tehre is a template setup?

On 02/12/2015 02:06 PM, Cameron Mann wrote:
Hi Robert,

The value in my.cnf is datadir=/var/lib/mysql. The directory is
initially empty, which I believe is normal; there shouldn't be
anything in there until mysqld is started for the first time (at least
that's the behaviour of 5.6.22, which works fine). After mysqld fails
to start, an empty mysql directory is created.


On Thu, Feb 12, 2015 at 2:35 PM, Bob Eby <ebyrob@xxxxxxxxx> wrote:
Hi Cameron,

I've seen a similar error running on windows 7.

When you look in your datadir= specified in my.ini what is there exactly
(hopefully not empty)?  Do you have a mysql folder containing plugin.* files
at this location? (say .MYI etc)

It sounds like your data folders were either not copied to the correct place
or not properly configured before starting the server.

It's been a while, but I recall there being an "install" step to getting the
correct basic database files into your datadir specified in my.ini

Attachment: signature.asc
Description: OpenPGP digital signature