Wednesday, December 5, 2012

mysql installation


MySQL community server database,  mysql connector, mysql workbench download

MySQL Community Server: http://dev.mysql.com/downloads/mysql/


MySQL Connector/J : http://dev.mysql.com/downloads/connector/j/


MySQL Workbench : http://dev.mysql.com/downloads/workbench/


mysql connection glass fish server config

Copy the MySQL Connector/j jar file into your glassfish lib folder.
On windows, this folder is located at ‘glassfish installation location’\glassfish\modules.

http://www.greenkode.com/2011/08/install-and-configure-mysql-for-eclipse-and-oracle-glassfish-3-1/



mysql connection pool-glassfish-eclipse config

https://blogs.oracle.com/davisn/entry/create_mysql_jdbc_connection_pool





  • Download and Install MySQL




For Windows

    Download MySQL from www.mysql.com ? Select top-level tab "Downloads (GA)" ? MySQL Community Edition (GPL):
        Under "MySQL Community Server (GPL)" ? Select DOWNLOAD.
        Under "General Available (GA) Release", "MySQL Community Server 5.6.{xx}" (where {xx} is the latest upgrade number) ? In "Select Platform", Select "Microsoft Windows".
        Download the 32-bit or 64-bit ZIP Archive (mysql-5.6.{xx}-win32.zip or mysql-5.6.{xx}-winx64.zip, about 210 MB).
        You can check whether your Windows is 32-bit or 64-bit from "Control Panel" ? System ? System Type.
        There is NO need to "Sign-up" - Just click "No thanks, just start my downloads!".
    UNZIP into a directory of your choice. DO NOT unzip into your desktop (because it is hard to locate the path). I suggest that you unzip into "d:\myProject" (or "c:\myproject" if you do not have a D drive). MySQL will be unzipped as "d:\myProject\mysql-5.5.{xx}-win32". For ease of use, we shall shorten and rename the directory to "d:\myProject\mysql".


I recommend using the "ZIP" version, instead of the "Windows Installer" version for academic learning. You can simply delete the entire MySQL directory when it is no longer needed (without running the un-installer). You are free to move or rename the directory. You can also install (unzip) multiple copies of MySQL in the same machine on different directories.

(For Advanced Users Only) A better approach is to keep the original folder name, such as mysql-5.6.{xx}-win32, but create a symlink called mysql via command "mklink /D mysql mysql-5.6.{xx}-win32". Symlink is available in Windows Vista/7/8.


MySQL Distribution

The MySQL distribution includes:

    A SQL server (mysqld);
    A command-line client (mysql);
    Utilities: Database administration (mysqladmin), backup/restore (mysqldump), and others;
    Client libraries for you to write your own client.


Explanation

    [mysqld]
    [client]
    The MySQL operates as a client-server system, and consists of a server program and a client program. There are two sections in the configuration: [mysqld] for the server program, and [client] for the client program.
    basedir=<MYSQL_HOME>
    datadir=<MYSQL_HOME>/data
    "basedir" and "datadir" specify the MySQL installed directory and data directory for storing the databases, respectively. Make sure that you set their values according to your own installation. You need to use Unix-style forward-slash (/) as the directory separator, instead of Windows-style backward-slash (\).
    port=8888
    MySQL is a TCP/IP application. The default TCP port number for MySQL is 3306. However, it may crash with a MySQL server already running in some lab machines. You may choose any port number between 1024 to 65535, which is not used by an existing application. I choose 8888 for our server.
    This configuration file specifies the bare minimum. There are many more configuration options. Sample configuration files (*.ini, *.cnf) are provided under <MYSQL_HOME>.

The server program is called "mysqld" (with a suffix 'd', which stands for daemon - a daemon is a non-interactive process running in the background).
The client program is called "mysql" (without the 'd')


http://www.ntu.edu.sg/home/ehchua/programming/sql/MySQL_HowTo.html