Re: Fresh install of MySQL 5.6.23 fails to start on CentOS 7.0
- Date: Thu, 12 Feb 2015 15:35:45 -0800
- From: Bruce Ferrell <bferrell@xxxxxxxxxxxx>
- Subject: Re: Fresh install of MySQL 5.6.23 fails to start on CentOS 7.0
Well Mr Harald, I admit... It's not an "out of the box" behaviour put there by Oracle/MySQL. But it IS a behaviour introduced by distribution packagers and and it's only invoked
the first time the db is start is attempted AND there is no basic db in place. mysql_install_db actually won't run without being forced on an installed system.
Folks have come to expect it and it IS handy ("when I tell MySQL to start, it just works, even if it's never been run before"). Isn't that the entire idea behind all of the
freedesktop junk... Things "just work"? Except when they don't.
On 02/12/2015 03:11 PM, Reindl Harald wrote:
> 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
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql