Difference between revisions of "Tung mysql conf"

From CDOT Wiki
Jump to: navigation, search
Line 12: Line 12:
  
 
#Login as root user
 
#Login as root user
#Install the MySQL server: <b><code><font color=green >yum mysql-server</font></code></b>
+
#Install the MySQL server: <b><font face=Tahoma><font color=green >yum mysql-server</font></font></b>
#Configure the MySQL server to start when the Fedora is booted:  <b><code><font color=green >chkconfig mysqld on</font></code></b>
+
#Configure the MySQL server to start when the Fedora is booted:  <b><font face=Tahoma><font color=green >chkconfig mysqld on</font></font></b>
#Start the MySQL server: <b><code><font color=green >service mysqld start</font></code></b>
+
#Start the MySQL server: <b><font face=Tahoma><font color=green >service mysqld start</font></font></b>
#Set a password to MySQL server's root user:  <b><code><font color=green >/usr/bin/mysqladmin -u root password 'yourpassword'</font></code></b>
+
#Set a password to MySQL server's root user:  <b><font face=Tahoma><font color=green >/usr/bin/mysqladmin -u root password 'yourpassword'</font></font></b>
#Test the root account: <b><code><font color=green > mysql -u root -p </font></code></b>. Enter your new password. You should enable to login as root.
+
#Test the root account: <b><font face=Tahoma><font color=green > mysql -u root -p </font></font></b>. Enter your new password. You should enable to login as root.
#Logout the session: <b><code><font color=green >quit</font></code></b>
+
#Logout the session: <b><font face=Tahoma><font color=green >quit</font></font></b>

Revision as of 23:04, 27 July 2011

Installing and Configuring MySQL


Introduction

In this page, you are going to install the MySQL server to your Fedora, and set a password to the root user. MySQL is free database management system that is used by large web sites, such as Wordpress, Wikipedia, Twitter and Facebook. Because it threatens Oracle's business, it has been acquired by Oracle. It will stop the future open source development.


Instruction

  1. Login as root user
  2. Install the MySQL server: yum mysql-server
  3. Configure the MySQL server to start when the Fedora is booted: chkconfig mysqld on
  4. Start the MySQL server: service mysqld start
  5. Set a password to MySQL server's root user: /usr/bin/mysqladmin -u root password 'yourpassword'
  6. Test the root account: mysql -u root -p . Enter your new password. You should enable to login as root.
  7. Logout the session: quit