Difference between revisions of "MySQL Notes"

From OpenEMR Project Wiki
Line 54: Line 54:
   
   
*Change Password
*Change Password
mysqladmin -u root -p password yourpassword
::<tt style="font-size: 130%"> mysqladmin -u root -p password yourpassword</tt>


*Create Database
*Create Database
mysqladmin -u root -p create database1
::<tt style="font-size: 130%">mysqladmin -u root -p create database1</tt>


<br>
<br>

Revision as of 14:54, 31 May 2014

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 -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