Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The source code of MySQL contains a lot of internal documentation, which is written using Doxygen. This Doxygen content is available atahttps://dev.mysql.com/doc/index-other.html. This Doxygen content can be generated locally from a MySQl source distribution. This can be done by following the below mentioned steps −Install DoxygenThe first step is to install Doxygen 1.8.11 or a higher version of it. The distributions are available at https://www.doxygen.nl/.Once it has been installed, the version number has to be verified. This can be done using the below command −shell > doxygen −−version 1.8.13Install PlantUMLNext step is to install PlantUML. When this is installed on ... Read More
Let us understand how to downgrade binary and package-based installation on Unix or Linux. Downgrading binary and package based installations on Unix or Linux can be done in a variety of ways. They have discussed below.In-Place DowngradeIn-place downgrade involves shutting down the new MySQL version.Once this is done, the new MySQL binaries or packages are replaced with the old binaries or packages.Once this is done, the old MySQL version is restarted on the existing data directory.MySQL has to be configured to perform a slow shutdown by setting innodb_fast_shutdown to 0.The below command would do the same −mysql -u root -p ... Read More
Below are the steps mentioned to upgrade a MySQL installation −Upgrade the pathsPrepare the installation for an upgradeUpgrade the MySQL binary or package-based installation on Unix or LinuxMySQL can also be upgraded using MySQL yum repository or APT repository or SLES repository or on Windows.The next step is to upgrade the docker installation of MySQLUpgrade the troubleshootingThe tables or indexes have to be rebuilt or repaired.The MySQL databases have to be copied to the other machine.MySQL binary and package-based installations can be done on Unix or linux in many different ways. They have been mentioned below.In−place upgradeLogical upgradeMySQL cluster upgradeLet ... Read More
Let us see the post-installation set up and testing that needs to be done once MySQL has been successfully installed −Once MySQL has been installed, the below mentioned steps have to be performed.Data DirectoryIf required, the data directory has to be initialized and the MySQL grant tables have to be created. For certain MySQL installation methods, the data directory initialization is done automatically.MySQL InstallerThe Windows installation operations are performed by the MySQL installer. It can be installed on Linux using a server RPM or Debian distribution which is from Oracle. The installation can be done using the native packaging system ... Read More
Let us understand how MySQL can be installed from the source −MySQL can be built from source code. The advantage of this is that it allows the user to customize the build parameters, the compiler optimizations, and the installation location. The below link gives a list of systems on which MySQL can be run−https://www.mysql.com/support/supportedplatforms/database.html.Before proceeding with an installation from a source, ensure whether Oracle produced a precompiled binary distribution for the respective platform and if it works for the user or not.Building MySQL with nonstandard options might lead to a reduction in the functionality, performance, or security of the application.The ... Read More
MySQL can be installed on FreeBSD using the binary distribution which is provided by Oracle. The preferred and easiest way to install MySQL is to use the ‘mysql-server’ and ‘mysql-client’ ports which are available on http://www.freebsd.org/ website.The advantage of using these ports are −It comes with a working MySQL server and it contains all optimizations that are enabled, and help work on the user’s version of FreeBSD.It is automatically configured and built.The start up scripts are installed in /usr/local/etc/rc.d.It gives the ability to the user to use pkg_info –L to see which of the files were installed.It also gives the ... Read More
MySQL can be installed on Solaris using a binary package which is the native Solaris PKG format, instead of using the binary tarball distribution. The installation package has a dependency on the Oracle Developer Studio 12.6 Runtime Libraries. This needs to be installed before running the MySQL installation package.The installation package ensures that the runtime libraries only are installed, instead of having to install the full Oracle Developer Studio. This package can be used by downloading the corresponding mysql-VERSION-solaris11-PLATFORM.pkg.gz file.Uncompress Solaris PackageThis needs to be uncompressed after being downloaded. Below is a sample code to do the same −shell> gunzip ... Read More
Let us understand how to install MySQL with the help of ULN −Linux support many different ways of installing MySQL. One of the methods is installing it from Oracle’s Unbreakable Linux Network, which is also known as ULN.More information about Oracle Linux and ULN can be found here-http://linux.oracle.com/.Install Unbreakable Linux NetworkLet us understand how MySQL can be installed using ULN, i.e Unbreakable Linux Network. To use ULN, a ULN login needs to be obtained.Once this is done, the machine which is used for installation with ULN has to be registered. It supports both community and commercial packages.Community VersionThe community versions ... Read More
Let us understand how to install MySQL on Linux −Linux supports many different solutions to install MySQL. We will see how to install MySQL on Ubuntu 20.02. Following are the steps −Step1 − Open Terminal and enter the following command −Press Enter above and wait for download to complete.Step 2 − Set PasswordUse the mysql_secure_installation command and press enter to set password.Step 3 − Now, enter the MySQL Console using the below commandStep 4 − Display all the databases using the “SHOW DATABASES’ command −Now, start creating a new database and tables in it.
Let us understand how MySQL can be installed on macOS.There is a package that is located inside a disk image (a .dmg) file which needs to be mounted on by double clicking on the icon in the Finder. The next step is to mount the image and display the contents of it.Before installation of MySQL, the user has to ensure that all MySQL server instances have stopped running. This can be done by using the MySQL manager application, which is present on macOS server or the preference pane or by using the mysqladmin shutdown on the command line.MySQL can be ... Read More