Difference between revisions of "Tung mysql conf"
| Line 12: | Line 12: | ||
#Login as root user | #Login as root user | ||
| − | #Install the MySQL server: <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>< | + | #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>< | + | #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>< | + | #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>< | + | #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>< | + | #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
- 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
