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.
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'@'127.0.0.1' IDENTIFIED BY 'root'; GRANT ALL ON *.* TO 'root'@'127.0.0.1';"
mysql -e "SHOW VARIABLES WHERE Variable_name = 'port';"
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.