Creating SSL MySQL from Windows

Assumed that you will going to install OpenSSL and you wish to apply to your MySQL if you are using Windows Operating System.

1. Download OpenSSL from URL here.
2. Once installation done, add your bin folder of the OpenSSL to your Environment Variable.
3. Open command prompt.
4. Follow the command as below.
cd \
openssl
If you see the result return is “OpenSSL>”, that mean you have successfully installed.
5. Open the MySQL command and refer to the following line.
shell> md c:\newcerts
shell> cd c:\newcerts
6. Test your certificate.
shell> mysqld –defaults-file=$DIR/my.cnf &

Reset MySQL 5.1 Root password

Sometimes you might want to reset your used password since it is used for long time.

To reset MySQL database password, you may need to consider different Operating System and it’s version will have minor differences during the root password reset.

Today, Mick Genie will guide you how to reset MySQL database v5.1  through Windows Operating System and Linux Operating System.

For Windows Operating System,
1. Firstly, create a text file and name it as resetpassword.txt and you may save it to C drive.
2. Enter the following word to your text file.

UPDATE mysql.user SET Password=PASSWORD('[email protected]') WHERE User='root';
FLUSH PRIVILEGES;

Continue reading Reset MySQL 5.1 Root password