[web2py] Re: Can't connect to MySQL

This code fails: uri = configuration.get('db.uri') print uri db = DAL(uri) The uri printed is: 'mysql://rota:rota@localhost/rota?set_encoding=utf8mb4' This code works: db = DAL('mysql://rota:rota@localhost/rota?set_encoding=utf8mb4') That's exactly the same URI (it was copy and pasted in Vim)

[web2py] Re: Can't connect to MySQL

> > MySQL is listening on the default port: > $ telnet localhost 3306 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. c 5.5.5-10.3.17-MariaDB-0+deb10u1�a3y(W]OS��-��5KZaY|$920;vmysql_native_password^CConnection closed by foreign host. -- Resources: - htt

[web2py] Re: Can't connect to MySQL

According to the book the connection string for MySql is: mysql://username:password@localhost/test?set_encoding=utf8mb4 Maybe adding the TCP port solves the issue: mysql://username:password@localhost:13306/test?set_encoding=utf8mb4 Kind regards, Annet -- Resources: - http://web2py.com - htt

[web2py] Re: Can't connect to MySQL server on 'localhost'

We are facing same problem. What's the solution for this? On Tuesday, March 15, 2011 8:38:19 PM UTC+5:30, Miguel wrote: > > Hello to all, I have created a new project using the web wizard, for > some unknown reason the mysql connection is not working, this is the > uri im using: > > mysql://cmt

[web2py] Re: Can't connect to MySQL server on 'localhost'

Hey, I am also getting the same error. I am not able to telnet to localhost 3306. I've checked my.cnf and there is a line "bind-address:127.0.0.1". I tried commenting it out, but error still persisted. Can you help me here? On Wednesday, March 16, 2011 1:51:31 AM UTC+5:30, Kevin Ivarsen wrote:

[web2py] Re: Can't connect to MySQL server on 'localhost'

Hi Miguel, I had a similar problem on ubuntu linux recently and the solution was to enter the port number (which is usually 3306) in connect string. Try: mysql://username:password@localhost:port/test Cheers Tamas On Mar 16, 2:08 am, Miguel wrote: > Hello to all, I have created a new project u

[web2py] Re: Can't connect to MySQL server on 'localhost'

Miguel, MySQL can communicate over either TCP or a named pipe. It's possible that your MySQL server is only listening on the named pipe. I could imagine that the mysql command line client would connect successfully over this channel, but Python would try to connect to the TCP socket and fail. Try