pip install mycli
mycli -h <host> -u <username> -p <password> -P <port> <database>
SHOW DATABASES;
USE <database>;
SHOW TABLES;
SELECT * FROM <table>;
INSERT INTO <table> (<column1>, <column2>, ...) VALUES (<value1>, <value2>, ...);
UPDATE <table> SET <column1>=<value1>, <column2>=<value2> WHERE <condition>;
DELETE FROM <table> WHERE <condition>;
python
import subprocess
def execute_mycli_query(query):
command = f'mycli -h <host> -u <username> -p <password> -P <port> -e "{query}"'
output = subprocess.check_output(command, shell=True)
return output.decode('utf-8')
result = execute_mycli_query('SELECT * FROM mytable')
print(result)
