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
|