- MySQL Home
- MySQL tutorial
- MySQL Installation
- MySQL Statements
- MySQL Data Types
- Mysq CreateDatabase
- MySQL Create Table
- MySQL Constraints
- MySQL Primary key
- MySQL Foreign key
- Auto Increment Field
- MySQL Default Cons
- MySQL Insert Into
- MySQL Update
- MySQL Drop
- MySQL Delete
- MySQL Select
- MySQL Where
- MySQL Group By
- MySQL Having clause
- MySQL Order By
- MySQL Alter table
- MySQL Alias
- MySQL Create Index
- MySQL Subqueries
- MySQL Operators
- Mysql IsNull IsNotNull
- MySQL And or
- MySQL Between
- MySQL In Operator
- MySql Like Operator
- Mysql Union Operator
- Mysql Storage Engine
- Mysql Stored Procedure
- Mysql if Statement
- Mysql Case Statement
- MySQL Loops
- MySQL Cursor
Install MySQL database server on linux - window
how to get mysql.
simply you can download mysql from 'http://dev.mysql.com/downloads/'
mysql ab makes both source and binary distributions of the mysql database server available for download on its web site.precompiled binary distributions are also easier to install than source distributions.
binary distributions are available for linux, solaris, mac os x, windows xp/7/8 .
source distributions are available for both windows and unix platforms.
installing mysql database server on linux/unix
the recommended way to install mysql on a linux system is via rpm.mysql ab makes the following rpms available for download on its web site :-
- mysql database server, which manages databases and tables, controls user access, and processes sql queries.
- mysql-client programs, which makes it possible to connect to, and interact with the server.
- mysql-devel libraries and header files that come in handy when compiling other programs that use mysql.
- mysql-shared shared libraries for the mysql client.
- mysql-bench benchmark and performance testing tools for the mysql database server
now follow the following steps to proceed for installation:
- login to the system using root user
[user@host]# su - root
- switch to the directory containing the rpms
[root@host]# cd /tmp
- install the mysql database server by executing the following command.
(remember to replace the filename in italics with the file name of your rpm):
[root@host]# rpm -i mysql-4.0.9-0.i386.rpm
above command takes care of installing mysql server creating a user of mysql, creating necessary configuration and starting mysql server automatically.
you can find all mysql related binaries in /user/bin and /user/sbin.all the databases and tables will be created in /var/lib/mysql directory.
- this is optional but recommended step to install the remaining rpms in the same manner.
[root@host]# rpm -i mysql-client-4.0.9-0.i386.rpm [root@host]# rpm -i mysql-devel-4.0.9-0.i386.rpm [root@host]# rpm -i mysql-shared-4.0.9-0.i386.rpm [root@host]# rpm -i mysql-bench-4.0.9-0.i386.rpm
installing mysql database server on windows
installing mysql from a binary distribution follows these steps :-
- log in as an administrator and unzip the distribution archive to a temporary directory on your system. extract it.
- double-click the setup.exe file to begin the installation process.you should see a welcome screen.click next.
- click browse and select the directory in which mysql is to be installed in this example, select c:\program files\mysql.click next.
- select the type of installation required.click next
- click next, and mysql should now begin installing to your system.
- after installation is complete, you should see a screen and click finish.