MariaDB: Difference between revisions
m →Binary logging: Grammatical changes |
m Grammatical changes |
||
| Line 89: | Line 89: | ||
If you are not using a MySQL duplication server, the logging is of no use. It can be turned off by the following: | If you are not using a MySQL duplication server, the logging is of no use. It can be turned off by the following: | ||
* | * Go to the Launch Menu and launch Kwrite. | ||
* You then need to | * You then need to go to 'File' on the menu bar and click 'Open'. | ||
* You now need to open the MariaDB configuration file. This is located at <code>/etc/my.cnf</code>. | * You now need to open the MariaDB configuration file. This is located at <code>/etc/my.cnf</code>. | ||
* Scroll down and find the block: | * Scroll down and find the block: | ||
| Line 109: | Line 109: | ||
* Now save this change and close the file. | * Now save this change and close the file. | ||
* For the change to take effect, you will need to restart the MariaDB server. | * For the change to take effect, you will need to restart the MariaDB server. | ||
* | * Go to the Lanuch menu and open Konsole | ||
* At the prompt type <code>service mysql restart</code>. This can take a few seconds. | * At the prompt type <code>service mysql restart</code>. This can take a few seconds. | ||
* Now type <code>service mysql status</code>. You should see that the sever is now running. If it isn't and it says 'failed', there is a problem with what you have typed. You will need to go back through from the beginning, ensuring you have put the <code>#</code> in front of the lines of code shown. | * Now type <code>service mysql status</code>. You should see that the sever is now running. If it isn't and it says 'failed', there is a problem with what you have typed. You will need to go back through from the beginning, ensuring you have put the <code>#</code> in front of the lines of code shown. | ||