diff options
Diffstat (limited to 'doc/gettext/ru/mysql-howto.xml.po')
| -rw-r--r-- | doc/gettext/ru/mysql-howto.xml.po | 1360 |
1 files changed, 1360 insertions, 0 deletions
diff --git a/doc/gettext/ru/mysql-howto.xml.po b/doc/gettext/ru/mysql-howto.xml.po new file mode 100644 index 0000000..65a0f84 --- /dev/null +++ b/doc/gettext/ru/mysql-howto.xml.po @@ -0,0 +1,1360 @@ +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:46+0600\n" +"Last-Translator: Automatically generated\n" +"Language-Team: none\n" +"Language: ru\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n" +"%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\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>\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></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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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 < 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> <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> <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> <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> <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> <i>GRANT ALL ON gentoo.* TO 'admin'@'localhost' IDENTIFIED BY 'password';</i>\n" +"<comment>(guest)</comment>\n" +"mysql> <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> <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>\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> <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> <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> <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>\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> <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> <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> <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> <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>\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> <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> <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>\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> <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> <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> <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> <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> <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 "" |