On Wednesday, May 2, 2018 at 12:06:43 PM UTC-7, David Fishburn wrote: > Thanks very much for responding. Yep, all on the same machine, and I see the > exact same behavior regardless of whether I am attempting to query my > localhost or a remote server. > > > > No problems outside of Vim: queries work fine via CLI or a client such as > MySQL Workbench. > > > > > > > > > > > > Can you supply a mysql command line call that correctly connects to the > > database. > > > > You did not provide this information, just omit the password. > > > David
Hi David, Sure. Here are a couple of different CLI approaches, both on localhost. Both of these return the expected result. mysql -h localhost -u myusername -p select * from lter10_arthropods_production.sites; mysql -h localhost -u myusername -p -D lter10_arthropods_production select * from sites; I have a similar config in my vimrc for for the MySQL localhost, here trying naming the database explicitly and not doing so. Also tried with and without passing a password. let g:dbext_default_profile_mysql_local = 'type=MYSQL:host=localhost:port=3306:user=myusername' let g:dbext_default_profile_mysql_local_arthropods = 'type=MYSQL:host=localhost:port=3306:user=myusername:dbname=lter10_arthropods_production' With either connection setting, running the above query with or without identifying the database name, I get the same result: man page details of MySQL, connection settings, and the query. I have attached a truncated version. Thanks for your help. -- -- You received this message from the "vim_use" maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php --- You received this message because you are subscribed to the Google Groups "vim_use" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
dbext.output
Description: Binary data
