mysql安装笔记

mysqladmin -u root password ***	#change root password
mysql -u root -p 		#login
show databases
show tables
create database heroing_os;
show variables like 'character%';

 -> +--------------------------+----------------------------+
    -> | character_set_client     | latin1                     |
    -> | character_set_connection | latin1                     |
    -> | character_set_database   | latin1                     |
    -> | character_set_filesystem | binary                     |
    -> | character_set_results    | latin1                     |
    -> | character_set_server     | latin1                     |
    -> | character_set_system     | utf8                       |
    -> | character_sets_dir       | /usr/share/mysql/charsets/ |
    -> +--------------------------+----------------------------+
    -> 8 rows in set (0.00 sec)

set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_results=utf8;
set character_set_server=utf8;

commit;

use heroing_os;

create table employee(
	id int(11),
	dept int(11),
	name varchar(255),
	hiredate date
);

create table if not exists employee2(
	id int(11),
	dept int(11),
	name varchar(255),
	hiredate date
);

desc employee;
show create table employee;

alter table employee default character set utf8;
alter database heroing_os default character set utf8;
show character set;