Mysql access from lp file

[admin]

You can use MySQL functions in .lp, but it might cause problems if the db server is not available as .lp should not contain any blocking code. Alternatively if you don't need data in real time you can fetch data from MySQL via a script, save data into storage and display it via .lp.
There's no completely secure way to hide the credentials. You should limit db user privileges to only functions/tables that are needed.