MySQL Server : Open Source Database : MySQL Setup

• MySQL Setup for Windows
• MySQL Setup for Linux
• Check MySQL Version

Install MySQL Server 5 or above on windows

Click here to Download MySQL Community Server

Click double on below file as per your windows os , 32 bit or 64 bit

Proceed with clicking Next button

Click Install to proceed with Installation

After completing Installation, Try Login by selecting “MySQL 5.5 Command Line Client” option as below

Login with MySQL Server

Enter password: *****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Install MySQL Server 5 on Ubuntu / linux

Installing MySQL 5 Server on Ubuntu is a quick and easy process. It almost feels like it should be more difficult.

Open a terminal window, and use the following command:

administrator@ubuntu:~$ sudo apt-get install mysql-server

If you are running PHP you will also need to install the php module for mysql 5:

administrator@ubuntu:~$ sudo apt-get install php5-mysql

To create a new database, use the mysqladmin command:

administrator@ubuntu:~$ mysqladmin -u root -p create javaskool_inventory
Enter password: *****

administrator@ubuntu:~$

Start MySQL Server

administrator@ubuntu:~$ sudo /etc/init.d/mysql start

OR for LAMP(Linux,Apache,MySQL,PHP) suite

administrator@ubuntu:~$ sudo /opt/lampp/lampp start

Starting MySQL database server: mysqld already running.

Setting MYSQL password for user root. here root password will be admin

administrator@ubuntu:~$ mysqladmin  -u  root   password   admin

OR for LAMP(Linux,Apache,MySQL,PHP) suite

administrator@ubuntu:~$ sudo  /opt/lampp/bin/mysql   -u   root   -p'admin'

Login with MySQL

administrator@ubuntu:~$ mysql  -u  root    -p
Enter password:****** 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 4.1.15-Debian_1ubuntu5

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

How to determine Your Current MySQL Version

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 1.1.8                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.25                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86                          |
| version_compile_os      | Win64                        |
+-------------------------+------------------------------+
7 rows in set (0.48 sec)

mysql>

The STATUS command displays the version as well as version comment information.

mysql> STATUS;

C:\Program Files (x86)\MySQL5.5\bin\mysql.exe  Ver 14.14 Distrib 5.5.25, for Win
64 (x86)

Connection id:          1
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.25 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 3 hours 3 min 42 sec

Threads: 1  Questions: 7  Slow queries: 0  Opens: 33  Flush tables: 1  Open tabl
es: 0  Queries per second avg: 0.000

mysql>