Sign inSign up

mengmanzbh/mysql

By mengmanzbh

•Updated about 9 years ago

Image
0

2.3K

mengmanzbh/mysql repository overview

docker run -e MYSQL_ROOT_PASSWORD=RvfJsG7BwWdhHZSN -d -p:3306:3306 mariadb

不要用默认的root密码

docker exec -it a39737482cef bash

mysql -uroot -proot

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';

/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/lib/ext

创建数据库 CREATE DATABASE laravel5;

https://blog.csdn.net/linuxheik/article/details/62884420⁠

drop database if exists school;

create database school;

use school;

create table teacher( id int(3) auto_increment not null primary key, name char(10) not null, address varchar(50), year date );

insert into teacher values('001','zhangyuqi','shanghai','1976-10-10');

insert into teacher values('002','wangliken','shanghai','1976-10-10');

insert into teacher values('003','zhangtianai','shanghai','1976-10-10');

/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/lib/ext

https://jdk.java.net/18/⁠

Tag summary

Content type

Image

Digest

Size

100 MB

Last updated

about 9 years ago

docker pull mengmanzbh/mysql