Ok, It seems, I had missed the &quot;u&quot; flag for user so accidentally I had input the following command.


    mysql -root -p // Faulty connection

Instead of ...

    mysql -uroot -p // Correct connection

Notice the missing &quot;u&quot; from the Faulty connection.

I&#39;m trying to set an environment variable from my Gradle build. I&#39;m on MacOS X (El Capitan).
The command is &quot;gradle test&quot;.

I&#39;m trying this in my build.gradle:

    task setenv(type: Exec) {
        commandLine &quot;export&quot;, &quot;SOME_TEST_VAR=aaa&quot;
    }
    test.dependsOn setenv

and the build fails:

&gt; Execution failed for task &#39;:myproject:setenv&#39;.
&gt; &gt; A problem occurred starting process &#39;command &#39;export&#39;&#39;

I also tried this:

    test.doFirst {
        ProcessBuilder pb1 = new ProcessBuilder(&quot;export SOME_TEST_VAR=some test value&quot;)
        pb1.start();
    }

The build succeeds. However, if I check the environment variable in my JUnit test it fails:

    assertTrue(System.getenv().containsKey(&quot;SOME_TEST_VAR&quot;));

Is there any way to set an environment variable from a Gradle build (in the build.gradle file)?

**Update:**

I&#39;ve tested it in isolation: the values do get passed and my test task receives everything, be it a systemProperty, environment variables or jvmArgs.  

So, it&#39;s nothing wrong with Gradle itself here.  

The problem arises when I&#39;m trying it on the real project. It uses Spring for dependency injection. I may be wrong but it looks like the Spring framework purges those values somewhere.  

That sub-project is currently being frozen and I can&#39;t check my guess in detail right now.


How to set an environment variable from a Gradle build?

I am not sure why this is happening but I cannot update brew in my MAC OS X El Capitan. I did:

`brew update`

and got:

    warning: unable to unlink CONTRIBUTING.md: Permission denied
    warning: unable to unlink SUPPORTERS.md: Permission denied
    fatal: cannot create directory at &#39;.github&#39;: Permission denied

to go over that issue I sudoed the above command but got further issues:

    sudo brew update
    Password:
    /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;: cannot load such file -- mach (LoadError)
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /usr/local/Library/Homebrew/extend/pathname.rb:2:in `&lt;top (required)&gt;&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /usr/local/Library/Homebrew/global.rb:3:in `&lt;top (required)&gt;&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /usr/local/Library/brew.rb:16:in `&lt;main&gt;&#39;

now whenever I do brew install I get:

    brew update

    /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;: cannot load such file -- mach (LoadError)
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /usr/local/Library/Homebrew/extend/pathname.rb:2:in `&lt;top (required)&gt;&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /usr/local/Library/Homebrew/global.rb:3:in `&lt;top (required)&gt;&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require&#39;
    	from /usr/local/Library/brew.rb:16:in `&lt;main&gt;&#39;

in fact, it seems that whenever I do anything, like just type `brew` it gets the same message. Does anyone know how to fix this?

Cannot update brew in MAC OS X el capitan and keep getting a Load error with `require`

I keep getting this weird message, while executing **any** query in command prompt `MySQL`.

    ignoring query to other database

I have already tried changing the database by issuing the `&quot;use database_name&quot;` command. 


&quot;Ignoring query to other database&quot; Command line

I keep getting this weird message, while executing any query in command prompt <code>MySQL</code>.
<pre><code class="hljs language-css">ignoring query to other database
</code></pre>
I have already tried changing the database by issuing the <code>"use database_name"</code> command.

In one of my project, I am planning to use ElasticSearch with MySQL.
I have successfully installed ElasticSearch. I am able to manage index in ES separately. but I don&#39;t know how to implement the same with MySQL.

I have read a couple of documents but I am a bit confused and not having a clear idea.



How to integrate ElasticSearch with MySQL?

Let&#39;s say I have a JSON column named **data** in some MySQL table, and this column is a single *array*. So, for example, data may contain:

&gt; [1,2,3,4,5]

Now I want to select all rows which have a data column where one of its array elements is greater than 2. Is this possible?

I tried the following, but seems it is always *true* regardless of the values in the array:

    SELECT * from my_table
    WHERE JSON_EXTRACT(data, &#39;$[*]&#39;) &gt; 2;

How to search JSON array in MySQL?

It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules.

I would like to turn this off.

I&#39;ve tried changing the validate_password_length variable as suggested [here][1] to no avail.

    mysql&gt; SET GLOBAL validate_password_length=4;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql&gt; SET PASSWORD FOR &#39;app&#39; = PASSWORD(&#39;abcd&#39;);
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

I would like to either unload the plugin or neuter it somehow.

  [1]: https://stackoverflow.com/a/34913583/2341218


How do I turn off the mysql password validation?

I&#39;m running MySql Server 5.7.11 and this sentence:

    updated datetime NOT NULL DEFAULT &#39;0000-00-00 00:00:00&#39;

is **not** working. Giving the error:

    ERROR 1067 (42000): Invalid default value for &#39;updated&#39;

But the following: 

    updated datetime NOT NULL DEFAULT &#39;1000-01-01 00:00:00&#39;

**just works**.  

The same case for DATE.

As a *sidenote*, it is mentioned in the [MySQL docs][1]:  

&gt; The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in &#39;YYYY-MM-DD&#39; format. The supported range is &#39;1000-01-01&#39; to &#39;9999-12-31&#39;.  

even if they also say:

&gt; Invalid DATE, DATETIME, or TIMESTAMP values are converted to the “zero” value of the appropriate type (&#39;0000-00-00&#39; or &#39;0000-00-00 00:00:00&#39;).
  
Having also into account the second quote from MySQL documentation, could anyone let me know why it is giving that error?  




  [1]: http://dev.mysql.com/doc/refman/5.7/en/datetime.html   





Error in MySQL when setting default value for DATE or DATETIME

When creating new tables and a user to go along with it, I usually just invoke the following commands:

    CREATE DATABASE mydb;
    GRANT ALL PRIVILEGES ON mydb.* TO myuser@localhost IDENTIFIED BY &quot;mypassword&quot;;

I have never ever needed to utilize the `FLUSH PRIVILEGES` command after issuing the previous two commands. Users can log in and use their database and run PHP scripts which connect to the database just fine. Yet I see this command used in almost every tutorial I look at.

When is the `FLUSH PRIVILEGES` command really needed and when is it unnecessary?

Content Type	Original Author	Original Content on Stackoverflow
Question	Mohd Abdul Mujib	View Question on Stackoverflow
Solution 1 - Mysql	Mohd Abdul Mujib	View Answer on Stackoverflow

"Ignoring query to other database" Command line

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Cannot update brew in MAC OS X el capitan and keep getting a Load error with `require`

How to set an environment variable from a Gradle build?

Attributions