pyremotesql's Introduction

PyRemoteSQL

Python MySQL remote client

Basically this is a python SQL client that allows you to connect to your remote server with phpMyAdmin installed.Run SQL query commands remotely by running this script after connecting to remote server.

Requirements

Other python Dependancies

pymysql
time
socket
sys

Installation

clone this respiratory

git clone https://github.com/davdtheemonk/PyRemoteSQL.git

cd PyRemoteSQL

Usage

Python3 client.py

Input remote address ie. 127.0.0.1

Input remote port ie. 8080

Here are some issues still being fixed

Perfect Py module for SQL
Verifying if PHPMyAdmin is installed.
Version of Python thats compatible. I recommend Python 2.x>.

You are highly welcomed and appreciated to contribute to this project xx.

pyremotesql's People

Contributors

Stargazers

Watchers

pyremotesql's Issues

ask for server address

You should take into account that not all installations use an url path like the one in your script: phpMyAdmin

For example, my provider has installed it on https://my.server.domain/database/phpmyadmin
(see subpath database, plus lowercase letters phpmyadmin)

So I recommend you fix the script to ask server full address, instead of using server IP/port

simple example - upload backup.sql

This looks like an interesting project but it lacks some documentation. Not sure if I understood what it does:

Is it supposed to connect to a mysql server through its phpmyadmin web interface? (if YES, that would be great)
Or is this simply for connecting to a mysql server in the usual direct way (NOT using a phpadmin web interface).
If above answer is YES, could you provide a couple of usage examples?