17 lines
393 B
Plaintext
17 lines
393 B
Plaintext
linux数据库操作
|
||
mysql -uroot -p
|
||
数据库密码：123456
|
||
创建数据表
|
||
数据库名：food_db
|
||
CREATE DATABASE `food_db` DEFAULT CHARACTER SET = `utf8mb4`;
|
||
查看表
|
||
show databases;
|
||
进入数据表
|
||
use food_db;
|
||
show tables;
|
||
select * from user ;
|
||
show create table user;
|
||
|
||
|
||
1. 开启mysql service mysqld start
|
||
2. 查看mysql是否开启 ps -ef |grep mysql |