systemctl start tomcat
systemctl restart tomcat
systemctl stop tomcat
mysql -uroot -p
mysql -h ip详细信息 -uroot -p
exit
mysql -u用户名 -p旧密码 password 新密码
SET PASSWORD FOR root=PASSWORD(“root”);
grant select on 数据库.* to 用户名@登录主机 identified by “密码”
show databases;
use mysql;
show tables;
describe 表名;
create database 库名 character set utf-8;
use 库名;
create table 表名(字段设定列表);
drop database 库名;
drop table 表名;
delete from 表名;
select * from 表名;
alter database db_name default character set gbk;
如果要改变整个mysql的编码格式:
启动mysql的时候,mysqld_safe命令行加入
--default-character-set=gbk