MySQL Server

mysql1

MySQL is an Open Source Relational Database Management System (RDBMS) based on Structured Query Language (SQL).

MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. MySQL is most often associated with web-based applications and  open source enterprise stack called LAMP. LAMP is a Web development platform that uses Linux/Unix as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language. [Sometimes Perl or Python is used instead of PHP.]


 

Prerequisites :
CentOS 6: minimal installation(Only for testing).
mysql-server : The MySQL server and related files.
mysql : MySQL client programs and shared libraries.


# Install Mysql Server

-> yum install mysql-server


 

# Mysql Configuration file located in /etc.

-> vi /etc/my.cnf

# Its contain database directory,port,Sockets,User(default mysql).

mysql2


 

# Once all the parameters have been set, set application to start during system boot and start the service.

-> /etc/init.d/mysqld start

-> chkconfig mysql on


 

# Lets Start mysql initial installation step.Run below command in terminal.

-> mysql_secure_installation

# Its  gives you below output go with below step given in the image.

inuxsysad


 

# After done above step try to connect mysql with root user.

-> mysql -u root -p

# Give your mysql password, Its showing below output.

mysql3


 

 

 

Leave a comment

Design a site like this with WordPress.com
Get started