Could not locate mysql.

[chenggang108]

Hi, I am trying to use trackplot, but it show the error below. I have installed mysql either by homebrew or conda. Neither can be detected. Can you please help with it?

> track_plot(summary_list = track_data)
Missing gene model. Trying to query UCSC genome browser..
Error in .check_mysql() : Could not locate mysql.
Install:
 apt install mysql-server [Debian]
 yum install mysql-server [centOS]
 brew install mysql [macOS]
 conda install -c anaconda mysql [conda]
Called from: .check_mysql()

Thanks
Gang

[PoisonAlien]

Hi,
The error says it all. You need to install mysql().

[chenggang108]

Hi, Thank you for your reply. I did install MySQL by conda at local(I use Mac). How does Trackplot locate it? Should I give a path?ThanksSent from my iPhoneOn Sep 21, 2022, at 1:54 AM, Anand Mayakonda ***@***.***> wrote: Hi, The error says it all. You need to install mysql(). —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[PoisonAlien]

Hi,
If mysql is under the path then it should work without any issues.
Could you find it from the terminal - if you run which mysql or Whereis mysql?

[chenggang108]

I re-install it with Homebrew, as it is suggested by you if working on Macos.

If I run which mysql, it shows:
/Users/chengg2/homebrew/bin/mysql

If I run Whereis mysql, it shows:
mysql: /Users/chengg2/homebrew/bin/mysql /Users/chengg2/homebrew/share/man/man1/mysql.1

I wonder if it is because I am not a the root user.