#mysql5.5

Fixed: Cant connect to mysql using self signed SSL certificate #programming #dev #it

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled)

I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql server is 5.5.25)..

~> mysql -u -p ssl=1 ssl-cert=client.cert ssl-key=client.key ssl-ca=ca.cert Enter password: ERROR 2026 (HY000): SSL…

Answer: `mysql_upgrade` is failing with no real reason given #fix #dev #it

`mysql_upgrade` is failing with no real reason given

I’m upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output:

# mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed

Any ideas on where to look for what’s happening (or, not happening?) so I can fix whatever is wrong and actually run mysql_upgrade?

Thanks!

More…

Answer: `mysql_upgrade` is failing with no real reason given #solution #development #fix

`mysql_upgrade` is failing with no real reason given

I’m upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output:

# mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed

Any ideas on where to look for what’s happening (or, not happening?) so I can fix whatever is wrong and actually run mysql_upgrade?

Thanks!

More…

This tutorial is based on installing MySQL 5.5.8 on Linux with easy installation steps. 

MySQL 5.5.8 is the latest production-ready release of the most popular opensource database management system on the planet ie. MySQL.

In this tutorial, I am going to tell you how to download, configure, compile, and install MySQL 5.5.8 from source code on a Linux machine. Please prepare yourself to install several libraries on the server before installing MySQL 5.5.8. Luckily, I have already written about those libraries in my previous tutorials.