path: root/doc/gettext/el/mysql-howto.xml.po

msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"POT-Creation-Date: 2010-10-21 23:56+0600\n"
"PO-Revision-Date: 2010-10-21 23:56+0600\n"
"Last-Translator: Automatically generated\n"
"Language-Team: none\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Language: el\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(guide:link):5
msgid "/doc/en/mysql-howto.xml"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):6
msgid "MySQL Startup Guide"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(author:title):8
msgid "Author"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(mail:link):9
msgid "chriswhite@gentoo.org"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(mail):9
msgid "Chris White"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(author:title):11
#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(author:title):14
msgid "Editor"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(mail:link):12
msgid "fox2mike@gentoo.org"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(mail):12
msgid "Shyam Mani"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(mail:link):15
msgid "neysx@gentoo.org"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(mail):15
msgid "Xavier Neys"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(abstract):18
msgid "This document helps a user set up and use MySQL."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(version):26
msgid "1.5"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(date):27
msgid "2006-08-08"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):30
msgid "Getting Started With MySQL"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):32
msgid "Background"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):35
msgid ""
"MySQL is a popular database server that is used in various applications. SQL "
"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, and create new users. Let's start out with the "
"installation."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):47
msgid "MySQL Installation"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):50
msgid ""
"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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):56
msgid "Installing MySQL"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):56
#, no-wrap
msgid ""
"\n"
"<comment>(View available USE flags)</comment>\n"
"# <i>emerge --pretend --verbose mysql</i>\n"
"<comment>(Install MySQL)</comment>\n"
"# <i>emerge mysql</i>\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):63
msgid "Upon completion of the installation, you will see the following notice:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):67
msgid "MySQL einfo message"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):67
#, no-wrap
msgid ""
"\n"
"You might want to run:\n"
"\"emerge --config =dev-db/mysql-[version]\"\n"
"if this is a new install.\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):73
msgid ""
"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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):83
msgid "MySQL configuration"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):83
#, no-wrap
msgid ""
"\n"
"<comment>(Replace [version] with the version number you have just installed.)</comment>\n"
"# <i>emerge --config =dev-db/mysql-[version]</i>\n"
" * MySQL DATADIR is /var/lib/mysql\n"
" * Press ENTER to create the mysql database and set proper\n"
" * permissions on it, or Control-C to abort now...\n"
"\n"
"   Preparing db table\n"
"   Preparing host table\n"
"   Preparing user table\n"
"   Preparing func table\n"
"   Preparing tables_priv table\n"
"   Preparing columns_priv table\n"
"   Installing all prepared tables\n"
"\n"
"   To start mysqld at boot time you have to copy support-files/mysql.server\n"
"   to the right place for your system\n"
"\n"
"   PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !\n"
"   To do so, issue the following commands to start the server\n"
"   and change the applicable passwords:\n"
"<comment>(Note the next 3 lines)</comment>\n"
"   /etc/init.d/mysql start\n"
"   /usr/bin/mysqladmin -u root -h pegasos password 'new-password'\n"
"   /usr/bin/mysqladmin -u root password 'new-password'\n"
"   Depending on your configuration, a -p option may be needed\n"
"   in the last command. See the manual for more details.\n"
"\n"
"<comment>(Some MySQL non-ebuild specific information has been removed from here\n"
"so as to keep this document as consistent as possible)</comment>\n"
"\n"
"   * For security reasons you should set your MySQL root\n"
"   * password as soon as possible.\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(impo):118
msgid ""
"As of mysql-4.0.24-r2, passwords are entered during the config phase making "
"root password entry more secure."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):123
msgid ""
"The config script has already printed out the commands we need to run to "
"setup our password, so we shall now run them."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):128
msgid "Setting up your MySQL root password"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):128
#, no-wrap
msgid ""
"\n"
"# <i>/etc/init.d/mysql start</i>\n"
" * Re-caching dependency info (mtimes differ)...\n"
" * Starting mysqld (/etc/mysql/my.cnf) ...        [ ok ]\n"
"<comment>(Replace new-password with your desired password)</comment>\n"
"# <i>/usr/bin/mysqladmin -u root -h localhost password 'new-password'</i>\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):136
msgid ""
"You can now test that your root password was successfully configured by "
"trying to login to your MySQL server:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):141
msgid "Logging into the MySQL server using mysql"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):141
#, no-wrap
msgid ""
"\n"
"$ <i>mysql -u root -h localhost -p</i>\n"
"Enter password:\n"
"Welcome to the MySQL monitor. Commands end with ; or \\g.\n"
"Your MySQL connection id is 4 to server version: 4.0.25\n"
"\n"
"Type 'help;' or '\\h' for help. Type '\\c' to clear the buffer.\n"
"\n"
"mysql&gt;\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):152
msgid ""
"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&gt;</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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):166
msgid "Setting Up The Database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):168
msgid "Creating A Database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):171
msgid ""
"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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):177
msgid "Displaying MySQL databases"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):177
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SHOW DATABASES;</i>\n"
"+----------+\n"
"| Database |\n"
"+----------+\n"
"| mysql    |\n"
"| test     |\n"
"+----------+\n"
"2 rows in set (0.09 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(impo):188
msgid ""
"Please remember that MySQL commands should end with a semicolon -- <c>;</c>"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):192
msgid ""
"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\"."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):198
msgid "Creating the gentoo database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):198
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>CREATE DATABASE gentoo;</i>\n"
"Query OK, 1 row affected (0.08 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):203
msgid ""
"The response lets us know that the command was executed without any errors. "
"In this case, 1 row was modified. This is a reference to the main mysql "
"database, which carries a list of all the databases. You won't need to worry "
"too much about the background details. The last number is how fast the query "
"was executed. We can verify the database was created by running the <c>SHOW "
"DATABASES</c> command again."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):212
msgid "Verifing the database is created"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):212
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SHOW DATABASES;</i>\n"
"+----------+\n"
"| Database |\n"
"+----------+\n"
"| gentoo   |\n"
"| mysql    |\n"
"| test     |\n"
"+----------+\n"
"3 rows in set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):224
msgid ""
"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>-D</c> switch. Let's go "
"ahead and switch to the gentoo database."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):233
msgid "Switching our database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):233
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>USE gentoo;</i>\n"
"Database changed\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):238
msgid ""
"And the current database is now our previously created gentoo database. Now "
"that we're using it, we can start to create some tables and put information "
"in them."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):249
msgid "Working With Tables In MySQL"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):251
msgid "Creating a Table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):254
msgid ""
"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 "
"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:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):264
msgid "Empty gentoo Database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):264
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SHOW TABLES;</i>\n"
"Empty set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):269
msgid ""
"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. The form is as follows:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):276
msgid "CREATE TABLE Syntax"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):276
#, no-wrap
msgid ""
"\n"
"CREATE TABLE [table_name] ([field_name] [field_data_type]([size]));\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):280
msgid ""
"<b>table_name</b> is the name of the table we wish to create. In this case, "
"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 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. 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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):298
msgid "Creating our table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):298
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>CREATE TABLE developers ( name VARCHAR(128), email VARCHAR(128), job VARCHAR(128));</i>\n"
"Query OK, 0 rows affected (0.11 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):303
msgid ""
"Looks like our table was created ok. Let's check it with the <c>SHOW TABLES</"
"c> command:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):308
msgid "Verifying our table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):308
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SHOW TABLES;</i>\n"
"+------------------+\n"
"| Tables_in_gentoo |\n"
"+------------------+\n"
"| developers       |\n"
"+------------------+\n"
"1 row in set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):318
msgid ""
"Yes, there's our table. However, it doesn't seem to have any information on "
"the types of fields we setup. For that, we use the <c>DESCRIBE</c> command "
"(or <c>DESC</c> for short), which takes the name of the table as its "
"argument. Let's see what that gives us for our developers table."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):325
msgid "Describing our developers table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):325
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>DESCRIBE developers;</i>\n"
"+-------+--------------+------+-----+---------+-------+\n"
"| Field | Type         | Null | Key | Default | Extra |\n"
"+-------+--------------+------+-----+---------+-------+\n"
"| name  | varchar(128) | YES  |     | NULL    |       |\n"
"| email | varchar(128) | YES  |     | NULL    |       |\n"
"| job   | varchar(128) | YES  |     | NULL    |       |\n"
"+-------+--------------+------+-----+---------+-------+\n"
"3 rows in set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):337
msgid ""
"This shows the different fields and their types. It also shows a few extra "
"attributes that are beyond the scope of this howto. Feel free to refer to "
"the <uri link=\"http://dev.mysql.com/doc/mysql/en/\">MySQL Reference Manual</"
"uri> for more information. We now have a table to work with. Now let's go "
"ahead and populate it."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):348
msgid "Populating Our MySQL Database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):351
msgid ""
"We populate a table (or add data) using the <c>INSERT</c> command. Like the "
"<c>CREATE TABLE</c> command, it also has a specific format:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):356
msgid "INSERT Syntax"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):356
#, no-wrap
msgid ""
"\n"
"INSERT INTO table (col1, col2, ...) VALUES('value1', 'value2', ...);\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):360
msgid ""
"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>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:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):370
msgid "Inserting information into our developers table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):370
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>INSERT INTO developers VALUES('Joe Smith', 'joesmith@gentoo.org', 'toolchain');</i>\n"
"Query OK, 1 row affected (0.06 sec)\n"
"<comment>(If you don't know the order of the columns in the table or want to insert an incomplete record)</comment>\n"
"mysql&gt; <i>INSERT INTO developers (job, name) VALUES('outsourced', 'Jane Doe');</i>\n"
"Query OK, 1 row affected (0.01 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):378
msgid ""
"According to our return result, it appears that the record was inserted "
"correctly. What if we want to input more information than just one record? "
"That's where the <c>LOAD DATA</c> command comes into play. This loads "
"records from a tab separated file. Let's try that by editing a file in our "
"home directory with the records. We'll call this file <path>records.txt</"
"path>. Here's a sample:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):387
msgid "~/records.txt"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):387
#, no-wrap
msgid ""
"\n"
"John Doe\tjohndoe@gentoo.org\tportage\n"
"Chris White\tchriswhite@gentoo.org\tdocumentation\n"
"Sam Smith\tsamsmith@gentoo.org\tamd64\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(impo):393
msgid ""
"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!"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):398
msgid ""
"Now the <c>LOAD DATA</c> command has a somewhat enlongated definition, but "
"we'll use the simplest form here."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):403
msgid "LOAD DATA Syntax"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):403
#, no-wrap
msgid ""
"\n"
"LOAD DATA LOCAL INFILE '/path/to/filename' INTO TABLE table;\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):407
msgid ""
"<path>/path/to/filename</path> is the directory and filename that will be "
"used. table is the name of our table. In this case, our file is <path>~/"
"records.txt</path> and the table is developers."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):413
msgid "Loading in our data"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):413
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>LOAD DATA LOCAL INFILE '~/records.txt' INTO TABLE developers;</i>\n"
"Query OK, 3 rows affected (0.00 sec)\n"
"Records: 3  Deleted: 0  Skipped: 0  Warnings: 0\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(impo):419
msgid ""
"If you come up with any strange behaviour, make sure your fields are "
"separated by tabs. If you paste information into your infile from another "
"source, it may convert your tabs to spaces."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):425
msgid ""
"That worked well. However, this simply inserts records, and does not give "
"you any sort of control over MySQL. Many web applications use sql scripts in "
"order to setup MySQL quickly and easily. If you want to use an sql script, "
"you'll need to run mysql in batch mode, or source the file. Here's an "
"example of running mysql in batch mode:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):433
msgid "MySQL in batch mode"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):433
#, no-wrap
msgid ""
"\n"
"$ <i>mysql -u root -h localhost -p &lt; sqlfile</i>\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):437
msgid ""
"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 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:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):445
msgid "Sourcing an sql file"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):445
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>source sqlfile;</i>\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):449
msgid ""
"If you see a web application wanting you to run an sql file, the two above "
"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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):458
msgid "Browsing MySQL Tables With Queries"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):461
msgid ""
"Queries are one of the main features of any SQL database. They help us turn "
"data in our tables into something useful. Most queries are done with the "
"<c>SELECT</c> command. The <c>SELECT</c> command is fairly complex, and "
"we're only going to look at three main forms of the command in this document."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):468
msgid "SELECT forms"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):468
#, no-wrap
msgid ""
"\n"
"<comment>(Select all entries in a table)</comment>\n"
"SELECT * FROM table;\n"
"<comment>(Select specific entries in a table)</comment>\n"
"SELECT * FROM table WHERE field=value;\n"
"<comment>(Select specific fields)</comment>\n"
"SELECT field1,field2,field3 FROM table [WHERE field=value];\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):477
msgid ""
"Let's take a quick look at the first form. It's relatively simple and gives "
"you an overall look of your table. We'll go ahead and run it to see what "
"data we have so far."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):483
msgid "Contents of our table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):483
#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):679
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SELECT * FROM developers;</i>\n"
"+-------------+-----------------------+----------------+\n"
"| name        | email                 | job            |\n"
"+-------------+-----------------------+----------------+\n"
"| Joe Smith   | joesmith@gentoo.org   | toolchain      |\n"
"| John Doe    | johndoe@gentoo.org    | portage        |\n"
"| Chris White | chriswhite@gentoo.org | documentation  |\n"
"| Sam Smith   | samsmith@gentoo.org   | amd64          |\n"
"| Jane Doe    | NULL                  | Outsourced job |\n"
"+-------------+-----------------------+----------------+\n"
"5 rows in set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):497
msgid ""
"We see both the data we inserted through <c>INSERT</c> and those inserted by "
"<c>LOAD DATA</c> present. Now, let's say that we just want to see the record "
"for Chris White. We can do so with the second form of select as shown below."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):503
msgid "Selecting a specific record using SELECT"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):503
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SELECT * FROM developers WHERE name = 'Chris White';</i>\n"
"+-------------+-----------------------+---------------+\n"
"| name        | email                 | job           |\n"
"+-------------+-----------------------+---------------+\n"
"| Chris White | chriswhite@gentoo.org | documentation |\n"
"+-------------+-----------------------+---------------+\n"
"1 row in set (0.08 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):513
msgid ""
"As expected, the specific entry that we were looking for has been selected. "
"Now, let's say we only wanted to know the person's job and email address, "
"not their name. We can do so with the third form of <c>SELECT</c> as shown "
"here."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):519
msgid "Selecting a specific record and fields using SELECT"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):519
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SELECT email,job FROM developers WHERE name = 'Chris White';</i>\n"
"+-----------------------+---------------+\n"
"| email                 | job           |\n"
"+-----------------------+---------------+\n"
"| chriswhite@gentoo.org | documentation |\n"
"+-----------------------+---------------+\n"
"1 row in set (0.04 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):529
msgid ""
"This method of selection is a lot easier to manage, expecially with larger "
"amounts of information, as we'll see later on. Right now, being the root "
"mysql user, we have unlimited permissions to do what we wish with the MySQL "
"database. In a server environment, a user with such privileges can be quite "
"problematic. In order to control who does what with the databases, we setup "
"privileges."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):543
msgid "MySQL Privileges"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):545
msgid "Granting Privileges with GRANT"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):548
msgid ""
"Privileges are what kind of access users have to databases, tables, pretty "
"much anything. Right now in the gentoo database, the MySQL root account is "
"the only account that can access it, given its permissions. Now, let's "
"create two somewhat generic users, guest and admin, who will access the "
"gentoo database and work with the information in it. The guest account will "
"be a restricted one. All it will be able to do is get information from the "
"database, and that's it. admin will have the same control as root, but only "
"for the gentoo database (not the main mysql databases). Before we start on "
"that, let's have a closer look at this somewhat simplified format of the "
"<c>GRANT</c> command."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):560
msgid "GRANT Syntax"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):560
#, no-wrap
msgid ""
"\n"
"GRANT [privileges] ON database.* TO '[user]'@'[host]' IDENTIFIED BY '[password]';\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(note):564
msgid ""
"<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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):570
msgid ""
"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:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):576
msgid "<c>ALL</c> - Gives the all privilege control for the database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):577
msgid "<c>CREATE</c> - Allows users to create tables"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):578
msgid "<c>SELECT</c> - Allows users to query tables"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):579
msgid "<c>INSERT</c> - Allows users to insert data into a table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):580
msgid "<c>SHOW DATABASES</c> - Allows users to see a list of databases"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):581
msgid "<c>USAGE</c> - User has no privileges"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):582
msgid "<c>GRANT OPTION</c> - Allows users to grant privileges"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(note):585
msgid ""
"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 application developers to see if such "
"permissions will cause issues with general operation."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):597
msgid ""
"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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):607
msgid "Creating the admin and guest user"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):607
#, no-wrap
msgid ""
"\n"
"<comment>(admin)</comment>\n"
"mysql&gt; <i>GRANT ALL ON gentoo.* TO 'admin'@'localhost' IDENTIFIED BY 'password';</i>\n"
"<comment>(guest)</comment>\n"
"mysql&gt; <i>GRANT SELECT ON gentoo.* TO 'guest'@'localhost' IDENTIFIED BY 'password';</i>\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):614
msgid ""
"Now that we have the users setup, let's test them out. First we quit mysql "
"by typing <c>quit</c> at the command prompt:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):619
msgid "Quitting MySQL"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):619
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>quit</i>\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):623
msgid ""
"We're now back at the console. Now that we have our users setup, let's go "
"ahead and see what they can do."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):631
msgid "Testing User Permissions"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):634
msgid ""
"We shall now attempt to login as the guest user. Currently, the guest user "
"has <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."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):640
msgid "Logging in with the guest account"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):640
#, no-wrap
msgid ""
"\n"
"$ <i>mysql -u guest -h localhost -p</i>\n"
"Enter password:\n"
"Welcome to the MySQL monitor. Commands end with ; or \\g.\n"
"Your MySQL connection id is 6 to server version: 4.0.25\n"
"\n"
"Type 'help;' or '\\h' for help. Type '\\c' to clear the buffer.\n"
"\n"
"mysql&gt;\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):651
msgid ""
"Now we should test the user restriction(s). Let's switch to the gentoo "
"database:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):655
msgid "Switching to the gentoo database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):655
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>USE gentoo;</i>\n"
"Reading table information for completion of table and column names\n"
"You can turn off this feature to get a quicker startup with -A\n"
"\n"
"Database changed\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):663
msgid ""
"Now let's try to do something we are not supposed to. We'll attempt to "
"create a table."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):668
msgid "Attempting to create a table with the guest user"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):668
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>CREATE TABLE test (test VARCHAR(20), foobar VARCHAR(2));</i>\n"
"ERROR 1044: Access denied for user: 'guest@localhost' to database 'gentoo'\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):673
msgid ""
"As you can see, this function fails, as our user does not have the "
"appropriate access. However, one access we did grant is the <c>SELECT</c> "
"statement. Let's go ahead and try that:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):679
msgid "Attempting the SELECT statement"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):693
msgid ""
"The command succeeds, and we're given a glimpse of what user permissions can "
"do. We did, however, create an admin account as well. This was created to "
"show that even all permissions granted users can still have limitations. Go "
"ahead and quit MySQL and login as the admin."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):700
msgid "Logging in as admin"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):700
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>quit</i>\n"
"Bye\n"
"$ <i>mysql -u admin -h localhost -p</i>\n"
"Enter password:\n"
"Welcome to the MySQL monitor. Commands end with ; or \\g.\n"
"Your MySQL connection id is 7 to server version: 4.0.25\n"
"\n"
"Type 'help;' or '\\h' for help. Type '\\c' to clear the buffer.\n"
"\n"
"mysql&gt;\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):713
msgid ""
"To begin, we'll try creating a new database with our admin user. This admin "
"user will have access similiar to the root MySQL account, and will be able "
"to do any kind of modification to the gentoo database it chooses. This will "
"test the user's access to the main MySQL database. Remember ealier that we "
"only set permissions to a specific database."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):721
msgid "Attempting to create a new database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):721
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>CREATE DATABASE gentoo2;</i>\n"
"ERROR 1044: Access denied for user: 'admin@localhost' to database 'gentoo2'\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):726
msgid ""
"Indeed, the admin user cannot create databases on the main MySQL database, "
"despite all his permissions on the gentoo database. However, we're still "
"able to use the admin account to modify the gentoo database, as shown here "
"by this example data insertion."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):733
msgid "Admin permissions in gentoo database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):733
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>USE gentoo;</i>\n"
"Reading table information for completion of table and column names\n"
"You can turn off this feature to get a quicker startup with -A\n"
"\n"
"Database changed\n"
"mysql&gt; <i>INSERT INTO developers VALUES('Bob Simmons', 'bobsimmons@gentoo.org', 'python');</i>\n"
"Query OK, 1 row affected (0.08 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):743
msgid ""
"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 <c>REVOKE</c> command."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):753
msgid "Removing User Access With The REVOKE Command"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):756
msgid ""
"The <c>REVOKE</c> command lets us deny access to a user. We can either deny "
"full access, or specific access. In fact, the format is very similiar to "
"<c>GRANT</c>."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):762
msgid "REVOKE Syntax"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):762
#, no-wrap
msgid ""
"\n"
"REVOKE [privileges] ON database.* FROM '[user]'@'[host]';\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):766
msgid ""
"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 privileges. We login as root and do the needful."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):773
msgid "Revoking user permissions"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):773
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>REVOKE ALL ON gentoo.* FROM 'guest'@'localhost';</i>\n"
"Query OK, 0 rows affected (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(note):778
msgid ""
"In this case, user access is simple, so per database revoking is not a "
"problem. However, in larger cases, you would most likely be using *.* "
"instead of gentoo.* to remove user access to all other databases."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):784
msgid "Now let's quit and attempt to login as a guest user."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):788
msgid "Attempting guest user login"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):788
#, no-wrap
msgid ""
"\n"
"$ <i>mysql -u guest -h localhost -p</i>\n"
"Enter password:\n"
"Welcome to the MySQL monitor. Commands end with ; or \\g.\n"
"Your MySQL connection id is 9 to server version: 4.0.25\n"
"\n"
"Type 'help;' or '\\h' for help. Type '\\c' to clear the buffer.\n"
"\n"
"mysql&gt;\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):799
msgid "Although we're able to login, our access to gentoo is now gone."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):803
msgid "Denied access to guest account"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):803
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>USE gentoo;</i>\n"
"ERROR 1044: Access denied for user: 'guest@localhost' to database 'gentoo'\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):808
msgid ""
"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 <c>DELETE</c> and the MySQL user table."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):818
msgid "Removing Accounts Using DELETE"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):821
msgid ""
"The MySQL user table is a listing of all users and information about them. "
"Make sure you're logged in as root. Then go ahead and use the main MySQL "
"database."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):826
msgid "Using the main mysql database"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):826
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>USE mysql;</i>\n"
"Reading table information for completion of table and column names\n"
"You can turn off this feature to get a quicker startup with -A\n"
"\n"
"Database changed\n"
"mysql&gt;\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):835
msgid "Now let's see what tables the mysql database has:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):839
msgid "mysql database table listing"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):839
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SHOW TABLES;</i>\n"
"+-----------------+\n"
"| Tables_in_mysql |\n"
"+-----------------+\n"
"| columns_priv    |\n"
"| db              |\n"
"| func            |\n"
"| host            |\n"
"| tables_priv     |\n"
"| user            |\n"
"+-----------------+\n"
"6 rows in set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):854
msgid ""
"The user table is the table we're after. However, the user table contains 30 "
"different fields, making it very hard to read. In order to make things "
"easier to read, we'll go ahead and use the third version of the <c>SELECT</"
"c> statement. The fields we're after are Host and User."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):861
msgid "Finding our guest user in the user table"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):861
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>SELECT Host,User FROM user WHERE User = 'guest';</i>\n"
"+-----------+-------+\n"
"| Host      | User  |\n"
"+-----------+-------+\n"
"| localhost | guest |\n"
"+-----------+-------+\n"
"1 row in set (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):871
msgid ""
"Now that we have our information, we can get rid of the guest user. This is "
"done with the <c>DELETE</c> command and the syntax is shown below."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):876
msgid "DELETE Syntax"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):876
#, no-wrap
msgid ""
"\n"
"DELETE FROM table WHERE field='value';\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):880
msgid ""
"You may notice that <c>DELETE</c> is somewhat similiar to the <c>SELECT</c> "
"statement in its format. In this case, the field will be User, and the value "
"guest. This will delete the record in the user table where the user is "
"guest, successfully deleting our guest user account. Let's go ahead and do "
"that:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):887
msgid "Deleting the guest account"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):887
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>DELETE FROM user WHERE User='guest';</i>\n"
"Query OK, 1 row affected (0.07 sec)\n"
"<comment>(FLUSH PRIVILEGES is needed to update user permissions)</comment>\n"
"mysql&gt; <i>FLUSH PRIVILEGES;</i>\n"
"Query OK, 0 rows affected (0.00 sec)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):895
msgid ""
"It seems to have worked ok. Let's test by logging out and attempting to "
"login as our guest user."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre:caption):900
msgid "Attempting login as the guest user"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(pre):900
#, no-wrap
msgid ""
"\n"
"mysql&gt; <i>quit</i>\n"
"Bye\n"
"$ <i>mysql -u guest -h localhost -p</i>\n"
"Enter password:\n"
"ERROR 1045: Access denied for user: 'guest@localhost' (Using password: YES)\n"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):908
msgid "Our user is now successfully deleted!"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(title):915
msgid "Conclusion"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):918
msgid ""
"While this guide focuses mainly on setting up MySQL on the command line, a "
"few alternatives are available in GUI form:"
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):924
msgid ""
"<uri link=\"http://www.phpmyadmin.net/home_page/\">phpMyAdmin</uri> - "
"Popular php based MySQL administration tool."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):928
msgid ""
"<uri link=\"http://sourceforge.net/projects/mysqlnavigator/"
"\">mysqlnavigator</uri> - QT frontend to MySQL."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):933
msgid ""
"<uri link=\"http://gmyclient.sourceforge.net/\">gmyclient</uri> - A GNOME "
"based MySQL client."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(li):937
msgid "<uri link=\"http://www.knoda.org/\">knoda</uri> - A KDE MySQL client."
msgstr ""

#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(p):940
msgid ""
"This ends the MySQL introductory tutorial. I hope this gives you a better "
"understanding of the basics behind MySQL and getting a database set up. "
"Please email me at <mail>chriswhite@gentoo.org</mail> if you have any "
"comments."
msgstr ""

#. Place here names of translator, one per line. Format should be NAME; ROLE; E-MAIL
#: ../../gentoo/xml/htdocs/doc/en//mysql-howto.xml(None):0
msgid "translator-credits"
msgstr ""