MySQL Notes
From OpenEMR Project Wiki
Revision as of 15:32, 29 May 2014 by David Eschelbacher (talk | contribs) (Created page with "==Files== {| style="margin: 0 0em 0 0em;" |- | width="250" | <tt style="font-size: 130%">/etc/mysql/my.cnf</tt> | width="400" | MySQL Config File |- | <tt style="font-size: 130%"...")
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 | |
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;
