On Sun, Feb 22, 2015 at 11:37 AM, Paul <[email protected]> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
