dbext without a password

[Paul]

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.

[David Fishburn]

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

[Paul]

On Sunday, 22 February, 2015 at 17:42:55 GMT, David Fishburn wrote:
>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

With that DBSetOption, I can see that the command dbext is using is:

mysql -u root -D test -t < /tmp/vplBhqM/dbext.sql

I have previously defined some other mysql user and password in ~/.my.cnf. With the above command line, mysql, since there is no password parameter given, [I'm assuming] takes the password from ~/.my.cnf, which is not necessarily the password of the root user. I think this is a failing of mysql rather than dbext. A command that does is:

mysql -u root --password='' -D test -t < /tmp/vplBhqM/dbext.sql

Note that -p doesn't accept a blank password (it'll prompt), but --password does.

[Paul]

On Wednesday, 25 February, 2015 at 17:02:39 GMT, Paul wrote:
>I have previously defined some other mysql user and password in ~/.my.cnf. With the above command line, mysql, since there is no password parameter given, [I'm assuming] takes the password from ~/.my.cnf, which is not necessarily the password of the root user. I think this is a failing of mysql rather than dbext. A command that does is:

That should be, "A command that does work is"!

[David Fishburn]

Okay, great, now you have a mysql command line which works as you want.

Were you able to create a dbext profile that will add that?

If you create the following profile in your .vimrc:

let g:dbext_default_profile_mysql_no_password = "type=MYSQL:user=root:passwd=:dbname=mysql:extra=--password='' "

Then for me this produced the following mysql command line:

mysql  -u root -D mysql --password=''  < D:\WINDOW~1\dbext.sql

This one indicated to used the -t (tabbed) output:

let g:dbext_default_profile_mysql_no_password_tabbed = "type=MYSQL:user=root:passwd=:dbname=mysql:extra=-t --password='' "

Thanks for getting back to the list.  I will update the dbext.txt with this example.

HTH,

David

 

[Paul]

On Wednesday, 25 February, 2015 at 19:53:49 GMT, David Fishburn wrote:
>let g:dbext_default_profile_mysql_no_password =
>"type=MYSQL:user=root:passwd=:dbname=mysql:extra=--password='' "

Yep, this works for me, too. Thank you.