<p>I am trying to build kubeflow pipeline</p>
<p>metadata-deployment</p>
<p>When Kubeflow connected data, the following questions occurred. What do I need to operate? I have now set up the database and the user password is confirmed to be correct</p>
<blockquote>
<p><strong>That's official ⬇️</strong></p>
</blockquote>
<pre><code>apiVersion: v1
data:
  password: aG05WGJCb2s3ZEdUNDR0eQ==
  username: YWRtaW4=
kind: Secret
metadata:
  name: mysql-credential
  namespace: kubeflow
type: Opaque

------------------
env:
- name: DBCONFIG_USER
  valueFrom:
    secretKeyRef:
      key: username
      name: mysql-credential
- name: DBCONFIG_PASSWORD
  valueFrom:
    secretKeyRef:
      key: password
      name: mysql-credential
</code></pre>
<p>And so is my configuration</p>
<blockquote>
<p>LOG ERROR  😢</p>
</blockquote>
<pre><code>2020-09-27 10:16:51.065292: F ml_metadata/metadata_store/metadata_store_server_main.cc:178] Non-OK-status: ml_metadata::CreateMetadataStore(connection_config, &amp;metadata_store) status: Internal: mysql_real_connect failed: errno: 1045, error: Access denied for user 'admin'@'10.22.0.185' (using password: YES)MetadataStore cannot be created with the given connection config.
</code></pre>

Mixc
<p>Try to:</p>
<ul>
<li>Check for typo error: username or password.</li>
<li>Check the host name and compare it with mysql.user table host name</li>
<li>Check user exists or not.</li>
<li>Check whether host contains IP address or host name.</li>
<li>Check if mysql DB works.<br />
Run:  <code>mysql -D ${MYSQL_DATABASE} -u root -p${MYSQL_ROOT_PASSWORD} -e 'SELECT 1'</code>  on  <code>mysql</code>  pod</li>
<li>Check that PVC is properly bounded:  <code>kubectl get pvc mysql -n kubeflow</code></li>
<li>Check the volume are you using for the mysql PV -
If it is local hostPath, try to delete directory on the k8s cluster node</li>
</ul>
<p>See more: <a href="https://stackoverflow.com/a/47279949/11300382">mysql-errno-1045</a>.</p>
<p>Take a look: <a href="https://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw">access-denied-mysql</a>,  <a href="https://github.com/kubeflow/kubeflow/issues/4610" rel="nofollow noreferrer">kubeflow-mysql-pipeline</a>, <a href="https://github.com/kubeflow/katib/issues/1212" rel="nofollow noreferrer">kubeflow-mysql</a>.</p>
