Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Database Articles
Page 200 of 547
Installing MySQL on FreeBSD
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 MoreInstalling MySQL on Solaris
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 MoreInstalling MySQL Using Unbreakable Linux Network (ULN)
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 MoreInstalling MySQL on macOS
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 MoreInstalling MySQL on Unix/Linux Using Generic Binaries
Oracle comes with a set of binary distributions of MySQL. This includes generic binary distributions in the form of compressed tar files (files that have a .tar.xz extension) for many platforms, and binaries in platform-specific package formats for specific platforms.MySQL compressed tar file binary distributions have names in the format ‘mysql−VERSION−OS.tar.xz’, where VERSION refers to a number and OS indicates the type of operating system on which the distribution is required to be used.To install a compressed tar file binary distribution, the installation needs to be unpacked into a location that is chosen by user. Debug versions of the mysqld ...
Read MoreInstalling a MySQL Source Distribution
Let us understand how to install MySQL from a source distribution −Building MySQL from sourceYou need the following tools to build and install MySQL from source −GNU needs to be installed so as to uncompress the distribution. Another ‘tar’ should be installed to unpack the distribution.ANSI C++ compiler.A good ‘make’ program. GNU make is recommendedThe below commands need to be executed to install a MySQL source distribution from an unpacked ‘tar’ file −shell> configure shell> make shell> make install shell> scripts/mysql_install_db shell> /usr/local/mysql/bin/safe_mysqld &If you start from a source RPM, then do the following.shell> rpm −−rebuild MySQL−VERSION.src.rpmThis will ‘make’ a ...
Read MoreVerifying MySQL Package Integrity
Let us understand how to verify the package integrity of MySQL −Once the MySQl package that suits the user’s requirements has been downloaded, it has to be installed. Before installation, it is to be ensured that the package is intact and hasn’t been tampered with.Check Integrity of packageThere are three ways in which the integrity of the package can be checked. They have been listed below.MD5 checksumsCryptographic signatures with the help of GnuPG, which is the GNU Privacy GuardFor RPM packages, the built-in PRM integrity verification mechanismLet us understand the MD5 checksum method of checking the integrity of the package.MD5 ...
Read MoreTools that were used to create MySQL
The article lists some of the tools that have been used to create MySQL. This is an important list which has helped mould what MySQl is today.Free Software FoundationThey helped provide an excellent compiler (gcc), an excellent debugger (gdb) and the libc library (from which strto.c has been borrowed to get some code working in Linux).Free Software Foundation & The XEmacs development teamThey have helped provide a really great editor/environment.Julian SewardThey are the author of valgrind, an excellent memory checker tool that helps find a lot of otherwise hard to find bugs in MySQL.Dorothea Lütkehaus and Andreas ZellerThey have helped ...
Read MoreWhat are the MySQL Supported Platforms?
Let us see the different platforms that MySQL supports. MySQL can be deployed in virtual environments.It supports the below mentioned operating systems −Oracle Linux/ Red Hat/ CentOSOracle Linux 8 / Red Hat Enterprise Linux 8 / CentOS 8 whose architecture can be x86_64, ARM 64Oracle Linux 7 / Red Hat Enterprise Linux 7 / CentOS 7 whose architecture can be ARM 64Oracle Linux 7 / Red Hat Enterprise Linux 7 / CentOS 7 whose architecture can be x86_64Oracle Linux 6 / Red Hat Enterprise Linux 6 / CentOS 6 whose architecture can be x86_32, x86_64Oracle SolarisSolaris 11 (Update 4+) whose ...
Read MoreMajor Packages that support MySQL
Let us see the major packages that support MySQL −This article lists the creators and maintainers of some of the most important API/packages/applications that is used by a lot of people along with the usage of MySQL. The major packages that support MySQL by lending their support, along with their contributions have been listed below −Tim Bunce, Alligator Descartes: They helped with the DBD (Perl) interface.Andreas Koenig: They helped with the Perl interface for MySQL Server.Jochen Wiedmann: They helped in maintaining the Perl DBD::mysql module.Eugene Chan: They helped in porting PHP for MySQL Server.Georg Richter: They helped in the testing ...
Read More