- #Python unofficial binaries how to
- #Python unofficial binaries install
- #Python unofficial binaries software
- #Python unofficial binaries code
- #Python unofficial binaries password
Here is my connection code: # Connect to the MySQL instanceĬon = mdb. So I updated my python code, in particular my connection parameters, to reflect the USER name as db_user and the HOST name as db_host. Sure enough the HOST name corresponding to the root user was localhost. Opened up the localhost instance and went to users and privileges. I had been using my Computer Name as my HOST, so I opened up my MySQL Workbench and logged in as the root user. The solution was that my HOST name was incorrect. In the USER column, find the user name you wish to establish your python connection with and also note the HOST name. Next, I typed in the following SQL in to the Command Line Client: SELECT USER, HOST FROM MYSQL.USER the default admin user with all privileges), so privileges was not the issue.
#Python unofficial binaries code
In my python code I was using root as my user (I.e. The first thing I did was to check my MySQL privileges, so I opened up my MySQL Command Line Client and typed in >SHOW GRANTS FOR results showed that the root user had all privileges. However one problem I encountered was the following access denied error: OperationalError: (1045, 'Access denied for user (using password: YES)')
#Python unofficial binaries password
Usually “password” but can also be the password for a different user. But can be some other user with less privileges. Check your MySQL Users and Privileges – User Accounts. Check your MySQL Users and Privileges – User Accounts. To get a Python program to connect to MySQL you need the following information: Getting a Python Program to Connect to MySQL With MySQL-python-1.2.3 installed correctly, opening Python2.7 IDLE GUI again and running a Python program will now be able to import the MySQL module. Running a Python program to Interact with MySQL While the compilation of RDKit on Linux or OS X is relatively straightforward, that on Windows is much more difficult.
#Python unofficial binaries software
RDKit is an excellent collection of cheminformatics and machine-learning software written in C++ and Python.
#Python unofficial binaries install
Note that if you attempt to install a 32bit version of MySQL-python it will not be able to find your 64bit version in the registry and fail. An unofficial binary of RDKit for Python3.6 and Windows. Finally, the installer found my 64-bit version of Python2.7 and installed properly. Download the MySQL-python-1.2.3.win-amd64-py2.7.exe and execute it. On Victor Jabur’s blog, scroll down to MySQLdb – Plugin Connector of Database MySQL to Python. Luckily I stumbled across an unofficial source/s: For Python 2.7 it must be the 2008 version because that’s the version the Python 2.7 uses.įinding an installer for MySQLdb for a 64-bit OS was particularly hard to find. To install MySQLdb for Python 2.7 / 64bit you must have Visual Studio 2008 installed, and in particular you need vcsetup.exe for the C compiler. Installing Python 2.7 for 64bit Windows Installing MySQL for Python 2.7 64bit If you need to do this follow the instructions here: Third, you need Python 2.7 for a 64bit OS installed. Second, you must ensure you have MySQL installed on your PC. All the following works will be done here.First you must ensure you have installed a C compiler. In Start Menu, open 圆4 Native Tools Command Prompt for VS 2017. You can get its source codes from here or its binary ( ). Preparations:ĭownload RDKit source code from here, for example, Source code (zip).
#Python unofficial binaries how to
Here is an instruction about how to compile RDKit for Python 3.6 and Windows (圆4). Now you are ready to use RDKit! How to compile RDKit for Python 3.6 and Windows (圆4)