随笔分类 - mysql
摘要:```python # 长度 https://blog.csdn.net/z_purple/article/details/84992245 # https://www.cnblogs.com/gulibao/p/5416245.html ```
阅读全文
摘要:https://blog.csdn.net/qq_42365534/article/details/102847013?depth_1 utm_source=distribute.pc_relevant.none task blog BlogCommendFromBaidu 1&utm_source
阅读全文
摘要:```
参考:https://blog.csdn.net/zc474235918/article/details/72731363/
https://blog.csdn.net/zmx729618/article/details/51259135 # import pymysql
# conn=pymysql.connect(host='127.0.0.1',user='root',passw...
阅读全文
摘要:```
参考:https://www.cnblogs.com/activiti/p/7810166.html
# alter user 'root'@'localhost' identified by '123456'
# 或者
update user set authentication_string = password('root'), password_expired = 'N', pas...
阅读全文
摘要:```
安装mysql: sudo apt-get install mysql-server mysql-client 然后mysql -V查看mysql是否安装成功 sudo apt-get install libmysqlclient-dev python3-dev 然后 pip install mysqlclient就不会报错找不到'mysql_c...
阅读全文
摘要:参考:https://www.cnblogs.com/M LittleBird/p/5902850.html 使用python的pip install redis以后还需要下载安装redis安装文件才能正常开启redis服务: github下载redis的zip包:https://github.co
阅读全文
摘要:创建用户后登陆失败的原因是存在匿名用户: root@controller:~# mysql -h localhost -uaa -ppassword ERROR 1045 (28000): Access denied for user 'aa'@'localhost' (using password
阅读全文
摘要:pycharm远程登录mysqlmysql远程登录需要修改配置文件:cd /etc/mysql/mysql.conf.d/sudo vim mysqld.cn修改bing-address=0.0.0.0root不能远程登录,所以需要创建新用户然后授权select host,user from mys
阅读全文