title: caching_sha2_password could not be loaded
body: <p>I have tried to connect to mysql server from C code.</p>
  
  <pre><code>#include &lt;mysql.h&gt;
  #include &lt;stdio.h&gt;
  #include &lt;stdlib.h&gt;
  main(){
      MYSQL *conn;
      MYSQL_RES *res;
      MYSQL_ROW row;
  
      char *server = "localhost";
      char *user = "root";
      char *password = "12345"; /* set me first */
      char *database = "mydatabase";
  
      conn = mysql_init(NULL);
      printf("done 1\n");
      if (!mysql_real_connect(conn, server,
           user, password, database, 3306, "/tmp/mysql.sock", 0)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
     }
      printf("done 2\n");
     if (mysql_query(conn, "show tables")) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
     }
      printf("done 3\n");
     res = mysql_use_result(conn);
      printf("done 4\n");
      printf("MySQL Tables in mysql database:\n");
      while ((row = mysql_fetch_row(res)) != NULL)
      printf("%s \n", row[0]);
      printf("done 5\n");
      mysql_free_result(res);
      mysql_close(conn);
  }
  </code></pre>
  
  <p>But I have this weird problem:</p>
  
  <pre><code>done 1
  Plugin caching_sha2_password could not be loaded: /usr//usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
  </code></pre>
  
  <p>I do not know why it tries to load lib from <em>/usr//usr/</em></p>
  
  <p>Please help if you have a deal with it already!   </p>