Appion

h1. MySQL Notes

h2. restart mysql on centOS

<pre> /etc/init.d/mysqld restart </pre>

h2. Find out which installation is being used

<pre>which mysql</pre> 

h2. Get access to our databases

To get access to our databases, you need to ask Christopher (or someone else with the correct privileges) to add you as a user.

Our databases reside on Cronus4 (Appion and Leginon things), ami (websites and tools like Redmine), and Fly (a copy of Cronus4 used for testing).

Once added, you will need to change your password from the default to something all your own on each server that you are added to. Here's how:

At a terminal type:

<pre>

mysql -h cronus4 -u [yourUserName] -p

</pre>

You are prompted to type your default password. Then, change your password with:

<pre>

set password = password("[new password]");

</pre>

h2. Other MySQL commands to try

show databases;

use [name of db]

show tables;

describe [name of table];

h2. To stop a query that is taking too long:

<pre>

mysql> showprocesslist;

mysql> kill [process Id number];

</pre>

h2. Mysql bug with nested subqueries

[[Mysql Nested Subqueries Problem]]