Difference between revisions of "Tung mysql conf"

From CDOT Wiki
Jump to: navigation, search
Line 18: Line 18:
 
#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.
 
#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><font face=Tahoma><font color=green >quit</font></font></b>
 
#Logout the session: <b><font face=Tahoma><font color=green >quit</font></font></b>
 +
 +
 +
 +
[[File:Mysql logo xyz.jpg | border ]]

Revision as of 23:30, 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


Mysql logo xyz.jpg