error connecting to mysql

[kiwanami]

error connecting to mysql

[kiwanami]

The error message says 'could not establish the connection'.
If the DB hostname is indicated by localhost at URI, the perl DBI uses the domain socket to connect.
In some environments, it fails because of inconsistency of the domain socket path between the server and drivers.
Will you try following URI?

DBI:mysql:(database name):127.0.0.1

[vinhdizzo]

Thanks. I think I was able to login. However, my dbviewer buffer shows "No tables." There should be many tables.

Am I doing something wrong? Thanks.

[kiwanami]

It seems #16 may affect the problem. Now the bug was fixed.
Will you try update edbi.el and ctable.el?
I'm sorry for trouble you.

[vinhdizzo]

great. works now.

I must say that dbi:mysql:dbname:server is a little odd. I think dbi:mysql:server:dbname is more intuitive (largest to smallest).

will continue to test out. looks solid based on what I've seen so far. I feel I finally have a universal sql client in emacs now. No need to use multiple clients and get confused changing from one to another.

[kiwanami]

Thank you for your confirmation! I'm glad to know that you like edbi.

The data source name comes from perl's DBI module.
You can use any syntax according to the document:
http://search.cpan.org/~timb/DBI/DBI.pm#connect
(Yes. I think the syntax is not familiar too...)