Querious x Local

Hi I cam accross a post recently regarding large databases

In it there was one specific comment about dealing with issues with SQL queries with an app called Querious

I was wondering if anybody in the community had used it with Local and if so, how were you able to connect it with a Local database.

System Details

  • Local Version:
    Version 9.0.2+6676

  • Operating System (OS) and OS version:
    MacOS 14.5

Yeah, I have been using Querious for many years. You could either use Socket or TCP/IP to connect. There are a few more steps involved with TCP/IP. You have to create a user and grant access and find the port number for the site. The easiest way is just to use the Socket path for the site and the correct database credentials. Please see the screenshots below.

Using TCP/IP to connect to Local MySQL databases:

mysql -e "CREATE USER 'root'@'' IDENTIFIED BY 'root'; GRANT ALL ON *.* TO 'root'@'';"
mysql -e "SHOW VARIABLES WHERE Variable_name = 'port';"