Installation of MySQL in Windows

[bod-jack]

> Temporary directory named mysqltem
> Unzip file to mysqltem
> Search for a file named setup.exe
> Open Start>Run>Setup file>OK
> Installation process to be followed
> The standard installation will be located in c:\mysql
> Reboot the machine
> Open MS-DOS and then go to c:\mysql\bin
> Enter the following -

mysqld-shareware --standalone / mysqld
> MySQL Server is Started
> Type mysql in prompt
> Now inorder to test MySQL server, type show databases.
> Type quit at mysql prompt
> In order to shut MySQL Server, type the following -

mysqladmin -u root shutdown

[marcus_green]

First extract the package ( mysql-4.0.18-win.zip ) to a temporary directory, then run setup.exe. Keep clicking the next button to complete the installation. By default MySQL will be installed in C:\mysql.

Open a DOS window and go to C:\mysql\bin and then run mysqld-nt --console , you should see some messages like these :
C:\mysql\bin>mysqld-nt --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
040807 10:54:09 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040807 10:54:11 InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040807 10:54:12 InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040807 10:54:31 InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.18-nt' socket: '' port: 3306

[linux tech]

* If in case RPM is not supported by RPM. MySQL can be installed by a binary tarball from the website. However, manual installation is most important in this situation. Following are the steps -

* You must be root in case of login (su -root)

* Extract content to a specific directory such as follows for e.g. -

cd /usr/local
tar -xzvf
mysql-standard-4.0.9-gamma-pc-linux-i686.tar.gz

Most importantly, it should be extracted in mysql-version-os-architecture

* You can also create soft link to the directory named Mysql. For e.g. -

ln -s mysql-standard-4.0.9-gamma-pc-linux-i686 mysql

* Check the files in the directory and their respective arrangement.

* You can also user groupadd and useradd -

groupadd mysql
useradd –g mysql mysql

* Run the installation scripts, such as follows -

/usr/local/mysql/scripts/mysql_install_db

This basically installs various tables and access permissions

* You can make the changes to the MySQL binaries as follows -

chown -R root /usr/local/mysql

* You must also provide them read / write permissions to access MySQL datas -

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

* Start MySQL -

/usr/local/mysql/bin/mysqld_safe
–user=mysql &

* It should start reading the tables that were created earlier.