From your web app
To access from your web app, make sure your app is set up to connect to the database type you installed and that you are using the correct database connections in your .env file.
From your device
Using terminal / command line
ssh cleaver@<server ip address>
The cleaver user is added to the server during provisioning. Please keep in mind, the cleaver user does not have full root level access for security reasons. This also includes not giving cleaver user direct access to databases.
If you are running MySQL or MariaDB databases, use the following command to start a mysql session using the username and password you setup your database with.
mysql -u <username> -p
Using provider's console
Another way to access the server is to use the console option that many cloud providers offer when you log into your VPS provider’s website. Once logged into the console, you can use the mysql command from the previous method to access your database.
Using a database client
Lastly, you can use a database client to access your database. We recommend TablePlus as it is compatible with all database types and versions Cleaver offers.
- Host: 127.0.0.1
- User: db username
- Password: db password
- Server: server ip address
- User: cleaver
- Use SSH key and point to public key on your machine - make sure you add your public key to Cleaver first
Important! When installing databases, Cleaver locks down root access to external client tools. This is for security. To access using a client tool, make sure you have added a database user and password and use those credentials for external clients. Also, during provisioning, Cleaver creates a 'cleaver' user on the server which is not granted database access. This is also for security reasons.