MySQL Reference for Unix, Linux and OS X

sudo usr/local/mysql/bin/mysqld_safe
enter your password
Press the keys: Ctrl+Z
bg

sudo mysqld_safe
enter your password
Press the keys: Ctrl+Z
bg

usr/local/mysql/bin/mysqladmin -u root -p shutdown
enter your password

mysqladmin -u root -p shutdown
enter your password

/usr/local/mysql/bin/mysqladmin -u root password <password>
enter your password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password>
enter your password

mysqladmin -u root password <password>
enter your password
mysqladmin -u root -h `hostname` password <password>
enter your password

/usr/local/mysql/bin/mysql -u root -p
enter your password

mysql -u root -p
enter your password

use mysql
delete from user where user = ' ';
delete from user where user = 'root' and password = ' ';
flush privileges;

drop database test;

grant select, insert on employee.* to Bob_user@localhost identified by 'password';

grant all on employee.* to Bob_user@localhost identified by 'password';

show grants for Bob_user@localhost;

show grants for root@localhost;

revoke select, insert on employee.* from Bob_user@localhost;

revoke all on employee.* from Bob_user@localhost;

open a new shell and type:
/usr/local/mysql/bin/mysqldump -u root -p employee.db > employee.sql
enter your password

login to mysql client:
/usr/local/mysql/bin/mysql -u root -p
enter your password
create a database called "employee.db":
create database employee.db;
open a new shell and type:
/usr/local/mysql/bin/mysql -u root -p employee.db < employee.sql

open a new shell and type:
/usr/local/mysql/bin/mysqldump -u root -p -A > dbsbackup.sql
enter your password

open a new shell and type:
/usr/local/mysql/bin/mysql -u root -p < dbsbackup.sql
enter your password

edit the file: /etc/profile and update the path by adding:
usr/local/mysql/bin/ for example:
PATH="/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/mysql/bin"

login to mysql client and type:
show variables;

login to mysql client and type:
show processlist;

login to mysql client and type:
usr/local/mysql/bin/mysqladmin -u root -p showprocesslist
enter your password

login to mysql client and type:
show status;

use the above show variables; to display variables and
set a variable by typing:
set variable=value;
example:
set sql_safe_updates=1;

MySQL will look inside the /etc for "my.cnf" file.
This file does not exist by default.
You can find an example of such a file under:
/usr/local/mysql/supportfiles/my-large.cnf

Or search for such a file by openning a new shell and type:
sudo find / -name my-large.cnf -print

Create the file "my.cnf" and copy it inside the /etc folder.
You can set the MySQL Client, Server and other Configuration
for example:
[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
basedir = /usr/local/mysql/
datadir = /servers/raiddrive/databases/

Put the new "my.cnf" in /etc folder and shut down and restart mysql server.

You can display the current configuration and after update configuration by typing:
show variables;

When running MySQL and PHP on the same Mac OS X 10.4 server, you may find that PHP cannot connect to MySQL. When PHP is communicating with a MySQL server on the same host, it uses a socket file to communicate, and looks for it at /tmp/mysql.sock. On Mac OS X Server 10.4, MySQL creates this socket file at /var/mysql/mysql.sock. To resolve this issue, you can either change the location where MySQL creates its socket file, or modify the location where PHP looks for the file. Please note that the first option is less secure than the second.

I. To change the location where MySQL creates its socket file, do this:

1. Open your preferred text editor and create a plain text file.
2. Type this text (on two lines as shown):
   [mysqld]
   socket=/tmp/mysql.sock
3. Save the file as: /etc/my.cnf

II. To change the location where PHP looks for the socket file, follow these steps:

1. In terminal type:
   sudo cp /etc/php.ini.default /etc/php.ini
2. Open /etc/php.ini in your preferred text editor.
3. Find the [MySQL] section, and change the mysql.default_socket directive:
   ; Default socket name for local MySQL connects.
   If empty, uses the built-in ; MySQL defaults.
   mysql.default_socket = /var/mysql/mysql.sock
4. Change the permissions on /var/mysql so that www can read the socket, by executing this in Terminal:
   sudo chmod 775 /var/mysql