Sunday, February 22, 2015

Re: dbext without a password


On Sun, Feb 22, 2015 at 11:37 AM, Paul <google1241@rainslide.net> wrote:
How can I use dbext.vim without a MySQL password? I've tried using

let g:dbext_default_profile_mySQL = 'type=MYSQL:user=root:dbname=test'

and

let g:dbext_default_profile_mySQL = 'type=MYSQL:user=root:passwd=:dbname=test'

and

DBSetOption passwd=''

and clearing @afkb at the prompt when using \sbp. It always gives

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I could set 'user' and no 'password' in ~/.my.cnf, but that's not manageable.


When using type=MYSQL, dbext shells out and runs the mysql binary, which you typically see when there is an error:

Last command(rc=1):
mysql.exe  -u root -D mysql -t < D:\WINDOW~1\dbext.sql


Outside of dbext, can you concoct a mysql command line that does what you want without using a password.  That usually helps when coming up with the connection profile that will result in the same command line.

You can also see the dbext command line by running:
:DBSetOption display_cmd_line=1

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

No comments:

Post a Comment