<p>我发现用<code>127.0.0.1</code>代替<code>localhost</code>解决了我的问题</p>
<p>安装MariaDB连接器/C,它是一个依赖项</p>
<pre><code>sudo apt-get install libmariadb3 libmariadb-dev
</code></pre>
<p>使用PIP安装MariaDB连接器/Python</p>
<pre><code>pip3 install mariadb
</code></pre>
<p>这两种方法对我都有效:</p>
<pre class="lang-py prettyprint-override"><code>import mariadb
import sys
try:
# connection parameters
conn_params = {
'user' : "harley",
'password' : "KTJ7UCS74mv]hh[I",
'host' : "127.0.0.1",
'port' : 3306,
'database' : "phishing_emails"
}
# establish a connection
connection = mariadb.connect(**conn_params)
cursor = connection.cursor()
except mariadb.Error as e:
print(f"Error connecting to MariaDB Platform: {e}")
sys.exit(1)
print(cursor)
</code></pre>
<p>或者</p>
<pre class="lang-py prettyprint-override"><code>import mariadb
import sys
# Connect to MariaDB Platform
try:
connection = mariadb.connect(
user = "harley",
password = "KTJ7UCS74mv]hh[I",
host = "127.0.0.1",
port = 3306,
database = "phishing_emails"
)
# Get Cursor
cursor = connection.cursor()
except mariadb.Error as e:
print(f"Error connecting to MariaDB Platform: {e}")
sys.exit(1)
print(cursor)
</code></pre>