* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-24 11:51 Shyam Mani
0 siblings, 0 replies; 12+ messages in thread
From: Shyam Mani @ 2005-08-24 11:51 UTC (permalink / raw
To: gentoo-doc-cvs
fox2mike 05/08/24 11:51:02
Added: xml/htdocs/doc/en/draft mysql-howto.xml
Log:
Putting it here for a check-up + some URLification.
Revision Changes Path
1.1 xml/htdocs/doc/en/draft/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml?rev=1.1&content-type=text/plain&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "http://www.gentoo.org/dtd/guide.dtd">
<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v 1.1 2005/08/24 11:51:02 fox2mike Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
<author title="Author">
<mail link="chriswhite@gentoo.org">Chris White</mail>
</author>
<author title="Editor">
<mail link="fox2mike@gentoo.org">Shyam Mani</mail>
</author>
<abstract>
This document helps a user setup and use MySQL.
</abstract>
<!-- The content of this document is licensed under the CC-BY-SA license -->
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
<version>1.0</version>
<date>2005-08-24</date>
<chapter>
<title>Getting Started With MySQL</title>
<section>
<title>Background</title>
<body>
<p>
MySQL is a popular database server that is used in various applications. SQL
stands for (S)tandard (Q)uery (L)anguage, which is what MySQL uses to
communicate with other programs. On top of that, MySQL has its own expanded
SQL functions to provide additional functionality to users. In this document,
we'll look at how to do the initial MySQL installation, setup databases and
tables and create new users. Let's start out with the installation.
</p>
</body>
</section>
<section>
<title>MySQL Installation</title>
<body>
<p>
First make sure you have MySQL installed on your system. In case you need
specific functionality from MySQL, please make sure you have the required USE
flags enabled as they will help fine tune your installation.
</p>
<pre caption="Install MySQL">
<comment>(Viewing available USE flags)</comment>
# <i>emerge --pretend --verbose mysql</i>
<comment>(Install MySQL)</comment>
# <i>emerge mysql</i>
</pre>
<p>
Upon completion of the installation, you will see the following notice:
</p>
<pre caption="MySQL einfo message">
You might want to run:
"ebuild /var/db/pkg/dev-db/mysql-[version]/mysql-[version].ebuild config"
if this is a new install.
</pre>
<p>
Since this is a new installation, we run the command. You need to press
<c>ENTER</c> when prompted while configuring the MySQL database. The
configuration sets up the main MySQL database which contains administrative
information such as databases, tables, users, permissions and more. The
configuration recommends that you change your root password as soon as possible.
We will definitely do this, otherwise someone could come along by chance and
hack our default setup MySQL server.
</p>
<pre caption="MySQL configuration">
# <i>ebuild /var/db/pkg/dev-db/mysql-[version]/mysql-[version].ebuild config</i>
* MySQL DATADIR is /var/lib/mysql
* Press ENTER to create the mysql database and set proper
* permissions on it, or Control-C to abort now...
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, issue the following commands to start the server
and change the applicable passwords:
<comment>(Note the next 3 lines)</comment>
/etc/init.d/mysql start
/usr/bin/mysqladmin -u root -h pegasos password 'new-password'
/usr/bin/mysqladmin -u root password 'new-password'
Depending on your configuration, a -p option may be needed
in the last command. See the manual for more details.
<comment>(Some MySQL non-ebuild specific information has been removed from here
so as to keep this document as consistent as possible)</comment>
* For security reasons you should set your MySQL root
* password as soon as possible.
</pre>
<impo>
As of mysql-4.0.24-r2, passwords are entered during the config phase making
root password entry more secure.
</impo>
<p>
The config script has already printed out the commands we need to run to setup
our password, so we shall now run them.
</p>
<pre caption="Setting up your MySQL root password">
# <i>/etc/init.d/mysql start</i>
* Re-caching dependency info (mtimes differ)...
* Starting mysqld (/etc/mysql/my.cnf) ... [ ok ]
<comment>(Replace new-password with your desired password)</comment>
# <i>/usr/bin/mysqladmin -u root -h localhost password 'new-password'</i>
</pre>
<p>
You can now test that your root password was successfully configured by trying
to login to your MySQL server:
</p>
<pre caption="Logging into the MySQL server using mysql">
$ <i>mysql -u root -h localhost -p</i>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.24-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
</pre>
<p>
The <c>-u</c> switch sets the user that will be logging in. The <c>-h</c>
switch sets the host. This will usually be <c>localhost</c> unless you are
setting up a remote server. Finally, <c>-p</c> tells the mysql client that you
will be entering a password to access your database. Notice the
<c>mysql></c> prompt. This is where you type in all your commands. Now that
we're in the mysql prompt as the root user, we can begin to setup our database.
</p>
</body>
</section>
</chapter>
<chapter>
<title>Setting Up The Database</title>
<section>
<title>Creating A Database</title>
<body>
<p>
We have logged in and have a mysql prompt displayed. First let's take a look at
the databases we currently have. To do so, we use the <c>SHOW DATABASES</c>
command.
</p>
<pre caption="Displaying MySQL databases">
mysql> <i>SHOW DATABASES;</i>
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.09 sec)
</pre>
<impo>
Please remember that MySQL commands should end with a semicolon -- <c>;</c>
</impo>
<p>
Despite the fact that a test database is already created, we are going to create
our own. Databases are created using the <c>CREATE DATABASE</c> command. We'll
create one named "gentoo".
</p>
<pre caption="Creating the gentoo database">
mysql> <i>CREATE DATABASE gentoo;</i>
Query OK, 1 row affected (0.08 sec)
</pre>
<p>
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-24 14:47 Xavier Neys
0 siblings, 0 replies; 12+ messages in thread
From: Xavier Neys @ 2005-08-24 14:47 UTC (permalink / raw
To: gentoo-doc-cvs
neysx 05/08/24 14:47:01
Modified: xml/htdocs/doc/en/draft mysql-howto.xml
Log:
More info about insert into, typo fixes, coding style...
Revision Changes Path
1.2 +134 -141 xml/htdocs/doc/en/draft/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml?rev=1.2&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml?rev=1.2&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml.diff?r1=1.1&r2=1.2&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- mysql-howto.xml 24 Aug 2005 11:51:02 -0000 1.1
+++ mysql-howto.xml 24 Aug 2005 14:47:01 -0000 1.2
@@ -1,8 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE guide SYSTEM "http://www.gentoo.org/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v 1.1 2005/08/24 11:51:02 fox2mike Exp $ -->
+<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v 1.2 2005/08/24 14:47:01 neysx Exp $ -->
-<guide link="/doc/en/mysql-howto.xml">
+<guide link="/doc/en/draft/mysql-howto.xml"> <!--Remove draft/ when mv'ing up to /doc/en/ -->
<title>MySQL Startup Guide</title>
<author title="Author">
@@ -11,9 +11,12 @@
<author title="Editor">
<mail link="fox2mike@gentoo.org">Shyam Mani</mail>
</author>
+<author title="Editor">
+ <mail link="neysx@gentoo.org">Xavier Neys</mail>
+</author>
<abstract>
-This document helps a user setup and use MySQL.
+This document helps a user set up and use MySQL.
</abstract>
<!-- The content of this document is licensed under the CC-BY-SA license -->
@@ -32,10 +35,10 @@
<p>
MySQL is a popular database server that is used in various applications. SQL
stands for (S)tandard (Q)uery (L)anguage, which is what MySQL uses to
-communicate with other programs. On top of that, MySQL has its own expanded
-SQL functions to provide additional functionality to users. In this document,
-we'll look at how to do the initial MySQL installation, setup databases and
-tables and create new users. Let's start out with the installation.
+communicate with other programs. On top of that, MySQL has its own expanded SQL
+functions to provide additional functionality to users. In this document, we'll
+look at how to do the initial MySQL installation, set up databases and tables,
+and create new users. Let's start out with the installation.
</p>
</body>
@@ -72,9 +75,9 @@
<c>ENTER</c> when prompted while configuring the MySQL database. The
configuration sets up the main MySQL database which contains administrative
information such as databases, tables, users, permissions and more. The
-configuration recommends that you change your root password as soon as possible.
-We will definitely do this, otherwise someone could come along by chance and
-hack our default setup MySQL server.
+configuration recommends that you change your root password as soon as
+possible. We will definitely do this, otherwise someone could come along by
+chance and hack our default setup MySQL server.
</p>
<pre caption="MySQL configuration">
@@ -108,11 +111,11 @@
so as to keep this document as consistent as possible)</comment>
* For security reasons you should set your MySQL root
- * password as soon as possible.
+ * password as soon as possible.
</pre>
<impo>
-As of mysql-4.0.24-r2, passwords are entered during the config phase making
+As of mysql-4.0.24-r2, passwords are entered during the config phase making
root password entry more secure.
</impo>
@@ -124,7 +127,7 @@
<pre caption="Setting up your MySQL root password">
# <i>/etc/init.d/mysql start</i>
* Re-caching dependency info (mtimes differ)...
- * Starting mysqld (/etc/mysql/my.cnf) ... [ ok ]
+ * Starting mysqld (/etc/mysql/my.cnf) ... [ ok ]
<comment>(Replace new-password with your desired password)</comment>
# <i>/usr/bin/mysqladmin -u root -h localhost password 'new-password'</i>
</pre>
@@ -165,7 +168,7 @@
<body>
<p>
-We have logged in and have a mysql prompt displayed. First let's take a look at
+We have logged in and a mysql prompt is displayed. First let's take a look at
the databases we currently have. To do so, we use the <c>SHOW DATABASES</c>
command.
</p>
@@ -186,9 +189,9 @@
</impo>
<p>
-Despite the fact that a test database is already created, we are going to create
-our own. Databases are created using the <c>CREATE DATABASE</c> command. We'll
-create one named "gentoo".
+Despite the fact that a test database is already created, we are going to
+create our own. Databases are created using the <c>CREATE DATABASE</c> command.
+We'll create one named "gentoo".
</p>
<pre caption="Creating the gentoo database">
@@ -218,12 +221,12 @@
</pre>
<p>
-Indeed our database has been created. In order to work with creating tables
-for our new gentoo database, we need to select it as our current database.
-To do so, we use the<c>USE</c> command. The <c>USE</c> command takes the
-name of the database you wish to use as your current database. Another
-option is to set it on the command line after the <c>-p</c> switch. Let's go
-ahead and switch to the gentoo database.
+Indeed our database has been created. In order to work with creating tables for
+our new gentoo database, we need to select it as our current database. To do
+so, we use the <c>USE</c> command. The <c>USE</c> command takes the name of the
+database you wish to use as your current database. Another option is to set it
+on the command line after the <c>-p</c> switch. Let's go ahead and switch to
+the gentoo database.
</p>
<pre caption="Switching our database">
@@ -244,15 +247,15 @@
<chapter>
<title>Working With Tables In MySQL</title>
<section>
-<title>Creating A Table</title>
+<title>Creating a Table</title>
<body>
<p>
In the structure of MySQL, there are databases, tables, records, and fields.
Databases hold together tables, tables hold together records, records hold
together fields, which contain the actual information. This structure lets
-users select how they want to access their information. So far we've dealt
-with databases, now let's work with tables. First off, tables can be listed
+users select how they want to access their information. So far we've dealt with
+databases, now let's work with tables. First off, tables can be listed
similiarly to databases using the <c>SHOW TABLES</c> command. Right now there
are no tables in our gentoo database, as running the command will show us:
</p>
@@ -265,8 +268,8 @@
<p>
This means we need to create some tables. In order to do so, we use the
<c>CREATE TABLE</c> command. However, this command is quite different from
-simple <c>CREATE DATABASE</c> command. This command takes a list of arguments
-you must give it. The form is as follows:
+simple <c>CREATE DATABASE</c> command. This command takes a list of arguments.
+The form is as follows:
</p>
<pre caption="CREATE TABLE Syntax">
@@ -278,17 +281,17 @@
let's make a table named <c>developers</c>. This table will contain the
developer's name, email and job. <b>field_name</b> will contain the name of the
field. We have 3 required names in this case: name, email, and job. The
-<b>field_data_type</b> is what type of information will be stored. The different
-formats avaliable can be found at the <uri
+<b>field_data_type</b> is what type of information will be stored. The
+different formats available can be found at the <uri
link="http://dev.mysql.com/doc/mysql/en/column-types.html">MySQL Column Types
Page</uri>. For our purposes, we'll use the <c>VARCHAR</c> data type for all of
-our fields. <c>VARCHAR</c> is one of the simplest of data types when it comes to
-working with strings. <b>size</b> is how much of data a single field will store
-of type <b>field_data_type</b>. In this case, we'll use 128 for our size. This
-means that the field can have <c>VARCHAR</c> data that is 128 bits. You can
-safely think of this as 128 characters for the time being, though there is a
-somewhat more technical explanation that the above site will provide you with.
-Now that we know how we are going to create the table, let's do it.
+our fields. <c>VARCHAR</c> is one of the simplest of data types when it comes
+to working with strings. <b>size</b> is how much of data a single field will
+store. In this case, we'll use 128. This means that the field can have
+<c>VARCHAR</c> data that is 128 bytes. You can safely think of this as 128
+characters for the time being, though there is a somewhat more technical
+explanation that the above site will provide you with. Now that we know how we
+are going to create the table, let's do it.
</p>
<pre caption="Creating our table">
@@ -297,8 +300,8 @@
</pre>
<p>
-Looks like our table was created ok. Let's check it with the <c>SHOW
-TABLES</c> command:
+Looks like our table was created ok. Let's check it with the <c>SHOW TABLES</c>
+command:
</p>
<pre caption="Verifying our table">
@@ -312,10 +315,10 @@
</pre>
<p>
-Yes, there's our table. However, it doesn't seem to have any information on
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-24 17:07 Xavier Neys
0 siblings, 0 replies; 12+ messages in thread
From: Xavier Neys @ 2005-08-24 17:07 UTC (permalink / raw
To: gentoo-doc-cvs
neysx 05/08/24 17:07:01
Modified: xml/htdocs/doc/en/draft mysql-howto.xml
Log:
Make verb forms more coherent
Revision Changes Path
1.3 +6 -6 xml/htdocs/doc/en/draft/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml?rev=1.3&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml?rev=1.3&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/draft/mysql-howto.xml.diff?r1=1.2&r2=1.3&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- mysql-howto.xml 24 Aug 2005 14:47:01 -0000 1.2
+++ mysql-howto.xml 24 Aug 2005 17:07:01 -0000 1.3
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v 1.2 2005/08/24 14:47:01 neysx Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/draft/mysql-howto.xml,v 1.3 2005/08/24 17:07:01 neysx Exp $ -->
<guide link="/doc/en/draft/mysql-howto.xml"> <!--Remove draft/ when mv'ing up to /doc/en/ -->
<title>MySQL Startup Guide</title>
@@ -53,8 +53,8 @@
flags enabled as they will help fine tune your installation.
</p>
-<pre caption="Install MySQL">
-<comment>(Viewing available USE flags)</comment>
+<pre caption="Installing MySQL">
+<comment>(View available USE flags)</comment>
# <i>emerge --pretend --verbose mysql</i>
<comment>(Install MySQL)</comment>
# <i>emerge mysql</i>
@@ -465,11 +465,11 @@
</p>
<pre caption="SELECT forms">
-<comment>(Selects all entries in a table)</comment>
+<comment>(Select all entries in a table)</comment>
SELECT * FROM table;
-<comment>(Selects specific entries in a table)</comment>
+<comment>(Select specific entries in a table)</comment>
SELECT * FROM table WHERE field=value;
-<comment>(Selects specific fields)</comment>
+<comment>(Select specific fields)</comment>
SELECT field1,field2,field3 FROM table [WHERE field=value];
</pre>
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-25 5:19 Shyam Mani
0 siblings, 0 replies; 12+ messages in thread
From: Shyam Mani @ 2005-08-25 5:19 UTC (permalink / raw
To: gentoo-doc-cvs
fox2mike 05/08/25 05:19:14
Modified: xml/htdocs/doc/en metadoc.xml
Added: xml/htdocs/doc/en mysql-howto.xml
Log:
#98704 - New MySQL Guide by none other than our beloved PUNK, Chris White. Initial Version.
Revision Changes Path
1.102 +7 -2 xml/htdocs/doc/en/metadoc.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/metadoc.xml?rev=1.102&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/metadoc.xml?rev=1.102&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/metadoc.xml.diff?r1=1.101&r2=1.102&cvsroot=gentoo
Index: metadoc.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/metadoc.xml,v
retrieving revision 1.101
retrieving revision 1.102
diff -u -r1.101 -r1.102
--- metadoc.xml 21 Aug 2005 22:23:44 -0000 1.101
+++ metadoc.xml 25 Aug 2005 05:19:14 -0000 1.102
@@ -1,9 +1,9 @@
<?xml version='1.0' encoding="UTF-8"?>
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/metadoc.xml,v 1.101 2005/08/21 22:23:44 neysx Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/metadoc.xml,v 1.102 2005/08/25 05:19:14 fox2mike Exp $ -->
<!DOCTYPE metadoc SYSTEM "/dtd/metadoc.dtd">
<metadoc lang="en">
-<version>1.31</version>
+<version>1.32</version>
<members>
<lead>swift</lead>
<lead>neysx</lead>
@@ -82,6 +82,7 @@
<file id="partition-planning-tips">/doc/en/articles/partition-planning-tips.xml</file>
<file id="maximum-swappage">/doc/en/articles/maximum-swappage.xml</file>
<file id="bugzie-howto">/doc/en/bugzilla-howto.xml</file>
+ <file id="mysql-howto">/doc/en/mysql-howto.xml</file>
<file id="utf-8">/doc/en/utf-8.xml</file>
<file id="cron-guide">/doc/en/cron-guide.xml</file>
<file id="ldap-howto">/doc/en/ldap-howto.xml</file>
@@ -538,6 +539,10 @@
<memberof>other</memberof>
<fileid>bugzie-howto</fileid>
</doc>
+ <doc id="mysql-howto">
+ <memberof>sysadmin_specific</memberof>
+ <fileid>mysql-howto</fileid>
+ </doc>
<doc id="utf-8">
<memberof>sysadmin_general</memberof>
<memberof>desktop_config</memberof>
1.1 xml/htdocs/doc/en/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.1&content-type=text/plain&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.1 2005/08/25 05:19:14 fox2mike Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
<author title="Author">
<mail link="chriswhite@gentoo.org">Chris White</mail>
</author>
<author title="Editor">
<mail link="fox2mike@gentoo.org">Shyam Mani</mail>
</author>
<author title="Editor">
<mail link="neysx@gentoo.org">Xavier Neys</mail>
</author>
<abstract>
This document helps a user set up and use MySQL.
</abstract>
<!-- The content of this document is licensed under the CC-BY-SA license -->
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
<version>1.0</version>
<date>2005-08-25</date>
<chapter>
<title>Getting Started With MySQL</title>
<section>
<title>Background</title>
<body>
<p>
MySQL is a popular database server that is used in various applications. SQL
stands for (S)tandard (Q)uery (L)anguage, which is what MySQL uses to
communicate with other programs. On top of that, MySQL has its own expanded SQL
functions to provide additional functionality to users. In this document, we'll
look at how to do the initial MySQL installation, set up databases and tables,
and create new users. Let's start out with the installation.
</p>
</body>
</section>
<section>
<title>MySQL Installation</title>
<body>
<p>
First make sure you have MySQL installed on your system. In case you need
specific functionality from MySQL, please make sure you have the required USE
flags enabled as they will help fine tune your installation.
</p>
<pre caption="Installing MySQL">
<comment>(View available USE flags)</comment>
# <i>emerge --pretend --verbose mysql</i>
<comment>(Install MySQL)</comment>
# <i>emerge mysql</i>
</pre>
<p>
Upon completion of the installation, you will see the following notice:
</p>
<pre caption="MySQL einfo message">
You might want to run:
"ebuild /var/db/pkg/dev-db/mysql-[version]/mysql-[version].ebuild config"
if this is a new install.
</pre>
<p>
Since this is a new installation, we run the command. You need to press
<c>ENTER</c> when prompted while configuring the MySQL database. The
configuration sets up the main MySQL database which contains administrative
information such as databases, tables, users, permissions and more. The
configuration recommends that you change your root password as soon as
possible. We will definitely do this, otherwise someone could come along by
chance and hack our default setup MySQL server.
</p>
<pre caption="MySQL configuration">
# <i>ebuild /var/db/pkg/dev-db/mysql-[version]/mysql-[version].ebuild config</i>
* MySQL DATADIR is /var/lib/mysql
* Press ENTER to create the mysql database and set proper
* permissions on it, or Control-C to abort now...
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, issue the following commands to start the server
and change the applicable passwords:
<comment>(Note the next 3 lines)</comment>
/etc/init.d/mysql start
/usr/bin/mysqladmin -u root -h pegasos password 'new-password'
/usr/bin/mysqladmin -u root password 'new-password'
Depending on your configuration, a -p option may be needed
in the last command. See the manual for more details.
<comment>(Some MySQL non-ebuild specific information has been removed from here
so as to keep this document as consistent as possible)</comment>
* For security reasons you should set your MySQL root
* password as soon as possible.
</pre>
<impo>
As of mysql-4.0.24-r2, passwords are entered during the config phase making
root password entry more secure.
</impo>
<p>
The config script has already printed out the commands we need to run to setup
our password, so we shall now run them.
</p>
<pre caption="Setting up your MySQL root password">
# <i>/etc/init.d/mysql start</i>
* Re-caching dependency info (mtimes differ)...
* Starting mysqld (/etc/mysql/my.cnf) ... [ ok ]
<comment>(Replace new-password with your desired password)</comment>
# <i>/usr/bin/mysqladmin -u root -h localhost password 'new-password'</i>
</pre>
<p>
You can now test that your root password was successfully configured by trying
to login to your MySQL server:
</p>
<pre caption="Logging into the MySQL server using mysql">
$ <i>mysql -u root -h localhost -p</i>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.24-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
</pre>
<p>
The <c>-u</c> switch sets the user that will be logging in. The <c>-h</c>
switch sets the host. This will usually be <c>localhost</c> unless you are
setting up a remote server. Finally, <c>-p</c> tells the mysql client that you
will be entering a password to access your database. Notice the
<c>mysql></c> prompt. This is where you type in all your commands. Now that
we're in the mysql prompt as the root user, we can begin to setup our database.
</p>
</body>
</section>
</chapter>
<chapter>
<title>Setting Up The Database</title>
<section>
<title>Creating A Database</title>
<body>
<p>
We have logged in and a mysql prompt is displayed. First let's take a look at
the databases we currently have. To do so, we use the <c>SHOW DATABASES</c>
command.
</p>
<pre caption="Displaying MySQL databases">
mysql> <i>SHOW DATABASES;</i>
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.09 sec)
</pre>
<impo>
Please remember that MySQL commands should end with a semicolon -- <c>;</c>
</impo>
<p>
Despite the fact that a test database is already created, we are going to
create our own. Databases are created using the <c>CREATE DATABASE</c> command.
We'll create one named "gentoo".
</p>
<pre caption="Creating the gentoo database">
mysql> <i>CREATE DATABASE gentoo;</i>
Query OK, 1 row affected (0.08 sec)
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-25 5:21 Shyam Mani
0 siblings, 0 replies; 12+ messages in thread
From: Shyam Mani @ 2005-08-25 5:21 UTC (permalink / raw
To: gentoo-doc-cvs
fox2mike 05/08/25 05:21:50
Removed: xml/htdocs/doc/en/draft mysql-howto.xml
Log:
Doc went live, no need for draft anymore.
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-25 7:47 Shyam Mani
0 siblings, 0 replies; 12+ messages in thread
From: Shyam Mani @ 2005-08-25 7:47 UTC (permalink / raw
To: gentoo-doc-cvs
fox2mike 05/08/25 07:47:00
Modified: xml/htdocs/doc/en mysql-howto.xml
Log:
Coding style + Typos + Minor content changes.
Revision Changes Path
1.2 +41 -42 xml/htdocs/doc/en/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.2&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.2&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml.diff?r1=1.1&r2=1.2&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- mysql-howto.xml 25 Aug 2005 05:19:14 -0000 1.1
+++ mysql-howto.xml 25 Aug 2005 07:47:00 -0000 1.2
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.1 2005/08/25 05:19:14 fox2mike Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.2 2005/08/25 07:47:00 fox2mike Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
@@ -23,7 +23,7 @@
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
-<version>1.0</version>
+<version>1.1</version>
<date>2005-08-25</date>
<chapter>
@@ -359,7 +359,7 @@
<p>
This command is used to insert a record into table. table contains the MySQL
table we wish to enter the information into. The table name may be followed by
-the list of columns to insert data into and VALUE() contains the values you
+the list of columns to insert data into and <c>VALUE()</c> contains the values you
wish to insert into the table. You may omit the list of columns if you insert a
value into each one and if you write the values in the same order the columns
have been defined. In this case, we want to insert data into the developers
@@ -390,8 +390,8 @@
</pre>
<impo>
-Be sure you know what data you're dealing with. It's very unsafe to use LOAD
-DATA when you are uncertain of the file's contents!
+Be sure you know what data you're dealing with. It's very unsafe to use <c>LOAD
+DATA</c> when you are uncertain of the file's contents!
</impo>
<p>
@@ -435,7 +435,7 @@
<p>
Like <c>LOAD DATA</c>, be sure you can tell what <path>sqlfile</path> does.
-<e>Failure to do so may cause your database to be compromised</e>! Another way
+<e>Failure to do so may cause your database to be compromised!</e> Another way
you can accomplish this is to use the <c>source</c> command. This command will
run mysql commands from an sql file while in the mysql interactive mode. Here
is how to source an sql file:
@@ -447,7 +447,7 @@
<p>
If you see a web application wanting you to run an sql file, the two above
-commands can be used to accomplish that taks. We have our table setup, so how
+commands can be used to accomplish that task. We have our table setup, so how
do we check our fields? We do this by searching our table with queries.
</p>
@@ -562,7 +562,7 @@
<note>
<c>GRANT</c> is considered to be the way to create a user. Later versions of
-MySQL, however, do contain a <c>CREATE_USER</c> function, though GRANT is still
+MySQL, however, do contain a <c>CREATE_USER</c> function, though <c>GRANT</c> is still
preferred.
</note>
@@ -572,19 +572,20 @@
</p>
<ul>
- <li>ALL - Gives the all privlege control for the database</li>
- <li>CREATE - Allows users to create tables</li>
- <li>SELECT - Allows users to query tables</li>
- <li>INSERT - Allows users to insert data into a table</li>
- <li>SHOW DATABASES - Allows users to see a list of databases</li>
- <li>USAGE - User has no privleges</li>
- <li>GRANT OPTION - Allows users to grant privleges</li>
+ <li><c>ALL</c> - Gives the all privlege control for the database</li>
+ <li><c>CREATE</c> - Allows users to create tables</li>
+ <li><c>SELECT</c> - Allows users to query tables</li>
+ <li><c>INSERT</c> - Allows users to insert data into a table</li>
+ <li><c>SHOW DATABASES</c> - Allows users to see a list of databases</li>
+ <li><c>USAGE</c> - User has no privleges</li>
+ <li><c>GRANT OPTION</c> - Allows users to grant privleges</li>
</ul>
<note>
-If you're running MySQL to communicate data to a web application, CREATE,
-SELECT, INSERT (discussed here), DELETE and UPDATE (for further infomation look
-up the <uri link="http://dev.mysql.com/doc/mysql/en/grant.html"> MySQL
+If you're running MySQL to communicate data to a web application, <c>CREATE</c>,
+<c>SELECT</c>, <c>INSERT</c> (discussed here), <c>DELETE</c> and <c>UPDATE</c>
+(for further infomation look up the
+<uri link="http://dev.mysql.com/doc/mysql/en/grant.html"> MySQL
Reference Manual - GRANT and REVOKE Syntax</uri> section) are the only
permissions you will most likely need. A lot of people make the mistake of
granting all permissions when it's not really necessary. Check with the
@@ -593,13 +594,13 @@
</note>
<p>
-For our admin user, ALL will do. For the guest user, SELECT will be sufficient
-for read only access. database is the database we wish the user to have these
-permissions on. In this example, gentoo is the database. The .* means all
-tables. If you wanted to, you could apply per table access. user is the name of
-the user and host is the hostname the user will be accessing from. In most
-cases, this will be localhost. Finally, password is the user's password. Given
-the information, let's go ahead and create our users.
+For our admin user, ALL will do. For the guest user, <c>SELECT</c> will be
+sufficient for read only access. database is the database we wish the user
+to have these permissions on. In this example, gentoo is the database. The .*
+means all tables. If you wanted to, you could apply per table access. user is
+the name of the user and host is the hostname the user will be accessing from.
+In most cases, this will be localhost. Finally, password is the user's
+password. Given the information, let's go ahead and create our users.
</p>
<pre caption="Creating the admin and guest user">
@@ -742,7 +743,7 @@
The admin user can access the database as they please. Now sometimes, we need
to get rid of user permissions. This could be anything from a problematic user
to a retired employee. Let's take a look at how to disable user permissions
-with the REVOKE command.
+with the <c>REVOKE</c> command.
</p>
</body>
@@ -807,7 +808,7 @@
And our problematic user is no longer able to access the gentoo database.
Please note that the user was still able to login. That is because they remain
in the main MySQL database. Let's take a look at how to completely remove an
-account with DELETE and the MySQL user table.
+account with <c>DELETE</c> and the MySQL user table.
</p>
</body>
@@ -868,11 +869,10 @@
<p>
Now that we have our information, we can get rid of the guest user.
-This is done with the <c>DELETE command</c>. The format of the <c>
-DELETE</c> command for our usage is as follows:
+This is done with the <c>DELETE</c> command and the syntax is shown below.
</p>
-<pre caption="DELETE format">
+<pre caption="DELETE Syntax">
DELETE FROM table WHERE field='value';
</pre>
@@ -921,19 +921,19 @@
<ul>
<li>
- <uri link="http://www.phpmyadmin.net/home_page/">phpMyAdmin</uri> - Popular
- php based MySQL administration tool.
- </li>
+ <uri link="http://www.phpmyadmin.net/home_page/">phpMyAdmin</uri> - Popular
+ php based MySQL administration tool.
+ </li>
<li>
- <uri
- link="http://sourceforge.net/projects/mysqlnavigator/">mysqlnavigator</uri>
- - QT frontend to MySQL.
- </li>
+ <uri
+ link="http://sourceforge.net/projects/mysqlnavigator/">mysqlnavigator</uri>
+ - QT frontend to MySQL.
+ </li>
<li>
- <uri link="http://gmyclient.sourceforge.net/">gmyclient</uri> - A GNOME
- based MySQL client.
- </li>
- <li><uri link="http://www.knoda.org/">knoda</uri> - A KDE MySQL client</li>
+ <uri link="http://gmyclient.sourceforge.net/">gmyclient</uri> - A GNOME
+ based MySQL client.
+ </li>
+ <li><uri link="http://www.knoda.org/">knoda</uri> - A KDE MySQL client.</li>
</ul>
<p>
@@ -945,5 +945,4 @@
</body>
</section>
</chapter>
-
</guide>
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-08-26 19:51 Shyam Mani
0 siblings, 0 replies; 12+ messages in thread
From: Shyam Mani @ 2005-08-26 19:51 UTC (permalink / raw
To: gentoo-doc-cvs
fox2mike 05/08/26 19:51:26
Modified: xml/htdocs/doc/en mysql-howto.xml
Log:
Typo fix, s/privlege/privilege/g. Thanks to rane for reporting.
Revision Changes Path
1.3 +11 -11 xml/htdocs/doc/en/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.3&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.3&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml.diff?r1=1.2&r2=1.3&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- mysql-howto.xml 25 Aug 2005 07:47:00 -0000 1.2
+++ mysql-howto.xml 26 Aug 2005 19:51:26 -0000 1.3
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.2 2005/08/25 07:47:00 fox2mike Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.3 2005/08/26 19:51:26 fox2mike Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
@@ -24,7 +24,7 @@
<license/>
<version>1.1</version>
-<date>2005-08-25</date>
+<date>2005-08-27</date>
<chapter>
<title>Getting Started With MySQL</title>
@@ -557,7 +557,7 @@
</p>
<pre caption="GRANT Syntax">
-GRANT [privleges] ON database.* TO '[user]'@'[host]' IDENTIFIED BY '[password]';
+GRANT [privileges] ON database.* TO '[user]'@'[host]' IDENTIFIED BY '[password]';
</pre>
<note>
@@ -567,18 +567,18 @@
</note>
<p>
-First we have the privleges we wish to assign. With what we've learned so far,
-here are some of the privleges you can set:
+First we have the privileges we wish to assign. With what we've learned so far,
+here are some of the privileges you can set:
</p>
<ul>
- <li><c>ALL</c> - Gives the all privlege control for the database</li>
+ <li><c>ALL</c> - Gives the all privilege control for the database</li>
<li><c>CREATE</c> - Allows users to create tables</li>
<li><c>SELECT</c> - Allows users to query tables</li>
<li><c>INSERT</c> - Allows users to insert data into a table</li>
<li><c>SHOW DATABASES</c> - Allows users to see a list of databases</li>
- <li><c>USAGE</c> - User has no privleges</li>
- <li><c>GRANT OPTION</c> - Allows users to grant privleges</li>
+ <li><c>USAGE</c> - User has no privileges</li>
+ <li><c>GRANT OPTION</c> - Allows users to grant privileges</li>
</ul>
<note>
@@ -632,7 +632,7 @@
<p>
We shall now attempt to login as the guest user. Currently, the guest user has
-<c>SELECT</c> only privleges. This basically comes down to being able to search
+<c>SELECT</c> only privileges. This basically comes down to being able to search
and nothing more. Go ahead and login with the guest account.
</p>
@@ -759,14 +759,14 @@
</p>
<pre caption="REVOKE Syntax">
-REVOKE [privleges] ON database.* FROM '[user]'@'[host]';
+REVOKE [privileges] ON database.* FROM '[user]'@'[host]';
</pre>
<p>
Options here are explained in the <c>GRANT</c> command section. In this section
however, we're going to deny full access to a user. Let's say we find out the
guest account is causing some problems security wise. We decide to revoke all
-privleges. We login as root and do the needful.
+privileges. We login as root and do the needful.
</p>
<pre caption="Revoking user permissions">
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-12-02 13:16 Xavier Neys
0 siblings, 0 replies; 12+ messages in thread
From: Xavier Neys @ 2005-12-02 13:16 UTC (permalink / raw
To: gentoo-doc-cvs
neysx 05/12/02 13:16:11
Modified: xml/htdocs/doc/en mysql-howto.xml
Log:
Minor changes
Revision Changes Path
1.4 +12 -12 xml/htdocs/doc/en/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.4&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.4&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml.diff?r1=1.3&r2=1.4&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- mysql-howto.xml 26 Aug 2005 19:51:26 -0000 1.3
+++ mysql-howto.xml 2 Dec 2005 13:16:11 -0000 1.4
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.3 2005/08/26 19:51:26 fox2mike Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.4 2005/12/02 13:16:11 neysx Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
@@ -23,8 +23,8 @@
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
-<version>1.1</version>
-<date>2005-08-27</date>
+<version>1.2</version>
+<date>2005-12-02</date>
<chapter>
<title>Getting Started With MySQL</title>
@@ -66,7 +66,7 @@
<pre caption="MySQL einfo message">
You might want to run:
-"ebuild /var/db/pkg/dev-db/mysql-[version]/mysql-[version].ebuild config"
+"emerge --config =dev-db/mysql-[version]"
if this is a new install.
</pre>
@@ -141,7 +141,7 @@
$ <i>mysql -u root -h localhost -p</i>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
-Your MySQL connection id is 4 to server version: 4.0.24-debug
+Your MySQL connection id is 4 to server version: 4.0.25
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
@@ -225,7 +225,7 @@
our new gentoo database, we need to select it as our current database. To do
so, we use the <c>USE</c> command. The <c>USE</c> command takes the name of the
database you wish to use as your current database. Another option is to set it
-on the command line after the <c>-p</c> switch. Let's go ahead and switch to
+on the command line after the <c>-D</c> switch. Let's go ahead and switch to
the gentoo database.
</p>
@@ -384,9 +384,9 @@
</p>
<pre caption="~/records.txt">
-John Doe johndoe@gentoo.org portage
-Chris White chriswhite@gentoo.org documentation
-Sam Smith samsmith@gentoo.org amd64
+John Doe johndoe@gentoo.org portage
+Chris White chriswhite@gentoo.org documentation
+Sam Smith samsmith@gentoo.org amd64
</pre>
<impo>
@@ -640,7 +640,7 @@
$ <i>mysql -u guest -h localhost -p</i>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
-Your MySQL connection id is 6 to server version: 4.0.24-debug
+Your MySQL connection id is 6 to server version: 4.0.25
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
@@ -702,7 +702,7 @@
$ <i>mysql -u admin -h localhost -p</i>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
-Your MySQL connection id is 7 to server version: 4.0.24-debug
+Your MySQL connection id is 7 to server version: 4.0.25
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
@@ -788,7 +788,7 @@
$ <i>mysql -u guest -h localhost -p</i>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
-Youra MySQL connection id is 9 to server version: 4.0.24-debug
+Your MySQL connection id is 9 to server version: 4.0.25
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2005-12-15 15:39 Xavier Neys
0 siblings, 0 replies; 12+ messages in thread
From: Xavier Neys @ 2005-12-15 15:39 UTC (permalink / raw
To: gentoo-doc-cvs
neysx 05/12/15 15:39:41
Modified: xml/htdocs/doc/en mysql-howto.xml
Log:
#115655 s/VALUE(/VALUES(/
Revision Changes Path
1.5 +8 -8 xml/htdocs/doc/en/mysql-howto.xml
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.5&content-type=text/x-cvsweb-markup&cvsroot=gentoo
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.5&content-type=text/plain&cvsroot=gentoo
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml.diff?r1=1.4&r2=1.5&cvsroot=gentoo
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- mysql-howto.xml 2 Dec 2005 13:16:11 -0000 1.4
+++ mysql-howto.xml 15 Dec 2005 15:39:41 -0000 1.5
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.4 2005/12/02 13:16:11 neysx Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.5 2005/12/15 15:39:41 neysx Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
@@ -23,8 +23,8 @@
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
-<version>1.2</version>
-<date>2005-12-02</date>
+<version>1.3</version>
+<date>2005-12-15</date>
<chapter>
<title>Getting Started With MySQL</title>
@@ -359,11 +359,11 @@
<p>
This command is used to insert a record into table. table contains the MySQL
table we wish to enter the information into. The table name may be followed by
-the list of columns to insert data into and <c>VALUE()</c> contains the values you
-wish to insert into the table. You may omit the list of columns if you insert a
-value into each one and if you write the values in the same order the columns
-have been defined. In this case, we want to insert data into the developers
-table. Let's insert sample records:
+the list of columns to insert data into and <c>VALUES()</c> contains the values
+you wish to insert into the table. You may omit the list of columns if you
+insert a value into each one and if you write the values in the same order the
+columns have been defined. In this case, we want to insert data into the
+developers table. Let's insert sample records:
</p>
<pre caption="Inserting information into our developers table">
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2006-08-08 13:45 Xavier Neys
0 siblings, 0 replies; 12+ messages in thread
From: Xavier Neys @ 2006-08-08 13:45 UTC (permalink / raw
To: gentoo-doc-cvs
neysx 06/08/08 13:45:33
Modified: mysql-howto.xml
Log:
#143118 Use emerge --config
Revision Changes Path
1.6 xml/htdocs/doc/en/mysql-howto.xml
file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?rev=1.6&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?rev=1.6&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?r1=1.5&r2=1.6
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- mysql-howto.xml 15 Dec 2005 15:39:41 -0000 1.5
+++ mysql-howto.xml 8 Aug 2006 13:45:33 -0000 1.6
@@ -1,8 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.5 2005/12/15 15:39:41 neysx Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.6 2006/08/08 13:45:33 neysx Exp $ -->
-<guide link="/doc/en/mysql-howto.xml">
+<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
<author title="Author">
@@ -23,8 +23,8 @@
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
-<version>1.3</version>
-<date>2005-12-15</date>
+<version>1.4</version>
+<date>2006-08-08</date>
<chapter>
<title>Getting Started With MySQL</title>
@@ -81,7 +81,8 @@
</p>
<pre caption="MySQL configuration">
-# <i>ebuild /var/db/pkg/dev-db/mysql-[version]/mysql-[version].ebuild config</i>
+<comment>(Replace [version] with the version number you have just installed.)</comment>
+# <i>emerge --config =dev-db/mysql-[version]</i>
* MySQL DATADIR is /var/lib/mysql
* Press ENTER to create the mysql database and set proper
* permissions on it, or Control-C to abort now...
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2006-09-13 14:19 Jan Kundrat
0 siblings, 0 replies; 12+ messages in thread
From: Jan Kundrat @ 2006-09-13 14:19 UTC (permalink / raw
To: gentoo-doc-cvs
jkt 06/09/13 14:19:26
Modified: mysql-howto.xml
Log:
16:09 < honzig> hi, I found a mistake in MySQL Startup Guide [http://www.gentoo.org/doc/en/mysql-howto.xml].. SQL stands for Structured Query Language, not Standard Query Language..
Revision Changes Path
1.7 xml/htdocs/doc/en/mysql-howto.xml
file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?rev=1.7&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?rev=1.7&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?r1=1.6&r2=1.7
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- mysql-howto.xml 8 Aug 2006 13:45:33 -0000 1.6
+++ mysql-howto.xml 13 Sep 2006 14:19:26 -0000 1.7
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.6 2006/08/08 13:45:33 neysx Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.7 2006/09/13 14:19:26 jkt Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
@@ -23,7 +23,7 @@
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
-<version>1.4</version>
+<version>1.5</version>
<date>2006-08-08</date>
<chapter>
@@ -34,7 +34,7 @@
<p>
MySQL is a popular database server that is used in various applications. SQL
-stands for (S)tandard (Q)uery (L)anguage, which is what MySQL uses to
+stands for (S)tructured (Q)uery (L)anguage, which is what MySQL uses to
communicate with other programs. On top of that, MySQL has its own expanded SQL
functions to provide additional functionality to users. In this document, we'll
look at how to do the initial MySQL installation, set up databases and tables,
--
gentoo-doc-cvs@gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
* [gentoo-doc-cvs] cvs commit: mysql-howto.xml
@ 2008-05-19 20:35 Sven Vermeulen
0 siblings, 0 replies; 12+ messages in thread
From: Sven Vermeulen @ 2008-05-19 20:35 UTC (permalink / raw
To: gentoo-doc-cvs
swift 08/05/19 20:35:00
Modified: mysql-howto.xml
Log:
Coding style
Revision Changes Path
1.8 xml/htdocs/doc/en/mysql-howto.xml
file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?rev=1.8&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?rev=1.8&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-howto.xml?r1=1.7&r2=1.8
Index: mysql-howto.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- mysql-howto.xml 13 Sep 2006 14:19:26 -0000 1.7
+++ mysql-howto.xml 19 May 2008 20:35:00 -0000 1.8
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.7 2006/09/13 14:19:26 jkt Exp $ -->
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.8 2008/05/19 20:35:00 swift Exp $ -->
<guide link="/doc/en/mysql-howto.xml">
<title>MySQL Startup Guide</title>
@@ -563,8 +563,8 @@
<note>
<c>GRANT</c> is considered to be the way to create a user. Later versions of
-MySQL, however, do contain a <c>CREATE_USER</c> function, though <c>GRANT</c> is still
-preferred.
+MySQL, however, do contain a <c>CREATE_USER</c> function, though <c>GRANT</c>
+is still preferred.
</note>
<p>
@@ -584,8 +584,8 @@
<note>
If you're running MySQL to communicate data to a web application, <c>CREATE</c>,
-<c>SELECT</c>, <c>INSERT</c> (discussed here), <c>DELETE</c> and <c>UPDATE</c>
-(for further infomation look up the
+<c>SELECT</c>, <c>INSERT</c> (discussed here), <c>DELETE</c> and <c>UPDATE</c>
+(for further infomation look up the
<uri link="http://dev.mysql.com/doc/mysql/en/grant.html"> MySQL
Reference Manual - GRANT and REVOKE Syntax</uri> section) are the only
permissions you will most likely need. A lot of people make the mistake of
@@ -595,12 +595,12 @@
</note>
<p>
-For our admin user, ALL will do. For the guest user, <c>SELECT</c> will be
-sufficient for read only access. database is the database we wish the user
-to have these permissions on. In this example, gentoo is the database. The .*
+For our admin user, ALL will do. For the guest user, <c>SELECT</c> will be
+sufficient for read only access. database is the database we wish the user
+to have these permissions on. In this example, gentoo is the database. The .*
means all tables. If you wanted to, you could apply per table access. user is
the name of the user and host is the hostname the user will be accessing from.
-In most cases, this will be localhost. Finally, password is the user's
+In most cases, this will be localhost. Finally, password is the user's
password. Given the information, let's go ahead and create our users.
</p>
--
gentoo-doc-cvs@lists.gentoo.org mailing list
^ permalink raw reply [flat|nested] 12+ messages in thread
end of thread, other threads:[~2008-05-19 20:35 UTC | newest]
Thread overview: 12+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2005-08-24 11:51 [gentoo-doc-cvs] cvs commit: mysql-howto.xml Shyam Mani
-- strict thread matches above, loose matches on Subject: below --
2005-08-24 14:47 Xavier Neys
2005-08-24 17:07 Xavier Neys
2005-08-25 5:19 Shyam Mani
2005-08-25 5:21 Shyam Mani
2005-08-25 7:47 Shyam Mani
2005-08-26 19:51 Shyam Mani
2005-12-02 13:16 Xavier Neys
2005-12-15 15:39 Xavier Neys
2006-08-08 13:45 Xavier Neys
2006-09-13 14:19 Jan Kundrat
2008-05-19 20:35 Sven Vermeulen
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox