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.
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 &
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';
Continue reading Reset MySQL 5.1 Root password