MariaDB: Difference between revisions

Line 1:

MySQL is the default database used by ~~much of the~~ Linux ~~system~~. It is maintained by [http://www.oracle.com/index.html Oracle Corporation] (originally Sun Microsystems) and is licensed under the [http://www.gnu.org/licenses/gpl-2.0.html GNU GPL v2] license.

MySQL is the default database used by many Linux systems. It is maintained by [http://www.oracle.com/index.html Oracle Corporation] (originally Sun Microsystems) and is licensed under the [http://www.gnu.org/licenses/gpl-2.0.html GNU GPL v2] license.

'''As of [[openSUSE 12.3]], MySQL has been replaced by MariaDB. This is a drop-in replacement of MySQL and so all commands below will still work in exactly the same way. This article will change to MariaDB in the near future.'''

Examples of programs using this include:

Line 60:

Line 62:

<li>For the change to take effect, you will need to restart the MySQL server.</li>

<li><ul><li> Goto the Lanuch menu and open Konsole</li>

<li> At the prompt type <code>~~rcmysql~~ restart</code>. This can take a few seconds.</li>

<li> At the prompt type <code>service mysql restart</code>. This can take a few seconds.</li>

<li> Now type <code>~~rcmysql~~ 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 typed the directive correctly and have placed it in the correct block.</li>

<li> 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 typed the directive correctly and have placed it in the correct block.</li>

</ul></ol>

Line 91:

Line 93:

<li>For the change to take effect, you will need to restart the MySQL server.</li>

<li><ul><li> Goto the Lanuch menu and open Konsole</li>

<li> At the prompt type <code>~~rcmysql~~ restart</code>. This can take a few seconds.</li>

<li> At the prompt type <code>service mysql restart</code>. This can take a few seconds.</li>

<li> Now type <code>~~rcmysql~~ 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.</li>

<li> 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.</li>

</ul></ol>

@@ Line 1: / Line 1: @@
-MySQL is the default database used by much of the Linux system. It is maintained by [http://www.oracle.com/index.html Oracle Corporation] (originally Sun Microsystems) and is licensed under the [http://www.gnu.org/licenses/gpl-2.0.html GNU GPL v2] license.
+MySQL is the default database used by many Linux systems. It is maintained by [http://www.oracle.com/index.html Oracle Corporation] (originally Sun Microsystems) and is licensed under the [http://www.gnu.org/licenses/gpl-2.0.html GNU GPL v2] license.
+'''As of [[openSUSE 12.3]], MySQL has been replaced by MariaDB. This is a drop-in replacement of MySQL and so all commands below will still work in exactly the same way. This article will change to MariaDB in the near future.'''
 Examples of programs using this include:
@@ Line 60: / Line 62: @@
 <li>For the change to take effect, you will need to restart the MySQL server.</li>
 <li><ul><li> Goto the Lanuch menu and open Konsole</li>
-<li> At the prompt type <code>rcmysql restart</code>. This can take a few seconds.</li>
+<li> At the prompt type <code>service mysql restart</code>. This can take a few seconds.</li>
-<li> Now type <code>rcmysql 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 typed the directive correctly and have placed it in the correct block.</li>
+<li> 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 typed the directive correctly and have placed it in the correct block.</li>
 </ul></ol>
@@ Line 91: / Line 93: @@
 <li>For the change to take effect, you will need to restart the MySQL server.</li>
 <li><ul><li> Goto the Lanuch menu and open Konsole</li>
-<li> At the prompt type <code>rcmysql restart</code>. This can take a few seconds.</li>
+<li> At the prompt type <code>service mysql restart</code>. This can take a few seconds.</li>
-<li> Now type <code>rcmysql 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.</li>
+<li> 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.</li>
 </ul></ol>