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.
What slobs!
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.
>>>
>>> Cameron
>>>
>>> On Thu, Feb 12, 2015 at 2:35 PM, Bob Eby <eby...@gmail.com> 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
