Linux下的MySQL操作

 

上传MySQL到root

 

  安装MySQL必备内容

systemctl stop firewalld
yum install net-tools -y
yum install perl* -y

 

内容多，下载久 

 

移除不必要的内容 

yum remove mysql-libs -y

 

 安装MySQL

rpm -ivh MySQL-server-5.1.73-1.glibc23.x86_64
rpm -ivh MySQL-client-5.1.73-1.glibc23.x86_64

 

 

启动MySQL 

systemctl restart mysql

 登录MySQL

mysql -u root

 

 

 MySQL修改密码 

update mysql.user set password=PASSWORD('12345678') where User='root';
flush privileges;

 

  修改密码方法二

set password = password('12345678');
flush privileges;
 

 分配权限

grant all privileges on *.* to 'root'@'master' identified by '12345678';

 刷新权限

flush privileges;

 

【exit】退出数据库 

重新登录MySQL

mysql -u root -p

 

 

创建数据库 

ctreate database project_db；

创建表 

CREATE TABLE users (
  id int(8) NOT NULL AUTO_INCREMENT,
  createDate datetime NOT NULL,
  userName varchar(32) NOT NULL,
  passWord varchar(36) NOT NULL,
  age int(3) NOT NULL,
  phone varchar(11) NOT NULL,
  introduce varchar(20) NOT NULL,
  PRIMARY KEY (id)
) DEFAULT CHARSET=utf8;

 

 导入数据

INSERT INTO `tb_admin` VALUES (1, 'admin', 'admin', '超级管理员', 0);
INSERT INTO `tb_admin` VALUES (2, 'koukou', '空空', '普通管理员', 1);
INSERT INTO `tb_admin` VALUES (3, 'guangguang', '逛逛', '普通管理员', 0);
INSERT INTO `tb_admin` VALUES (4, 'zhanghaojie', '豪杰', '普通管理员', 1);

 解压tomcat

tar -zxvf apache-tomcat-8.5.81.tar.gz

 

把项目放到/opt/soft/apache-tomcat-8.5.81/webapps下 

 

 修改端口号,即编写/opt/soft/apache-tomcat-8.5.81/conf下的server.xml，我们把准口号改成8989

 

 

关闭防火墙 

systemctl stop firewalld

 

 

到【/opt/soft/apache-tomcat-8.5.81/bin】目录下启动tomcat

./startup.sh

 把/opt/soft/apache-tomcat-8.5.81/webapps/javaDemo下的的所有东西剪切到/opt/soft/apache-tomcat-8.5.81/webapps/ROOT下