The most important task is to configure the MySQL into a usable basic status. Because the Fedora 16/17 introduced another system service manipulating program, "systemctl", which is recommended by Fedora 16/17 in their deployment documentations, the configuration procedure is a little different from the previous Fedora systems that use "service" and "chkconfig" commands. These old programs, however, are still accessible in Fedora 16/17. Here is an example of "systemctl" usage:
systemctl status mysqld.service
Notice that the service name is followed by a word "service".
Enabling a service to start automatically at boot time:
systemctl enable mysqld.service
Disabling a service to start at boot time:
systemctl disable mysqld.service
Checking the service status:
systemctl status mysqld.service
Running, Stoping and Restarting a service:
systemctl [start | stop | restart] mysqld.service
After the MySQL service is started and is added to the start queue at boot time, several privilege settings should be done. There are many methods to accomplish this task. I'd like to use the provided program: "mysql_secure_installation". When this step is completed, the password for root is changed, and the anonymous account and test database should be properly set as desired.
In order to access the MySQL from remote machines, do not forget to open the port 3306 for the MySQL server.
More configurations and database set up can be done by using the GUI workbench of MySQL.
No comments:
Post a Comment