Ubuntu18.04系统 连接报错 求大神
Topic sourcehttps://blog.csdn.net/u011495642/article/details/84206790解决了。。
第二个坑mysql.connector.errors.ProgrammingError: 1049 (42000): Unknown database 'test'
解决方案MySQL-connector可以帮助我们创建table,但是不能帮助我们创建database。首先需要去安装:打开命令提示符——输入:mysql -u root -p,回车,然后输入密码进入mysql,然后输入CREATE DATABASE test;
- 1
天小六
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/connection.py", line 95, in __init__
self.connect(**kwargs)
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/abstracts.py", line 716, in connect
self._open_connection()
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/connection.py", line 210, in _open_connection
self._ssl)
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/connection.py", line 144, in _do_auth
self._auth_switch_request(username, password)
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/connection.py", line 177, in _auth_switch_request
raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1698 (28000): Access denied for user 'root'@'localhost'