Difference between revisions of "Tung mysql conf"
(→Instruction) |
|||
| Line 8: | Line 8: | ||
#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><code><font color=green >yum mysql-server</font></code></b> | ||
| − | #Configure the MySQL server to start when the Fedora is booted: chkconfig mysqld on | + | #Configure the MySQL server to start when the Fedora is booted: <b><code><font color=green >chkconfig mysqld on</font></code></b> |
| − | #Start the MySQL server: service mysqld start | + | #Start the MySQL server: <b><code><font color=green >service mysqld start</font></code></b> |
| − | #Set a password to MySQL server's root user: /usr/bin/mysqladmin -u root password 'yourpassword' | + | #Set a password to MySQL server's root user: <b><code><font color=green >/usr/bin/mysqladmin -u root password 'yourpassword'</font></code></b> |
| − | #Test the root account: mysql -u root -p . Enter your new password. You should enable to login as root. | + | #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. |
#Logout the session: quit | #Logout the session: quit | ||
Revision as of 17:46, 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 future open source development.
Instruction
- Login as root user
- Install the MySQL server:
yum mysql-server - Configure the MySQL server to start when the Fedora is booted:
chkconfig mysqld on - Start the MySQL server:
service mysqld start - Set a password to MySQL server's root user:
/usr/bin/mysqladmin -u root password 'yourpassword' - Test the root account:
mysql -u root -p. Enter your new password. You should enable to login as root. - Logout the session: quit
