You can use this dialog box to add or remove the other admin-level users, or change their passwords. This dialog box allows you to set a password for the "root" user, or create additional admin-level users who can log in to the system from a remote machine, unlike the "root" and "postgres" user. ![]() You can't use these accounts to login from a remote machine.) (Note that you can only login in as "root" or "postgres" locally on the database server machine. And leave the password blank as this is the default setup for these special admin-level users. ![]() Then for MySQL, use "root" as the User Name. Use the Database Type popup menu, below, to select MySQL or PostgreSQL.Įnter "localhost" for the Database URL. If you've used our installers to set up the MySQL/MariaDB or PostgreSQL database (or used a standard installation of either database), this is how you'll login to the respective databases when you start up Liya running locally on the database server machine. Once installed, new versions of these installers will upgrade the previous version, including bringing over existing databases, automatically. Just click on their respective links, on the right bar, to download. To get you started quickly, we have one-click installers for MySQL and PostgreSQL databases on Catalina and Big Sur. Or you can use Liya to create a standalone SQLite database. Make sure you have access to MySQL or PostgreSQL databases. You can export data from one database for backups that can be read by any of the other databases. If you need to copy the table structure of one table to another, even across database systems, simply drag and drop across windows. Liya can access databases in all three systems simultaneously, using multiple windows, with each window showing the contents of a single database.Īnd Liya will move data from one database to another, just by dragging and droppiing. Liya can access MySQL, PostgreSQL & SQLite3 databases, all in the same way, using a simple 3-panel display - one panel for selecting the database and the table, another for editing the table structure, and the last for editing the contents of the table. ![]() Liya allows a user to access three Database Systems simultaneously from a single visual interface.
0 Comments
Leave a Reply. |