I had the same problem with git bash and mysql, and solution to this is to use

    winpty mysql -u root

I guess this is because you are running mysql for windows, using unix environment, and as far as I know winpty should be used for running windows applications in the git bash (not 100% sure, maybe someone can confirm).


**A Quick fix for other users facing that issue too:**

You can create a `.bash_profile` to config git bash, to always use `winpty` by default :


    cd ~ &amp;&amp; echo &quot;alias mysql=\&quot;winpty mysql\&quot;&quot; &gt; .bash_profile


if you already have a `.bash_profile` in your user folder use this command instead:

    cd ~ &amp;&amp; echo &quot;alias mysql=\&quot;winpty mysql\&quot;&quot; &gt;&gt; .bash_profile



Create a shortcut in Windows Desktop with this destination:

&quot;C:\Program Files\Git\usr\bin\mintty.exe&quot; -e &quot;C:\Program Files\Git\usr\bin\winpty.exe&quot; &quot;C:\Program Files (x86)\MariaDB 10.1\bin\mysql.exe&quot; -uroot -p


I faced the same problem before....
Just use the simple cammand:

    winpty mysql -u root -p

Then press enter and the terminal asks for the password, enter your password and then it connects, the bash to the mysql server.

I have a table in my database, which contains character varying column and this column has json. I need to write a query, which will somehow parse this json into separate columns.

I found **json_each** function [here][1] but I can&#39;t understand how to work with it.

  [1]: http://www.postgresql.org/docs/9.3/static/functions-json.html

How to parse JSON in postgresql

So, reStructuredText is
[the recommended way](https://www.python.org/dev/peps/pep-0287) for Python code
documentation, if you try hard enough, you can
[find in the sphinx documentation](http://www.sphinx-doc.org/en/master/usage/restructuredtext/domains.html#python-signatures)
how to normalize your function signature documentation. All given examples are
single-line, but what if a parameter description is multi-line like the following
?

    def f(a, b):
        &quot;&quot;&quot; Does something with a and b

        :param a: something simple
        :param b: well, it&#39;s not something simple, so it may require more than eighty
                  chars
        &quot;&quot;&quot;

What is the syntax/convention for that ? Should I indent or not ? will it break reSTructuredText rendering ?


Multi-line description of a parameter description in python docstring

I&#39;ve installed Git (bash?) from www.git-scm.com
I also have a working installation of MySQL. I&#39;m using windows 8.1. The path to my mysql bin directory IS in my path environment variable, and the mysql service IS running.

If i open cmd.exe and type in `mysql -u root` then it logs me in successfully, I get the &quot;welcome to mysql monitor&quot; message, and i can start typing sql away.

However in Git bash, if I type in `mysql -u root` then it just starts a new blank link and doesn&#39;t do anything.

If i type in `mysql -?` then i still get the mysql help information. If i type in `mysql start`, I get the `Access denied for user &#39;&#39;@&#39;localhost&#39; to database &#39;start&#39;`.

How can I access mysql properly in git bash?

Please see my crude image explaining my situation below:

[![enter image description here][1]][1]


  [1]: http://i.stack.imgur.com/3gl4k.png

Git Bash mysql blank

I've installed Git (bash?) from <a href="http://www.git-scm.com" target="_blank" rel="noopener noreferrer">www.git-scm.com</a>
I also have a working installation of MySQL. I'm using windows 8.1. The path to my mysql bin directory IS in my path environment variable, and the mysql service IS running.
If i open cmd.exe and type in <code>mysql -u root</code> then it logs me in successfully, I get the "welcome to mysql monitor" message, and i can start typing sql away.
However in Git bash, if I type in <code>mysql -u root</code> then it just starts a new blank link and doesn't do anything.
If i type in <code>mysql -?</code> then i still get the mysql help information. If i type in <code>mysql start</code>, I get the <code>Access denied for user ''@'localhost' to database 'start'</code>.
How can I access mysql properly in git bash?
Please see my crude image explaining my situation below:
<a href="http://i.stack.imgur.com/3gl4k.png" target="_blank" rel="noopener noreferrer"><img src="http://i.stack.imgur.com/3gl4k.png" alt="enter image description here"></a>

I wanted to implement a notification system for our school, it&#39;s a php/mysql webapp that is not opened for public, so it doesn&#39;t receive much traffic. &quot;daily 500-1000 visitor&quot;.

**1. My initial approach was using MYSQL triggers:**

I used a Mysql `AFTER INSERT trigger` to add records to a table named `notifications`. Something like.

    &#39;CREATE TRIGGER `notify_new_homwork` AFTER INSERT ON `homeworks`
     FOR EACH ROW INSERT INTO `notifications` 
        ( `from_id`, `note`, `class_id`) 
     VALUES 
        (new.user_id, 
            concat(&#39;A New homework Titled: &quot;&#39;,left(new.title,&#39;50&#39;),
            &#39;&quot;.. was added&#39; )
        ,new.subject_id , 11);&#39;

This kind of black magic worked very well, yet i couldn&#39;t keep track of if this notification is new &quot;to show count of new notifications for user&quot;.
so i added a page named notifications.

Notifications are retrieved with something like

    SELECT n.* from notifications n 
    JOIN user_class on user_class.class_id = n.class_id where user_class.user_id = X;

Note: table user_class link user to class &quot;user_id,class_id,subject_id&quot; -subject is null unless user is a teacher&#39;

Now my next challenges are.

 1. how to keep track of new vs old notifications per user?
 2. how can i aggregate notifications that are similar to user into one row ? 

example if 2 user commented on something, then do not insert a new row, just update the old one with something like &#39;userx and 1 other commented on hw&#39;.

Thanks alot

**Edit**

As per answer below, to set a read/unread flag on row, i will need to have a row for each student not just a row for the whole class.. which means editing the trigger to something like

    insert into notifications (from_id,note,student_id,isread)
    select new.user_id,new.note,user_id,&#39;0&#39; from user_class where user_class.class_id = new.class_id group by user_class.user_id

Notification system using php and mysql

I am trying to setup webserver with `PHP 7 RC3` + `Nginx` on `Ubuntu 14.04` (for test purposes).

I installed Ubuntu in Vagrant using `ubuntu/trusty64` and PHP 7 RC 3 from Ondřej Sur&#253; (https://launchpad.net/~ondrej/+archive/ubuntu/php-7.0).

I can not find the way to install `MySQL PDO` (PHP sees `PDO` class but not anything related to MySQL, like `PDO::MYSQL_ATTR_DIRECT_QUERY` etc.)

Looks like there is no lib `php7.0-mysql` (by analogy with standard `php5-mysqlnd` and `php7.0-fpm` etc. from Ondřej)

Section `PDO` in `phpinfo()`:

    PDO support	     enabled
    PDO drivers	     no value

How can I get it?

PHP 7 RC3: How to install missing MySQL PDO

I am learning MySQL and tried using a `LOAD DATA` clause. When I used it as below:

    LOAD DATA INFILE &quot;text.txt&quot; INTO table mytable;

I got the following error:

&gt; The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

How do I tackle this error?

I have checked [another question on the same error message][1], but still can’t find a solution.

I am using MySQL 5.6

  [1]: https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option

How should I resolve --secure-file-priv in MySQL?

I have downloaded the Connector/Python for MySQL successfully. I used the following code in Python&#39;s shell to test my connection:

`import mysql.connector`

I received the following error message: 

    Traceback (most recent call last):
      File &quot;&lt;pyshell#8&gt;&quot;, line 1, in &lt;module&gt;
        import mysql.connector
    ImportError: No module named &#39;mysql&#39;

I can&#39;t figure out why MySQL is not being recognized.

ImportError: No module named &#39;MySQL&#39;

*(It&#39;s probably a dumb question due to my limited knowledge with Docker or mysql administration, but since I spent a whole evening on this issue, I dare to ask it.)*

**In a nutshell**

I want to run mysql in a docker container and connect to it from my host. So far, the best I have achieved is:

    ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/var/run/mysqld/mysqld.sock&#39; (2)

**More details**

I&#39;m using the following `Dockerfile`:

    FROM ubuntu:14.04.3
    RUN apt-get update &amp;&amp; apt-get install -y mysql-server

    # Ensure we won&#39;t bind to localhost only
    RUN grep -v bind-address /etc/mysql/my.cnf &gt; temp.txt \
      &amp;&amp; mv temp.txt /etc/mysql/my.cnf

    # It doesn&#39;t seem needed since I&#39;ll use -p, but it can&#39;t hurt
    EXPOSE 3306

    CMD /etc/init.d/mysql start &amp;&amp; tail -F /var/log/mysql.log

In the directory where there is this file, I can succesfully build the image and run it with:

    &gt; docker build -t my-image .
    &gt; docker run -d -p 12345:3306 my-image

When I attach to the image, it seems to work just fine:

    # from the host
    &gt; docker exec -it &lt;my_image_name&gt; bash
    
    #inside of the container now
    $ mysql -u root
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    [...]

However I don&#39;t have that much success from the host:

    &gt; mysql -P 12345 -uroot
    ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/var/run/mysqld/mysqld.sock&#39; (2)


**Even more details**

 - I&#39;ve seen that there&#39;s a question which [looks like mine][1]. However, it isn&#39;t the same (and it doesn&#39;t have any answers anyway)
  - I&#39;ve seen that there are images [dedicated to mysql][2], but I didn&#39;t have more success with them
  - My `grep -v` may feel weird. Admittedly, there may be cleaner way to do it. But when I attach my image, I can observe it actually worked as expected (ie: removed the `bind-address`). And I can see in the container `/var/log/mysql/error.log`:


&gt;   Server hostname (bind-address): &#39;0.0.0.0&#39;; port: 3306
      - &#39;0.0.0.0&#39; resolves to &#39;0.0.0.0&#39;;
    Server socket created on IP: &#39;0.0.0.0&#39;.


  [1]: https://stackoverflow.com/q/25069860/1796345
  [2]: https://github.com/sameersbn/docker-mysql

Connect to mysql in a docker container from the host

I am generating a self-signed SSL certificate with OpenSSL (not makecert), for use in IIS.

    openssl req -x509 -newkey rsa:2048 -keyout key.pem -out cert.pem -days 365 -nodes -subj &#39;//CN=myhost&#39;

(The double slash is correct. The command above does not work without that.)

    openssl pkcs12 -export -out key.pfx -inkey key.pem -in cert.pem -name &#39;myhost&#39;

The first command runs completes successfully. However the second get stuck with 

&gt; Loading &#39;screen&#39; into random state -

I am using OpenSSL (1.0.2d) that comes with Git for Windows (2.6.3).
Anyone experiences the same issue?

*Clarification:* Question https://stackoverflow.com/questions/12507277/how-to-fix-unable-to-write-random-state-in-openssl describes different -- problem with writing the the .rnd file. Here the problem seems to be generating the random state. (And only in the second command.)

OpenSSL hangs during PKCS12 export with &quot;Loading &#39;screen&#39; into random state&quot;

When I punch from the windows gitbash command line:

    set $HOME = c

and do :

    echo $HOME

It does not set it to `c`? How can I change/set the value of an environment variable?

Set an environment variable in git bash

I&#39;m on a Windows machine using Git 2.7.2.windows.1 with MinGW 64.

I have a script in `C:/path/to/scripts/myScript.sh`.

How do I execute this script from my Git Bash instance?

It was possible to add it to the `.bashrc` file and then just execute the entire bashrc file.

But I want to add the script to a separate file and execute it from there.



Running .sh scripts in Git Bash

On my windows machine `git stash` has about 3.5 seconds overhead on each invocation, which adds about 7 seconds to my git commit hook.

The same command under linux (same machine) takes about 0.01 seconds. The performance issue applies to empty repositories as well.

I have tried the following from [this thread](https://stackoverflow.com/questions/4485059/git-bash-is-extremely-slow-in-windows-7-x64) and [this thread](https://stackoverflow.com/questions/2835775/msysgit-bash-is-horrendously-slow-in-windows-7/2967519#2967519):

- `core.fscache` is set to `true`
- `core.preloadindex` is set to `true`
- `gc.auto` is set to `256`
- Setting PS1=&#39;$ &#39;
- Running cmd in administration mode
- Running inside *cmd.exe* instead of git-bash

Running `GIT_TRACE=true git stash list`


    16:58:16.844591 git.c:563               trace: exec: &#39;git-stash&#39; &#39;list&#39;
    16:58:16.844591 run-command.c:336       trace: run_command: &#39;git-stash&#39; &#39;list&#39;
    16:58:19.699591 git.c:350               trace: built-in: git &#39;rev-parse&#39; &#39;--git-dir&#39;
    16:58:19.859591 git.c:350               trace: built-in: git &#39;rev-parse&#39; &#39;--git-path&#39; &#39;objects&#39;
    16:58:20.069591 git.c:350               trace: built-in: git &#39;rev-parse&#39; &#39;--show-toplevel&#39;
    16:58:20.154591 git.c:350               trace: built-in: git &#39;rev-parse&#39; &#39;--git-path&#39; &#39;index&#39;
    16:58:20.244591 git.c:350               trace: built-in: git &#39;config&#39; &#39;--get-colorbool&#39; &#39;color.interactive&#39;
    16:58:20.334591 git.c:350               trace: built-in: git &#39;config&#39; &#39;--get-color&#39; &#39;color.interactive.help&#39; &#39;red bold&#39;
    16:58:20.424591 git.c:350               trace: built-in: git &#39;config&#39; &#39;--get-color&#39; &#39;&#39; &#39;reset&#39;
    16:58:20.514591 git.c:350               trace: built-in: git &#39;rev-parse&#39; &#39;--verify&#39; &#39;--quiet&#39; &#39;refs/stash&#39;
    
    real    0m3.845s
    user    0m0.000s
    sys     0m0.047s


Running `GIT_TRACE_PERFORMANCE=true git stash list`


    16:59:18.414591 trace.c:420             performance: 0.001078046 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;rev-parse&#39; &#39;--git-dir&#39;                                          
    16:59:18.569591 trace.c:420             performance: 0.000947184 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;rev-parse&#39; &#39;--git-path&#39; &#39;objects&#39;                               
    16:59:18.779591 trace.c:420             performance: 0.001253627 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;rev-parse&#39; &#39;--show-toplevel&#39;                                    
    16:59:18.869591 trace.c:420             performance: 0.001285517 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;rev-parse&#39; &#39;--git-path&#39; &#39;index&#39;                                 
    16:59:18.955591 trace.c:420             performance: 0.001139994 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;config&#39; &#39;--get-colorbool&#39; &#39;color.interactive&#39;                   
    16:59:19.040591 trace.c:420             performance: 0.001182881 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;config&#39; &#39;--get-color&#39; &#39;color.interactive.help&#39; &#39;red bold&#39;       
    16:59:19.125591 trace.c:420             performance: 0.001128997 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;config&#39; &#39;--get-color&#39; &#39;&#39; &#39;reset&#39;                                
    16:59:19.215591 trace.c:420             performance: 0.001567766 s: git command: &#39;C:\Program Files\Git\mingw64\libexec\git-core\git.exe&#39; &#39;rev-parse&#39; &#39;--verify&#39; &#39;--quiet&#39; &#39;refs/stash&#39;                    
    16:59:19.295591 trace.c:420             performance: 3.730583540 s: git command: &#39;C:\Program Files\Git\mingw64\bin\git.exe&#39; &#39;stash&#39; &#39;list&#39;                                                                
                                                                                                                                                                                                              
    real    0m3.819s                                                                                                                                                                                          
    user    0m0.000s                                                                                                                                                                                          
    sys     0m0.062s                                                                                                                                                                                          


From the log we see that it takes around 3 seconds between the git-stash command is run and the git-rev-parse is run. Are there any other flags I can run to find the bottleneck?

git stash is slow on windows

I was trying to navigate to my drive location `E:/Study/Codes` in `git bash` in windows. In command prompt in order to change drive I use `E:` It returns an error in `git bash`. 

&gt; bash: E:: command not found.

 How do I change my current directory location from `/c/users` to `E:Study/Codes`

Content Type	Original Author	Original Content on Stackoverflow
Question	Phil Cross	View Question on Stackoverflow
Solution 1 - Mysql	piotrgajow	View Answer on Stackoverflow
Solution 2 - Mysql	AliReza Sabouri	View Answer on Stackoverflow
Solution 3 - Mysql	Ignacio Gutiérrez Torrero	View Answer on Stackoverflow
Solution 4 - Mysql	Vinay Garg	View Answer on Stackoverflow

Git Bash mysql blank

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Multi-line description of a parameter description in python docstring

How to parse JSON in postgresql

Attributions