mobileNavlogo
headerlogo

Blog

MySQL Installation

27 October, 2018

Related Blogs

2.1. Installing MySQL from RPM Packages on Linux

For non-RPM Linux distributions, you can install MySQL using a .tar.gz package. MySQL-server-VERSION.glibc23.i386.rpm The MySQL server. You need this unless you only want to connect to a MySQL server running on another machine. MySQL-client-VERSION.glibc23.i386.rpm The standard MySQL client programs. You probably always want to install this package to connect to the servers. MySQL-devel-VERSION.glibc23.i386.rpm The libraries and include files that are needed if you want to compile other MySQL clients, such as the Perl modules. MySQL-shared-VERSION.glibc23.i386.rpm This package contains the shared libraries (libmysqlclient.so*) that certain languages and applications need to dynamically load and use MySQL. It contains single-threaded and thread-safe libraries. If you install this package, do not install the MySQL-shared-compat package. MySQL-shared-compat-VERSION.glibc23.i386.rpm This package includes the shared libraries for MySQL 3.23, 4.0, and so on, up to the current release. It contains single-threaded and thread-safe libraries. Install this package instead of MySQL-shared if you have applications installed that are dynamically linked against older versions of MySQL but you want to upgrade to the current version without breaking the library dependencies.

2.2.  Installing MySQL from a Standard Source Distribution

 
Directory Contents of Directory
bin Client programs and scripts
Var Log files, databases
docs Manual in Info format
man Unix manual pages
Include/mysql Include (header) files
Lib/mysql Libraries
Libexec The mysqld server
share/mysql Miscellaneous support files, including error messages, sample configuration files, SQL for database installation
sql-bench Benchmarks
    # Preconfiguration setup shell> groupadd mysql shell> useradd -g mysql mysql # Beginning of source-build specific instructions shell> tar zxvf mysql-VERSION.tar.gz shell> cd mysql-VERSION shell> ./configure --prefix=/usr/local/mysql shell> make shell> make install # End of source-build specific instructions # Postinstallation setup shell> cd /usr/local/mysql shell> chown -R mysql . shell> chgrp -R mysql . shell> bin/mysql_install_db --user=mysql shell> chown -R root . shell> chown -R mysql var # Next command is optional shell> cp support-files/my-medium.cnf /etc/my.cnf shell> bin/mysqld_safe --user=mysql & # Next command is optional shell> cp support-files/mysql.server /etc/init.d/mysql.server

2.3  Installing MySQL from Generic Binaries on Unix/Linux

 
Directory Contents of Directory
bin Client programs and scripts
Var Log files, databases
docs Manual in Info format
man Unix manual pages
Include/mysql Include (header) files
Lib/mysql Libraries
Libexec The mysqld server
share/mysql Miscellaneous support files, including error messages, sample configuration files, SQL for database installation
sql-bench Benchmarks
  shell> groupadd mysql shell> useradd -r -g mysql mysql shell> cd /usr/local shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql shell> chown -R mysql . shell> chgrp -R mysql . shell> scripts/mysql_install_db --user=mysql shell> chown -R root . shell> chown -R mysql data # Next command is optional shell> cp support-files/my-medium.cnf /etc/my.cnf shell> bin/mysqld_safe --user=mysql & # Next command is optional shell> cp support-files/mysql.server /etc/init.d/mysql.server 2.4  Setting  Environment  Variables   # vi .bash_profile export MySQL_HOME=/usr/local/mysql #PATH=$PATH:$HOME/bin PATH=$PATH:$HOME/bin:$MySQL_HOME export MYSQL_HOME='localhost' export USER='localhost'                         Only on Win and Netware export MYSQL_PWD='localhost' Check Out Our Related Courses Sql Tutorials Oracle Pl SQL Tutorials Top 50 Sql Server Interview Questions SQL Server DBA Training In Hyderabad   
About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .