2022-03-21 0 11 web前端社区
sudo apt-get update
sudo apt-get install mysql-server
sudo mysql_secure_installation
systemctl status mysql.service
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Sdtlite12345'; #使用mysql_native_password修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Sdtlite12345' PASSWORD EXPIRE NEVER; #更新一下用户的密码
UPDATE user SET host = '%' WHERE user = 'root'; #允许远程访问
SHOW VARIABLES LIKE 'validate_password%';
启动mysql:
set global validate_password.policy=0;
set global validate_password.length=1;
停止mysql:
方式一:sudo /etc/init.d/mysql stop
方式二:sudo service mysql stop
重启mysql:
方式一:sudo/etc/init.d/mysql restart
方式二:sudo service mysql restart
mysqldump -u dbuser -p dbname > dbname.sql
mysql -u root -p
mysql>use 数据库
然后使用source命令,后面参数为脚本文件(如这里用到的.sql)
mysql>source d:/dbname.sql
Copyright (C) 2021-2026 98社区 All Rights Reserved 蜀ICP备20012692号-3