mysql操作记录

/**********************查看进程是否启动************************/
netstat -tap|grep mysql
/**********************开启多个服务进程************************/
./mysqld --defaults-file=/etc/my.cnf --user=root
/**********************开启多个服务进程************************/
./mysqld_multi --defaults-file=D:\tools\mem\myql.cnf start 8999
/**********************关机************************/
mysqladmin shutdown
/**********************设置用户和密码************************/
mysqld-nt --skip-grant-tables
mysqladmin -u root flush-privileges password "newpassword"
mysqladmin -u root -p shutdown
skip-grant-tables


/**********************查看当前mysqld启动时的加载文件************************/
show variables like '%dir%';
vi /etc/rc.d/init.d/mysql
ps ax | grep '[m]ysqld'
/**********************登陆************************/
mysql -uroot -psuper1199110
/**********************防止中文乱码************************/
1、查看数据库字符编码设置
show variables like"%char%";
2、设置字符
set character_set_client='utf8';
……
3、创建数据库的时候：
CREATE DATABASE daopangshu 
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
4、建表的时候 CREATE TABLE 'person' (
'person_id' int auto_increment,
……
primary key(id)
……
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
//InnoDB支持事物
/**********************数据库************************/


CREATE DATABASE daopangshu DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


/**********************建表************************/
//个人信息表
create table person(
person_id int auto_increment,
person_type varchar(8),
name varchar(50),
sex char(2),
age int,
height varchar(5),
education varchar(10),
marry char(4),
place  varchar(20),
constellation varchar(20),
language varchar(20),
email_validate char(6),
phone_validate char(6),
member varchar(20),
rank_id int,
img_id int,
accompany_id int,
last_time   varchar(10),
phone   varchar(12),
email  varchar(50),
wechat  varchar(50),
qq      varchar(50),
contact_time varchar(50),
primary key(person_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
//排行榜
create table rank(
rank_id int auto_increment,
view_times  int,
primary key(rank_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;;
//图片信息
create table img(
img_id int auto_increment,
img_logo_path varchar(100),
img_detail  varchar(100),
album_id_ int,
primary key(img_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;;
//相册
create table album(
album_id int auto_increment,
album_path varchar(100),
primary key(album_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;;
//伴游
create table accompany(
accompany_id int auto_increment,
accompany_place varchar(50),
accompany_free varchar(15),
accompany_exprience varchar(200),
accompany_content varchar(500),
accompany_moon   varchar(500),
primary key(accompany_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;