Did You Know?

How Can We Help?

Special Offer

Deploy your Cloud Server now and get $100 in Free Credits!

Get Started

How to install MySQL Relational Databases on Fedora 12

Table of Content

Many web and server programmes rely on MySQL as their database management system. Following this tutorial will make working with MySQL on Fedora 12 Linode much easier for newcomers. It is assumed that you have updated your system, followed the instructions in our Setting Up and Securing a Compute Instance guide, and logged into your Linode as root via SSH before proceeding with this tutorial.

System Configuration

please ensure that your /etc/hosts file has complete entries, similar to the given shown below

[console]File: /etc/hosts[/console]

[console] localhost.yourdoamin localhost servername.yourdomain.com servername[/console]

Installing MySQL

[console]#yum update[/console]

[console]#yum install mysql-server[/console]

[console]#service mysqld start[/console]

Configure mysql

Mysql secure installation is a software that may be executed after MySQL has been installed to assist strengthen security. In addition to changing the MySQL root password, removing anonymous users, disabling root logins from hosts other than localhost, and erasing test databases are also options provided while executing mysql secure installation. You should select "yes" for these questions. When asked, choose "yes" to reload the privilege tables. To begin using the application, use the following command:


[console]#service mysqld restart[/console]

Resetting the MySQL Root Password

If you have forgotten your MySQL root password, you can retrieve it using the following commands:

[console]#service mysqld stop[/console]

[console]#mysqld_safe --skip-grant-tables[/console]

[console]#mysql -u root[/console]

The MySQL client programme will now handle the next part of the password reset:

[console]#USE mysql;[/console]

[console]#UPDATE user SET PASSWORD=PASSWORD("CHANGEME") WHERE User='root';[/console]

[console]#FLUSH PRIVILEGES;[/console]


Final step, restart MySQL with this command:

[console]#service mysqld restart[/console]

Thank you

Special Offer

Deploy your Cloud Server now and get $100 in Free Credits!

Get Started
Table of Contents