Install MySQL In Linux
How to install MySQL server in linux ?
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
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.