数据库相关🔥
Jack Zheng 2023/9/26 mysql数据库
MySql 容器部署允许远程登录
use mysql;
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
mysql -h 0.0.0.0 -uroot -P3308 -p123456
mysql -h xx.xx.xx.xx -uroot -P3308 -p123456
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
MySql 备份还原数据库
mysqldump -hxx.xx.xx.xx -uroot -p123456 -P3309 数据库 > 数据库.sql
create database 数据库 default character set utf8 COLLATE utf8_general_ci;
use 数据库;
source /home/admin/数据库.sql;
1
2
3
4
5
6
7
2
3
4
5
6
7
MySql 服务启动
cd /usr/local/usr_software/mysql_5.7.18/bin
mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
service mysqld restart
1
2
3
4
5
2
3
4
5
PyOdbc 连接数据库，安装驱动(ubuntu20.04)
wget https://packages.microsoft.com/config/ubuntu/20.04/prod.list
mv prod.list /etc/apt/sources.list.d/mssql.list
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
apt-get update
apt-get update && ACCEPT_EULA=Y apt-get install -y mssql-tools
apt-get install msodbcsql17
1
2
3
4
5
6
2
3
4
5
6
