Hi Diego, I don't have any specific information for you about using the -A flag with the OBDC Driver. The -A flag in MySQL is equivalent to --no-auto-rehash or -skip-auto-rehash. Perhaps one of the longer-form options would work for you? However, if you are not experiencing an excessively long startup time, there is no reason to use the flag at all. Here is the description of auto-rehash from the MySQL man page:
--auto-rehash Enable automatic rehashing. This option is on by default, which enables database, table, and column name completion. Use --disable-auto-rehash todisable rehashing. That causes mysql to start faster, but you must issue the rehash command if you want to use name completion. To complete a name, enter the first part and press Tab. If the name is unambiguous, mysql completes it. Otherwise, you can press Tab again to see the possible names that begin with what you have typed so far. Completion does not occur if there is no default database. --- I hope this helps. If you have further questions, please feel free to contact us again at [email protected]. -- Brooke Rhead UCSC Genome Bioinformatics Group Diego Pereira wrote on 2/23/12 7:02 PM: > Thank you for your answer Brooke > Yes, I'm connecting that way. > The -A flag seems to be the problem. > I tried using MySQL workbench and MSAccess using the OBDC driver and > any of them recognize the -A flag. > Strangely I had to restart my PC to get the error message. > The genomep without the -A flag works well, but as far as I understand > is slower. > May I ask you to indicate me how should I put the -A flag to be used > with the OBDC driver? > Or should I keep using the other type of connectivity when trying to > connect via OBDC? > Thanks, > Diego > > El día 23 de febrero de 2012 21:08, Brooke Rhead<[email protected]> > escribió: >> Hi Diego, >> >> There are no problems with our MySQL server that we are aware of. (One >> person contacted us earlier today about a connection problem, but it turned >> out to be a temporary problem on their network.) Can you give us an example >> of the errors you are seeing? Are you connecting with this command: >> >> mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A >> >> (from http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29)? >> >> -- >> Brooke Rhead >> UCSC Genome Bioinformatics Group >> >> >> >> On 2/23/12 5:55 PM, Diego Pereira wrote: >>> >>> Dear all, >>> I've been trying to connect today through MySQL to perform some simple >>> queries unsuccessfully. >>> May I ask you if you are having troubles with your server/connection >>> or other related issues that may explain my lack of connectivity? >>> Thanks >>> Diego >>> _______________________________________________ >>> Genome maillist - [email protected] >>> https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
