Deepin 20 Beta安装mysql并导入sql文件

1. 安装deepin linux 20 beta，建立用户myuser，密码
2. 更新apt

   sudo apt update
   sudo apt list –upgradable
   sudo apt upgrade

    

3. 去网站下载 mysql-apt-config_0.8.15-1_all.deb放在Downloads下
4. 进入文件夹

   cd Downloads

    

5. 安装repo

   sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb

    

6. 安装界面设置选debian buster，然后确认
7. 安装界面前两个选项默认直接选Ok，然后确认
8. 更新apt

   sudo apt-get update

    

9. 安装mysql（联网）

   sudo apt-get install mysql-server mysql-client

    

10. 输入密码并确认密码
11. 安装界面选择Use Strong Password Encryption
12. 登入mysql，登入后进入mysql>模式

    sudo mysql -uroot -p
    输入密码

     

13. 创建用户

    create user ABBAdmin IDENTIFIED BY '@BcAdmin123';

     

14. 赋权限并刷新后退出

    grant all privileges on *.* to myuser@'%';
    flush privileges;
    exit

     

15. 重新登入

    sudo mysql -rmyuser -p
    输入密码 

     

16. 拷贝my.sql到Douments文件夹，之后在mysql导入sql文件

    source  /home/myuser/Documents/my.sql;

     

 my.sql内容

DROP DATABASE IF EXISTS Curve;
CREATE DATABASE Curve;
USE Curve;
DELIMITER ;;
CREATE PROCEDURE Init(IN x INT,IN y INT,IN z INT)
BEGIN
	DECLARE i INT DEFAULT 0;
	DECLARE j INT DEFAULT 0;
	DECLARE k INT DEFAULT 0;
	WHILE i<x DO
		SET j = 0;
		WHILE j<y DO
			SET @temp_sql = CONCAT('CREATE TABLE Curve_',i,'_',j,' (ID INT,VALUE FLOAT,TIMESTAMP TIMESTAMP(3),IsData INT(1));');
			PREPARE stmt from @temp_sql;
			EXECUTE stmt;
			DEALLOCATE PREPARE stmt;
			SET k = 0;
			WHILE k<z DO			
				SET @temp_sql = CONCAT('INSERT INTO Curve_',i,'_',j,' VALUES (',k,',',0,',current_timestamp(3),0)');
				PREPARE stmt from @temp_sql;
				EXECUTE stmt;
				DEALLOCATE PREPARE stmt;
				SET k = k + 1;
			END WHILE;			
			SET j = j + 1;
		END WHILE;
		SET i = i + 1;
	END WHILE;
END;;
DELIMITER ;
SELECT CONCAT('Start',current_timestamp(3));
CALL Init(4,6,288);
SELECT CONCAT('Finish',current_timestamp(3));