常用SQL命令

access_log apps websites RUNOOB
中文显示乱码在cmd中输入 CHCP 65001
重设密码的方法：
mysql -u root -p123 #登录mysql 服务器
use mysql #使用mysql数据库
update user set password=PASSWORD("123456") where User='root' #更新用户密码
flush privileges #重新刷新权限
quit #退出mysql服务器
create database RUNOOB; # 创建数据库
use RUNOOB; # 使用已创建的数据库
set names utf8; # 设置编码
source C:\Users\yuxinglx\Downloads\websites.sql # 导入备份数据库

SHOW DATABASES;
use RUNOOB;
SHOW TABLES;
DROP DATABASE apps;
DROP TABLE websites;
DELETE * FROM websites;
SELECT * FROM apps;
show create table websites;
show full columns from websites;
alter table websites modify name varchar(20) character set utf8;
alter table websites default character set utf8;
alter table websites change score score varchar(50) character utf8;

Windows
1.点击“开始”->“运行”(快捷键Win+R)。
2.启动：输入 net start mysql
3.停止：输入 net stop mysql
提示* Redhat Linux 也支持service command，启动：# service mysqld start 停止：# service mysqld stop 重启：# service mysqld restart

转载于:https://www.cnblogs.com/anita-harbour/p/9479962.html