LNMP之-复习数据库

首先是安装mysql服务

Yum安装Mysql服务端

yum -y install mysql-server

启动Mysql服务

service mysqld start

设置初始密码

mysqladmin -u root password 123456

连接Mysql

mysql -uroot -p123456

添加远程访问权限

use mysql;
GRANT ALL PRIVILEGES ON . TO root@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
exit;
service mysqld restart
之后用navicat测试一下连接就行了,记得在linux里设置防火墙规则,开放3306端口.

然后是创建数据库

CREATE DATABASE [数据库名];

DROP DATABASE [数据库名]; //删除

USE [数据库名];

然后是创建表

CREATE TABLE [表名] (

[字段名] [数据类型] [UNSIGNED] [NOT NULL] [AUTO_INCREMENT],

[字段名] [数据类型] [NOT NULL] [DEFAULT ‘默认值’] [COMMENT ‘字段注释’ ],

PRIMARY KEY ( [主键字段名] )

)
ENGINE=InnoDB
[DEFAULT CHARACTER SET=编码格式]
[COMMENT=’表注释’];