MySQL Database Server

MySQL Database Server

MySQL database server (http://www.mysql.com) is the world’s most popular open source database. With more than five million active installations, MySQL has quickly become the core of many high-volume, business-critical applications. MySQL has the capabilities to handle most corporate database application requirements with an architecture that is extremely fast and easy to use.

1. rpm -qa | grep -i mysql, shows all package with name ‘mysql’ installed. By default, mysql-server is not installed.

2. Download and install mysql-server, rpm –Uvh /usr/src/mysql-server-version.rpm

3. Start mysqld, /etc/rc.d/init.d/mysqld restart

4. By default, MySQL is not configured to start everytime the server reboot. To enable this, use chkconfig to configure the run level of this service.

   chkconfig –level 2 mysqld on
   chkconfig –level 3 mysqld on
   chkconfig –level 4 mysqld on
   chkconfig –level 5 mysqld on

5. Set the MySQL root user password
   

   shell> mysql –u root

   mysql> use mysql;

   mysql> update user set password=password(‘Your_password_here’) where user=‘root’;

   mysql> flush privileges;

   You can also change MySQL root password with,
   /usr/bin/mysqladmin -u root password ‘new-password’

6. Login as root (Noted, this root user is not Unix root user) with,
   /usr/local/mysql/bin/mysql –u root -p <enter>
   Password: <Your_password_here>

7. Open port 3306 if MySQl is blocked by the firewall.