Installing MySQL for Windows NT Mac OS X Linux

Home
- About US
- Our Photos
- Post
Links
Contact
Review
Gallery

mysql Installation Upgrading running Stopping MySQLAdmin Users and Privileges Create Tables Alter Tables String or Text Numeric Function Date & Time Date & Time Format Grouping Join Statement Grant & Revoke Stored Procedure OLTP & CS Structure Select Statement

Installing MySQL

MS Windows or NT

Download the Zip file from the MySQL web site

unzip the download file to the default folder

run the Setup.exe application

open the newly created c:\mysql\bin

run the WinMySQLAdmin

enter your unique User Name and Password

for NT, MySQL will run as a Service

Installing MySQL on Macintosh

Max OS X uses a FreeBSD foundation with a Macintosh graphical user interface, meaning that it has the usability and stability of any Unix operating system but the appearance and interface of a Mac. The implication of this is that, now more than ever, there is an Apple operating system that programmers and developers are actively using, Furthermore, most software that installs and runs on a Unix system, such as MySQL, will also work with a Max OS X.

download the current package from the web site
get the version 3.23.49 (Marc) and the name of the file is mysql-3.23.49.pkg.tar.gz.
unpack the file
use a utility such as StuffIt Expander
install MySQL
open the Users Control panel through the System Preferences
create a specific user for running the MySQL software
add a new user named mysql
open up the Terminal Application and log on as the root user

ex.:

lullman% su root

root#

move to the /usr/local/mysql folder

ex.:

cd /usr/local/mysql

install the initial databases

ex.:

./scripts/mysql_install_db

change the permissions on the directory

ex.:

chown -R mysql /usr/local/mysql/*

If you decide to establish a specific user for running MySQL, change the permissions of the MySQL files to this User's account. After this final step you will be ready to start and use MySQL

Linux

MySQL AB advises that the best way to install MySQL on Linux is to use an RPM (Red Hot Package Manager) and the MySQL web site provides a number of RPMs in case.

The RPMs, by default, will install the applications within the /var/lib/mysql directory. Further, the RPM will add the requisite data to the /etc/rc.d/ directory so that the MySQL server daemon will be automatically started when the computer is booted.

access the server via command-line interface (Terminal)
use the root access for this
go to the /usr/local directory

ex.:

cd /usr/local

download the MySQL binary or source distribution
move the downloaded files to /usr/local via browser
or use wget or curl to immediately download the file to the current directory
unpack the files

ex.:

gunzip mysql-3.23.49.tar.gz

tar xvf mysql-3.23.49.tar

create a link referring to this directory

ex.:

ln -s /usr/local/mysql-3.23.49mysql

create a new MySQL user and group

ex.:

groupadd mysql

useradd -g mysql mysql

move into the new mysql directory

ex.:

cd mysql

configure the MySQL directory

ex.:

./configure --prefix=/usr/local/mysql

If you are using the MySQL source, as opposed to the binary, you will ned to configure it yourself, then make the install the files(see next two(2) steps). If you are using a precompiled binary, you can skip this and the next two(2) steps.

after configuration has run
make and install the files

ex.:

make

make install

install the default databases

ex.:

scripts/mysql_install_db

change the permission on the new files

ex.:

chown -R root /usr/local/mysql/.

chown -R mysql /usr/local/mysql/data

chown -R mysql /usr/local/mysql/.

This final step allows the MySQL server to run under the guise of the newly created mysql user