If you are using the Guacamole server to access pandora, the default keyboard layout may be a US keyboard. To change this to a UK keyboard, type the command:
setxkbmap uk
You will have to do this in each terminal you open. Alternatively, you can edit the file, .cshrc in your home directory and add that command to the end of the file.
This information is no longer needed as the version of python3 installed on pandora is now configured to support PyMySQL.
It is retained only so you can install PyMySQL on your own computer, or in case of problems.
If you are using the standard system install of Python3 on pandora, then you should have no issues using the PEP249 libraries - either PyMySQL or mysql-connector. Both are installed centrally.
If you wish to install PyMySQL locally on your own computer, simply give the command:
pip3 install --user PyMySQL
Both of these libraries are PEP249 compatible so all the calls to library routines are the same. The only difference is in how you load the module and how you connect to the database:
import pymysql.cursors db = pymysql.connect(host=dbhost, port=port, user=dbuser, passwd=dbpass, db=dbname)
import mysql.connector db = mysql.connector.connect(host=dbhost, port=port, user=dbuser, passwd=dbpass, db=dbname)