Install MySQL in Linux

Tutorials

Mysql

Topic

How to install MySQL server in linux ?

Explanation

Install MySQL in LINUX :

     We can install MySQL server in Linux by follwing some simple steps.

    The recommended way to install MySQL on Linux is by using the RPM packages. To obtain RPM packages, visit http://dev.mysql.com/downloads/. You can choose the package based on your Linux(RedHat,SuSE,Ubuntu,..), under each catgory download the server and the client packages using the links given there.

    After downloading the necessary package ,you need to install only the MySQL-server and MySQL-client packages to get a functional MySQL installation. This is called as Standard Installation.

    To see all files in an RPM package (for example, a MySQL-server RPM), run a commnd like this:

shell> rpm -qpl MySQL-server-VERSION.i386.rpm

To perform a standard minimal installation, install the server and client RPMs:

shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm

To install only the client programs, install just the client RPM:

shell> rpm -i MySQL-client-VERSION.i386.rpm

The server RPM places data under the /var/lib/mysql directory. After installation, you should be able to start using MySQL by typing 'mysql' in the command window. If something goes wrong, you may have done some thing wrong during installation and can try to reinstall mysql in linux.

The accounts that are listed in the MySQL grant tables initially have no passwords. After starting the server, you should set up passwords for them.

In the next section we can see how to create a database and create tables for that databases.

Installation in Mac OS

Install MySQL In Linux