Connor: Created page with "

Running MySQL

2012-07-19T10:25:31Z

Created page with "<h1>Running MySQL</h1> <table border="1"> <tr> <th>Name of the server</th> <td>mysqld or mysqld.exe</td> </tr> <tr> <th>Name of the client</th> <td>mysql or mysql.exe</td> </..."

New page

<h1>Running MySQL</h1>
<table border="1">
<tr>
<th>Name of the server</th>
<td>mysqld or mysqld.exe</td>
</tr>

<tr>
<th>Name of the client</th>
<td>mysql or mysql.exe</td>
</tr>

<tr>
<th>Typical command line to start the client</th>
<td><tt>c:\mysql\bin\mysql -h pc236nt.napier.ac.uk -u scott -p gisq</tt><br/>
<dl>
<p><dt>pc236nt.napier.ac.uk</p>
<dd><p>the internet address of a computer running the server</p>
<dt><p>scott</p>
<dd><p>the user name</p>
<dt><p>gisq</p>
<dd><p>the name of the database to use</p>
<dt><p>-p</p>
<dd><p>forces a prompt for password</p>
</dl>
</td>
</tr>

<tr>
<th>Useful commands</th>
<td><pre>show tables;
describe tableX;
use databaseY;
help
source file.txt
</pre></td>
</tr>

<tr>
<th>Beware!</th>
<td>Foreign keys are not enforced. Table names are case sensitive
when running on Unix</td>
</tr>

</table>
<p>
The MySQL client is called mysql.
</p>
<pre style="padding:1em;color:black; background-color:rgb(192,192,192);width:100ex;">
C:\>c:\mysql\bin\mysql -h pc236nt.napier.ac.uk -u scott -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33601 to server version: 3.23.43-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

use gisq
Database changed
mysql>SELECT name FROM cia;
...
| Western Sahara |
| Yemen |
| Zambia |
| Zimbabwe |
+----------------------------------------------+
261 rows in set (0.01 sec)
mysql>exit</pre>
<p>Some useful commands in MySQL:</p>
<ul><li>show tables;</li>
<li>describe <i>cia</i>;</li>
</ul>

Name of the server	mysqld or mysqld.exe
Name of the client	mysql or mysql.exe

Starting MySQL - Revision history

Connor: Created page with "

Running MySQL