Questions tagged [libmysqlclient]

22 questions
5
votes
4 answers

Mysqlclient cannot install via pip, cannot find pkg-config name

I'm new to linux and VM's in general. Im currently trying to install mysqlclient on a clean Ubuntu Jammy 64 (22.4) vbox instance. The following commands are run beforehand: sudo add-apt-repository universe sudo apt-get install net-tools -y …
P.R
  • 141
  • 1
  • 5
3
votes
5 answers

library not found for -lzlib, mac m2 chip, pip install mysqlclient

I am running into this issue when I try to run pip install mysqlclient. I have already installed all the libraries necessary with brew and/or pip. I tried reinstalling zlib but nothing seems to be working. I tried downloading on brew mysql,…
2
votes
1 answer

Unable to install mysqlclient in Python3.9

I encountered the following error while trying to install mysqlclient using the command pip3 install mysqlclient System information: Python 3.9, GNU/Linux Ubuntu 20.04 running on WSL x86_64-linux-gnu-gcc -pthread -Wno-unused-result…
wishfulwiz
  • 23
  • 4
1
vote
2 answers

I can't install mysqlclient with pipenv

I'm trying to install "mysqlclient" package for my Django project. I'm on a virtual envrioment. When I enter this command pipenv install mysqlclient I get this error: Traceback (most recent call last): File…
RezaPanahi
  • 11
  • 1
1
vote
0 answers

Error while installing mysqlclient in server cpanel

I tried to install mysqlclient in venv in remote server's cpanel by pip install mysqlclient It showed me error Collecting mysqlclient Using cached mysqlclient-2.1.1.tar.gz (88 kB) Preparing metadata (setup.py) ... done Building…
mestu
  • 46
  • 2
1
vote
1 answer

MySQL: Insert special character in a string

I'm using the mysql client c library to insert values into my database. I'm inserting a special character (0xFF) as a separation char in my strings: char buffer[256]; char name[64] = "my_name"; char path[64] = "path/path"; path[4] = 255; //…
Cedric
  • 11
  • 3
1
vote
1 answer

mySQL return NO_DATA, but record exists

Trying to run the following std::wstring query1 = L"SELECT st.table_id FROM information_schema.INNODB_TABLES st WHERE st.name = ?;"; or std::wstring query1 = L"SELECT st.table_id FROM information_schema.INNODB_TABLES st WHERE st.name = CONCAT(?,…
Igor
  • 5,620
  • 11
  • 51
  • 103
1
vote
0 answers

Getting (2006, 'MySQL server has gone away error) in kafka consumer in my django application

I recently written a kafka consumer in my django project which is running in the background and there's a mysql query which reads inside the consumer and the process is very light as I don't have that much of data. But I'm getting (2006, 'MySQL…
D.Sunil
  • 21
  • 6
0
votes
2 answers

Unable to use MySql with Django

I am trying to get Django running with MySql, I am following this guide: https://docs.djangoproject.com/en/4.2/intro/tutorial02/ Everything works up until this command: python manage.py migrate I will include the entire error, the punchline…
Plegeus
  • 139
  • 11
0
votes
1 answer

SQLAlchemy is not connecting with flask app

When I connect my SQLAlchemy to flask app, it gives me the following error File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 152, in import_dbapi return…
0
votes
0 answers

Running into this ERROR when I try to migrate a workbench to an Azure MySQL server

dyld[55763]: Library not loaded: @executable_path/../Frameworks/libmysqlclient.dylib Referenced from: <75D8AA6C-EE86-3CFC-9881-04C24191CAD3> /Applications/MySQLWorkbench.app/Contents/MacOS/wbcopytables Reason: tried:…
0
votes
0 answers

Installing mysqlclient failed using pyproject.toml and poetry install

I have pyproject.toml in the root dir of my Streamlit app and I use poetry install to create the virtual environment and install dependencies. I am running into a problem installing mysqlclient because it throws this error: • Installing mysqlclient…
DanielAttard
  • 3,467
  • 9
  • 55
  • 104
0
votes
1 answer

I am getting raise ImproperlyConfigured( django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient?

My settings.py looks like this and I have created a db with name student in mysql. Despite having installed mysqlclient latest version I am getting this error. I tried with using other database setup but still got similar error. """ Django settings…
ar d
  • 51
  • 5
0
votes
0 answers

Macos M2 mysqlclient Symbol not found: _mysql_affected_rows

I'm setting up a new M2 MacBook and seem to be hitting the issue described for M1 here: https://github.com/PyMySQL/mysqlclient/issues/496 (tl;dr: the MySQLdb shared object library installed by pip and the mysqlclient dylib installed by brew are…
Scott
  • 1,247
  • 3
  • 10
  • 21
0
votes
0 answers

i am trying to create a venv but get a weird error even though I have everything installed (in VS)

`2023-05-12 14:26:14.216 [info] copying MySQLdb\constants\CLIENT.py -> build\lib.win32-cpython-38\MySQLdb\constants copying MySQLdb\constants\CR.py -> build\lib.win32-cpython-38\MySQLdb\constants copying MySQLdb\constants\ER.py ->…
1
2