After updating mysql-connector-python to 8.0.11 (released April 19, 2018), I received an "OperationalError: 1043 (08S01): Bad handshake" error when querying a MySQL database. I found that I needed to set 'use_pure: True' in the connection string.
From the MySQL folks:
The C extension was added in …
Commands like SHOW DATABASES and SHOW TABLES are great but what if I need all the columns inside a table?
SELECT column_name FROM information_schema.columns WHERE table_schema = 'your_db' ORDER BY table_name, ordinal_position;
Source: http://stackoverflow.com/questions/5648420/get-all-columns-from-all-mysql-tables
I must have it saved somewhere but it was nowhere to be found. The password was lost. My root account was forever secure--or was it?
# service mariadb stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
> USE mysql
> UPDATE user SET password=PASSWORD("mynewpassword") WHERE User='root';
> FLUSH PRIVILEGES …
Run the following from a terminal to tighten down the security on your MySQL installation:
# mysql_secure_installation
Here’s the lowdown on how I setup my MAMP (Mac, Apache, MySQL and PHP) server for local web development and the steps I went through to create a development environment for a site already in production.
Apache comes preinstalled with OS X so I decided to stick with …