-------------------- mysql --------------------
show global variables like 'port';
use database_name;
show databases;
show tables;
mysql -u root -p
set password for root@localhost = password('123');
创建数据库
1、 CREATE DATABASE 数据库名;
2、 GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON 数据库名.* TO 数据库名@localhost IDENTIFIED BY '密码';
3、 SET PASSWORD FOR '数据库名'@'localhost' = OLD_PASSWORD('密码');
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON ABC.* TO ABC@localhost IDENTIFIED BY 'admin';
CREATE TABLE 表名 (字段名 VARCHAR(20), 字段名 CHAR(1));
====
CREATE TABLE company(id int(10) NOT NULL,name varchar(20) NOT NULL,age int(10) NOT NULL,address varchar(50),salary float(15.2),PRIMARY KEY (id));
-------------------- mysql --------------------