Mariadb操作
--查询所有用户
SELECT User, Host, Password FROM mysql.user;
--修改host后,如果之前已授权,此时需要重新授权
update mysql.user set host='%' where host like 'localhost';
update mysql.user set host='%' where user='br2zz';
flush privileges;
--查看权限
SHOW GRANTS FOR br2zz;
--授权
GRANT ALL PRIVILEGES ON mysql_test.* TO 'br2zz'@'%'
grant select,lock tables,insert,update,delete,create,drop,index,alter on mysql_test.* to br2zz;
grant all privileges on springboot.* to br2zz;
在CentOS 中安装:
--centos 开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
--重启后,开启防火墙,可以访问
systemctl start firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service
-- #查看监听(Listen)的端口
netstat -lntp
--#查看所有建立的TCP连接
netstat -antp
--创建数据库,并设置中文字符集
create database if not exists springboot_0 default character set 'utf8' collate 'utf8_unicode_ci';
CREATE TABLE `student` (
`id` int(11) NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--建表,并设置中文字符集
CREATE TABLE hello (
id int(11) NOT NULL AUTO_INCREMENT,
msg varchar(255) DEFAULT NULL,
date datetime DEFAULT NULL,
FRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;