How to use query param like vim-dadbod in this plugins?

[sheenazien8]

I found error Error connecting to db Homestead: DB exec error: mysql: [Warning] Using a pass word on the command line interface can be insecure.^@ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.10' (111)

[kristijanhusak]

Is your vim-dadbod working fine?

Try this:

:DB your_db_url_here select * from some_table

[sheenazien8]

working fine when i use this. :DB mysql:--login-path=homestead use lakasir; select * from users; but when i use DB mysql://homestead:secret@192.168.10.10:3360/lakasir select * from users; i found errors

[kristijanhusak]

try doing localhost instead of the ip.

[sheenazien8]

in this case i want connect mysql in my vagrant / VM

[kristijanhusak]

Try connecting without the password:

DB mysql://homestead@192.168.10.10:3360/lakasir select * from users;

It should prompt you to enter the password.

[sheenazien8]

i found this errors

[kristijanhusak]

Your vagrant ip seems wrong.

[sheenazien8]

in Vim-dadbod i can connect with query params, but when i wanna use vim-dadbod-ui i can't connect with query parmas

[sheenazien8]

Your vagrant ip seems wrong.

No. because i can connect with this command DB mysql:--login-path=homestead use lakasir; select * from users;

[kristijanhusak]

Try defining your connection url like that and see if it works: mysql:--login-path=homestead use lakasir;

[sheenazien8]

when i add new connection, and access the new connection, i got this errors

and i try check in this file ~/.local/share/db_ui/connections.json my new connection is created like this

    {
        "url": "mysql:///--login-path%3Dhomestead",
        "name": "Homestead"
    }

[kristijanhusak]

I'll open upstream issue. I'm using dadbod's function that converts it to this.

[kristijanhusak]

Does your query work when you do this?

DB mysql:///--login-path%3Dhomestead select * from users

[sheenazien8]

error, but it tries to connect to localhost instead of vagrant, ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[kristijanhusak]

Does same thing happens with this?

DB mysql:///--login-path%3Dhomestead use lakasir;select * from users

[sheenazien8]

it works!

[sheenazien8]

but why when i use DBUI it didnt works

[kristijanhusak]

I'm not sure if it will work, but try adding your connection with the use lakasir part:

mysql:///--login-path%3Dhomestead use lakasir;

It would be best to just figure out the proper connection url. Can you also try adding this as connection?

mysql://homestead@192.168.10.10:3360/lakasir?login-path=homestead

[sheenazien8]

mysql:///--login-path%3Dhomestead use lakasir; error acces denied

mysql://homestead@192.168.10.10:3360/lakasir?login-path=homestead error can't connect to MySQL server 192.168.10.10

[kristijanhusak]

From what I see in the docs here Your url should be something like this (if you didn't change any defaults):

mysql://homestead:secret@127.0.0.1:33060/lakasir

[sheenazien8]

i got still same error

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2007 (HY000): Protocol mismatch; server version = 11, client version = 10

[kristijanhusak]

I suggest figuring out the ip of the vagrant machine and apply that to the example from my previous comment. You can figure out the ip with this (haven't tried): https://stackoverflow.com/a/41251906/1474465

Than just use the ip in here:

mysql://homestead:secret@IP_HERE:33060/lakasir

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.