Re: dbext: unable to connect to MySQL database

...
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.

You can run:

:DBSetOption display_cmd_line=1

:DBSetOption delete_temp_file=0

Then execute your statement to see the command line dbext is executing.

Then you can cut and paste that command line into a terminal / command prompt and see what happens when you execute the exact same command outside of Vim.

If you do get an error executing the command, fiddle the command until it works outside of Vim, then we can figure out how to tweak the profile in dbext.

David

 

--
--
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 vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.