MySQL Notes

Files

/etc/mysql/my.cnf	MySQL Config File
/usr/share/mysql	Location of sample config files.

Config File Parameters

bind-address	Default is localhost. To access mysql from networked computer, change to IP address.

Configuration

• xxx

xxx

Testing

• xxx

Command Line Commands

mysql -u root

• Login to MySQL

mysqladmin -u root -p

• Change Password

mysqladmin -u root -p password yourpassword

• Create Database

mysqladmin -u root -p create database1

MySQL Console Commands

• Commands can span several lines. Semicolon marks end of command. Semicolon at end of line executes command.

• Set Password for Root

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

• Create Database

CREATE DATABASE database1;

• Exit MySQL

\q