I'm trying to connect to a new db:
db=DAL('mysql://userx:password@localhost/IgXortho?set_encoding=utf8mb4')
I can login with my user, when I check grants I've got this:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><
mysql> show grants;
+---------------------------------------------------------------+
| Grants for userx@localhost |
+---------------------------------------------------------------+
| GRANT USAGE ON *.* TO `userx`@`localhost` |
| GRANT ALL PRIVILEGES ON `IgXortho`.* TO `userx`@`localhost` |
| GRANT ALL PRIVILEGES ON `ig_xortho`.* TO `userx`@`localhost` I
I've tried with common user and with root user but always same problem
(you can see 2 db because I've changed name removing underscore from the
name):
OperationalError: (1045, u"Access denied for user 'userx'@'localhost'
(using password: NO)")
Web2py latest version, python 2.7.18 and MySQL is:
mysql Ver 8.0.29 for Linux on x86_64 (MySQL Community Server - GPL)
I can't figure out why, it seems like the password doesn't go to the server
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/www/web2py/gluon/packages/dal/pydal/base.py", line 679, in
define_table
table = self.lazy_define_table(tablename, *fields, **kwargs)
File "/www/web2py/gluon/packages/dal/pydal/base.py", line 720, in
lazy_define_table
polymodel=polymodel,
File "/www/web2py/gluon/packages/dal/pydal/adapters/base.py", line 943,
in create_table
return self.migrator.create_table(*args, **kwargs)
File "/www/web2py/gluon/packages/dal/pydal/migrator.py", line 337, in
create_table
self.adapter.create_sequence_and_triggers(query, table)
File "/www/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1027,
in create_sequence_and_triggers
self.execute(query)
File "/www/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line
65, in wrap
if not args[0].connection:
File "/www/web2py/gluon/packages/dal/pydal/connection.py", line 32, in
connection
return self.get_connection()
File "/www/web2py/gluon/packages/dal/pydal/connection.py", line 65, in
get_connection
connection = self.connector()
File "/www/web2py/gluon/packages/dal/pydal/adapters/mysql.py", line 64,
in connector
conn = self.driver.connect(**self.driver_args)
File "gluon/contrib/pymysql/__init__.py", line 90, in Connect
return Connection(*args, **kwargs)
File "gluon/contrib/pymysql/connections.py", line 688, in __init__
self.connect()
File "gluon/contrib/pymysql/connections.py", line 906, in connect
self._request_authentication()
File "gluon/contrib/pymysql/connections.py", line 1114, in
_request_authentication
auth_packet = self._read_packet()
File "gluon/contrib/pymysql/connections.py", line 981, in _read_packet
packet.check_error()
File "gluon/contrib/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "gluon/contrib/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
gluon.contrib.pymysql.err.OperationalError: (1045, u"Access denied for user
'userx'@'localhost' (using password: NO)")
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/c674d8eb-4aae-4978-a316-7f96b5d7bb5cn%40googlegroups.com.
