Mysqldb python install in ubuntu

Getting python MySQLdb to run on Ubuntu

Do I need to install mysql package separately? Note the IPv4 address, under «Ethernet adapter Ethernet:».

Getting python MySQLdb to run on Ubuntu

I created a virtualbox with a fresh install of ubuntu 9.10.

I am trying to get MySQLdb to run on python but I’m failing at the import MySQLdb

I first tried sudo easy_install MySQL_python-1.2.3c1-py2.6-linux-i686.egg and then sudo apt-get install python-mysqldb .

Both apparently installed ok, but gave me the following error message when in python I have the import line:

Traceback (most recent call last): File "", line 1, in File "/usr/local/lib/python2.6/dist-packages/MySQL_python-1.2.3c1-py2.6-linux-i686.egg/MySQLdb/__init__.py", line 19, in File "/usr/local/lib/python2.6/dist-packages/MySQL_python-1.2.3c1-py2.6-linux-i686.egg/_mysql.py", line 7, in File "/usr/local/lib/python2.6/dist-packages/MySQL_python-1.2.3c1-py2.6-linux-i686.egg/_mysql.py", line 6, in __bootstrap__ ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory 

I have already installed MySQL and it is running, if that matters at all. I tried following this, but failed in step 2

Your MySQLdb egg installation looks like it is not working properly. You should go into /usr/local/lib/python2.6/dist-packages and remove it.

The Ubuntu python-mysqldb package should work fine. Unless you have a good reason, you should stick to your distribution’s package manager when installing new software.

Getting python MySQLdb to run on Ubuntu, Your MySQLdb egg installation looks like it is not working properly. You should go into /usr/local/lib/python2.6/dist-packages and remove it. The Ubuntu python-mysqldb package should work fine. Unless you have a good reason, you should stick to your distribution’s package manager when installing …

Migrate django mysqlite database to mysql in ubuntu

I tried to migrate django mysqlite database mysql database.but can’t migrate sqlite to mysql. i tried all the solutions but no use.

Traceback (most recent call last): File "./manage.py", line 15, in execute_from_command_line(sys.argv) File "/usr/local/lib/python3.6/dist-packages/django/core/management/__init__.py", line 371, in execute_from_command_line utility.execute() File "/usr/local/lib/python3.6/dist-packages/django/core/management/__init__.py", line 365, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python3.6/dist-packages/django/core/management/base.py", line 288, in run_from_argv self.execute(*args, **cmd_options) File "/usr/local/lib/python3.6/dist-packages/django/core/management/base.py", line 335, in execute output = self.handle(*args, **options) File "/usr/local/lib/python3.6/dist-packages/django/core/management/commands/migrate.py", line 79, in handle executor = MigrationExecutor(connection, self.migration_progress_callback) File "/usr/local/lib/python3.6/dist-packages/django/db/migrations/executor.py", line 18, in __init__ self.loader = MigrationLoader(self.connection) File "/usr/local/lib/python3.6/dist-packages/django/db/migrations/loader.py", line 49, in __init__ self.build_graph() File "/usr/local/lib/python3.6/dist-packages/django/db/migrations/loader.py", line 206, in build_graph self.applied_migrations = recorder.applied_migrations() File "/usr/local/lib/python3.6/dist-packages/django/db/migrations/recorder.py", line 61, in applied_migrations if self.has_table(): File "/usr/local/lib/python3.6/dist-packages/django/db/migrations/recorder.py", line 44, in has_table return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()) File "/usr/local/lib/python3.6/dist-packages/django/db/backends/base/base.py", line 255, in cursor return self._cursor() File "/usr/local/lib/python3.6/dist-packages/django/db/backends/dummy/base.py", line 20, in complain raise ImproperlyConfigured("settings.DATABASES is improperly configured. " django.core.exceptions.ImproperlyConfigured: settings.DATABASES is improperly configured. Please supply the ENGINE value. Check settings documentation for more details. 

I tried all type of solution.I didn’t add any data.my code was just initial stage

Anyone please help why this error was occurred ?

Try correcting the spelling of DATABASES, you have written DATABSES

There is typo mistake in spelling of DATABASES .

How to use MySQLdb with Python and Django in OSX 10.6?, The following worked perfectly for me, running Ubuntu 13.10 64-bit: sudo apt-get install libmysqlclient-dev sudo apt-get install python-dev. Now, navigate to your virtualenv (such as env folder) and execute the following: sudo ./bin/pip install mysql-python. I actually found the solution in a separate question and I am …

How do I connect mysql to python in pycharm. I currently use Ubuntu 20.04?

Can someone please help me connecting python to mysql. I am new to Ubuntu OS and don’t know much about it. I use PyCharm IDE . I installed mysql on my system and also installed the mysql.connector module correctly( pip3 isntall mysql-connector-python ) But it fails t connect and gives the error as follows: mysql.connector.errors.NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported When I run the same code in VS code I get an error which reads: Traceback (most recent call last): File «/home/velocity-linux/Desktop/Main Folder/Project.py», line 1, in import mysql.connector ImportError: No module named mysql.connector Please tell what can I do The code which I use for connection is:

 mydb1 = mysql.connector.connect(host="localhost", user="root", passwd="home@253144", database="school")``` [1]: https://i.stack.imgur.com/aGXKQ.png 

It’s likely you’re getting the error in Visual Studio Code because you’re using a virtual environment in PyCharm.

The PyCharm error is the error you should be focusing on.

What imports are you using for this project? The error seems to be caused by an unsupported library, I am unsure if this is from your script or a script from the mysql-connector library.

Have you tried reinstalling mysql-connector with both python -m pip uninstall mysql-connector and python -m pip install mysql-connector ?

How To Install MySQL on Ubuntu 20.04, sudo systemctl start mysql.service These commands will install and start MySQL, but will not prompt you to set a password or make any other configuration changes. Because this leaves your installation of MySQL insecure, we will address this next. Step 2 — Configuring MySQL

Ubuntu — xampp — could not import database to mysql

I have a project which needs to be run on PHP 5.5. I created a virtual machine with Ubuntu. I have windows 10 on my machine. I could not found version of lamp supporting PHP 5.5, so I installed Xampp. It works and also phpmyadmin works. But when I try to import database from command line, it says — «The program ‘mysql’ can be found in the following packages. «. It asks to install the package. The client wants to stick to the current PHP version, until we are up and live with latest versions of PHP.

Do I need to install mysql package separately? Is it possible to use it with Xampp ?

Or can I connect to the database on host (windows 10) ?

I tried to remove the mysql related files and folders, but due to file permissions, I could not remove all. With less time in hand, I tried to connect to the host database (xampp installed on windows 10), and it worked. Here is what I did —

1. Run ipconfig (My host is windows 10).
2. Note the IPv4 address, under «Ethernet adapter Ethernet:».
3. Run following queries on host database (xampp installed on windows 10) — CREATE USER ‘yourusername’@’IPv4 address:port’ IDENTIFIED BY ‘yourpassword’; GRANT ALL PRIVILEGES ON . TO ‘yourusername’@’IPv4 address:port’ WITH GRANT OPTION; CREATE USER ‘yourusername’@’%’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON . TO ‘yourusername’@’%’ WITH GRANT OPTION; FLUSH PRIVILEGES;

While connecting, I used the IPv4 address:port as host, username = yourusername and password=password.

I hope this helps somebody.

How to find out with python on ubuntu if MySQL is running?, On Ubuntu this command line: sudo netstat -tap | grep mysql if MySQL is running returns something like that: tcp 0 0 localhost:mysql *:* LISTEN 6732/mysqld and nothing if it’s not. I’m using subprocess to find out from inside the python code if MySQL is up by looking for a «LISTEN» in what that netstat …

Источник

Installing MySQL for python 2 and 3 on Ubuntu

Install the correct MySQL package for either version 2 or 3 of Python in Ubuntu using pip.

NB! A more recent update to this tutorial has been published for installing the MySQL connector package in Python 2021.

Installing the MySQL connector package for Python can sometimes be a bit more of a struggle than it should be. There are two separate versions of the MySQL connector package that are used for either Python 2 or 3, you’ll need to download the correct package using pip as well as some necessary dependencies in order to use it on your version.

Installing MySQL for Python 2

If you are using Python 2.x, the package you’ll need is called MySQL-python. For this you will need to install the following

dependencies

sudo apt-get install build-essential python-dev libmysqlclient-dev

Before installing this package make sure you have

pip installed

for the correct version of Python. This can be achieved by including your version number within the package name.

sudo apt-get install python2-pip

install the MySQL connector

sudo pip2 install MySQL-python

If this did not work for any reason you can also attempt to

install it directly from the repository

as «python-mysqldb» instead of using pip.

sudo apt-get install python-mysqldb

Once it is installed you can

it into your Python script like so:

Installing MySQL for Python 3

If you are using Python 2.x, the package you’ll need is called mysql-connector. For this you will need to install the following

dependencies

sudo apt-get install build-essential python3-dev libmysqlclient-dev

Before installing this package make sure you have

pip installed

for the correct version of Python. This can be achieved by including your version number within the package name.

sudo apt-get install python3-pip

install the MySQL connector

sudo pip3 install mysql-connector

If this did not work for any reason you can also attempt to

install itdirectly from the repository

as «python3-mysql.connector» instead of using pip.

sudo apt-get install python3-mysql.connector

Once it is installed you can

it into your Python script like so:

Installing MySQL for Python can be quite a pain sometimes and there are often unforeseen errors that occur. If you are still getting errors when trying to install the package or Python is not recognizing the import,

leave a comment below for some help

Christopher Thornton @Instructobit 5 years ago

Источник

How To Install python3-mysqldb on Ubuntu 22.04

In this tutorial we learn how to install python3-mysqldb on Ubuntu 22.04.

What is python3-mysqldb

Mysqlclient is an interface to the popular MySQL database server for Python.

This is a fork of MySQLdb. It add Python 3.3 support and merges some pull requests.

This package contains modules for all Python 3.x versions supported in Debian.

There are three methods to install python3-mysqldb on Ubuntu 22.04. We can use apt-get , apt and aptitude . In the following sections we will describe each method. You can choose one of them.

Install python3-mysqldb Using apt-get

Update apt database with apt-get using the following command.

After updating apt database, We can install python3-mysqldb using apt-get by running the following command:

Install python3-mysqldb Using apt

Update apt database with apt using the following command.

After updating apt database, We can install python3-mysqldb using apt by running the following command:

Install python3-mysqldb Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.

After updating apt database, We can install python3-mysqldb using aptitude by running the following command:

How To Uninstall python3-mysqldb on Ubuntu 22.04

To uninstall only the python3-mysqldb package we can use the following command:

Uninstall python3-mysqldb And Its Dependencies

To uninstall python3-mysqldb and its dependencies that are no longer needed by Ubuntu 22.04, we can use the command below:

Remove python3-mysqldb Configurations and Data

To remove python3-mysqldb configuration and data from Ubuntu 22.04 we can use the following command:

Remove python3-mysqldb configuration, data, and all of its dependencies

We can use the following command to remove python3-mysqldb configurations, data and all of its dependencies, we can use the following command:

References

Summary

In this tutorial we learn how to install python3-mysqldb package on Ubuntu 22.04 using different package management tools: apt , apt-get and aptitude .

Источник