Type ‘\c’ to clear the current input statement. $ mysql -u root -p -h localhost -P 3307 -default-auth=mysql_native_passwordĬopyright © 2000, 2021, Oracle and/or its affiliates.
I have changed the port to 3307 and I still see mysql database in mysql client. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Commands end with or \g.Ĭopyright (c) 2000, 2021, Oracle and/or its affiliates. Mysql -default-auth=mysql_native_password -h 127.0.0.1 -u root -p -P 3306 How do I connect to MemSQL database through SQL client? Is there any other way to run bash script on MemSQL database? I installed MySQL client but when I do try to connect to memsql database, it is connecting to MySQL database by default.
Now to run the bash script, I will use my MAC terminal and mySQL client. To do this - I have installed MemSQL through docker desktop on my MAC and to create database and tables I used Single Store Studio. My goal is to develop automation using bash on MemSQL database.
0 kommentar(er)
