Working Ninja
2018-06-29T20:53:23

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 ...

READ MORE

2014-04-05T17:40:11

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.

Configuring Apache

Apache comes preinstalled with OS X so I decided to stick with ...

READ MORE

2015-12-29T16:18:56

Run the following from a terminal to tighten down the security on your MySQL installation:

# mysql_secure_installation

READ MORE

2016-03-31T22:34:52

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 ...

READ MORE

2016-04-06T20:13:12

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

READ MORE