安装
1
2
3
4
5
6
7
8
9
10
11
12
13
|
sudo apt-get install mysql-server
service mysql start
cat /etc/mysql/debian.cnf | grep user | head -n 1
cat /etc/mysql/debian.cnf | grep password | head -n 1
mysql -udebian-sys-maint -p
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
alter user 'root'@'localhost' identified by '新密码';
CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
create user 'pyuno'@'localhost' identified by '新密码';
GRANT ALL PRIVILEGES ON pyuno.* to "pyuno"@"localhost" IDENTIFIED BY "新密码";
FLUSH PRIVILEGES;
quit
service mysql restart
|
mysqlclient插件安装
Django1.11时需要安装以下两个，这次升级到Django3.1后，只需要安装mysqlcliet
1
2
| pip install PyMySQL
pip install mysqlclient
|
注：mysqlclient的某些版本会安装时报错，Django1.11时对应可安装可使用的mysqlclient==1.4.2.post1，Django3.1对应可安装可使用的版本mysqlclient>=2.0
Django 1.11时需要修改项目目录下的__init__.py文件，Django3.1不需要
1
2
3
4
5
| import pymysql
pymysql.install_as_MySQLdb()
SITE_DIR = os.path.join(BASE_DIR,"sites")
sys.path.append(SITE_DIR)
|
1
2
3
4
|
sudo apt-get install python3-dev default-libmysqlclient-dev build-essential
pip install mysqlclient
pip install PyMySQL
|
📚 返回目录
评论