For complete steps on how to install MySQL 5.7 on Redhat, you may refer to this link
In this blog, I will show you specifically how simple it is to resolve the dependency issues that you might encounter while installing MySQL 5.7 on RedHat 6 using RPM.
Below are the dependency errors I encountered during installation.
The solution is simple. Just put the option –nodep at the end of the rpm command.
# rpm -ivh mysql-commercial-embedded-devel-5.7.21-1.1.el6.x86_64.rpm --nodeps
That’s it.
Cheers
1. Download the latest patch for MySQL in My Oracle Support. I choose MySQL installer for the integrated installer for windows.
1.1. Go to Patches & Updates. Chooose Product or Family (Advanced). Type MySQL Server on Products. Expand the options in the Release drop down and choose your desired release. Choose Microsoft Windows x64 in Platform option.
1.2. Choose the latest patch.
1.3. Click Download
2. Verify the current version
3. Backup databases
4. Double click on the patch
5. Click Next >
6. I will choose to upgrade all components. Click Next >
7. Click Execute.
8. Click Next >
9. Click Next >
10. Enter root password then click Check. If the connection succeeded, Click Next >
11. Click Execute
12. Click Finish
13. Verify new MySQL version. Click Next >
14. Click Finish
This is how I upgrade the patch of our MySQL database on windows. Just be sure to backup your databases and/or if your server is a VM, ask your Windows Admin team to perform a VM snapshot of the server before you apply the patch.
Cheers!
NOTE: SQL Server Management Studio is not part of the SQL Server 2016 media anymore Please download it here
1. Download SQL Server 2016 Developer Edition. I downloaded SQL Server 2016 Developer Edition using my MSDN account.
Alternatively you may go this link to get the SQL Server 2016 Evaluation.
2. Right-click then Run SQL Server 2016 setup as administrator.
3. Choose Installation on the left-pane then click New SQL Server stand-alone installation… (the first choice).
4. I’m installing a Developer edition (free) hence there is no need to enter a product key. Click Next.
5. Accept the license terms then click Next.
6. I opted not to tick User Microsoft Updates. Click Next.
7. Ignore the warning about Windows Firewall. This means that the Windows Firewall for Database Engine Access is not yet configured. We can do that later. Click Next.
8. Select the necessary features that you need. You can read the descrption in the feature description box.
9. Choose Default instance if you are not going to create multiple instances of SQL Server on the same machine. Otherwise go for Named Instance. Click Next.
10. Enter the service accounts that you will use to run SQL Services. I’ve set the Startup Type to Automatic for all components.
11. Go to the Collation tab. I’ve accepted the defaults because this is exactly what our application needs. Some application require you to choose a specific collation. You can click Customize to change it. Click Next.
12. I’ve chosen Mixed Mode. This is highly recommended so that there is an additional built in SA accout with a separate user name and password. To add users such as the one I’m using, click Add Current User. to allow account to log into SQL Server.
13. I left the Data Directories to defaults. Though it can be changed if you have a multiple disk environment. Additionally, for better performance, you may want to separate out where different parts of the DBMS go.
14. Configure multiple tempDB data files. This is to increase the I/O throughput to tempdb. When you create multiple data files, they will all be in the primary filegroup and SQL Server uses a proportional fill algorithm to determine which file to use for each request to create an object. If all the files are exactly the same size, then SQL Server uses the files in a “round robin” fashion, spreading the load equally across the files. As a general guideline, create one data file for each CPU on the server and then adjust the number of files up or down as necessary.
15. I did not enable FILESTREAM but you may want to if you plan to explore large file types such as BLOB. Click Next.
16. If you have selected Analysis Services component, you will be shown with the following screen. Select the Multidimensional and Data Mining Mode. Click Add Current User. Click Next.
17. Leave the Data Directories to default. Click Next.
18. If you have selected Reporting Services component, you will be presented with the following screen. I chose Install only. We will configure it later. Click Next.
19. Review selected features and click Install.
20. Once completed. Click Close.
