Connecting to development database
Overview:
MySQL Databases:
For all the application using mysql database https://pma.openxcell.dev serves the PHPMyAdmin Frontend.
To access the PhpMyadmin you'll need an account for SSO Login on https://auth.openxcell.dev/auth/realms/Openxcell/account/
Once you open the PHPMyAdmin you'll have following ways to connect:
1. Default Server
2. Arbitrary Servers
1. Connecting to Default server:
By default the PHPMyadmin is configured to connect to openxcell-development.c5uwiw99as4r.eu-west-1.rds.amazonaws.com which is the common development RDS, and serves database for most of the application in development
It will appear selected in Server Choice Drop down by default, so if you are connecting to it, all you need is to enter the username and password you are provided for your application.
2. Conncting to Arbitrary Servers:
Other Database endpoints which have whitelisted IP of our development servers can be connected via https://pma.openxcell.dev
Other Database endpoints which have whitelisted IP of our development servers can be connected via https://pma.openxcell.dev
This can be done by entering the database endpoints in the Server Field of the login form and provide Username and Password for the same:
Postgres/MongoDB/Other Databases:
PHPMyAdmin is Limited to work with only MySQL database. To connect to other database types, i.e Postgres,Mongo, MSSQL etc., adminer provides a more universal GUI to work with. Only downside of using adminer is the UX which looks bit oldskool, despite of that it is powerful, for those who can harness.
The adminer ui is hosted at https://adminer.openxcell.dev and this also requires SSO as an additional security layer, to limit access to Openxcell Employees and Developers only.
To connect open the https://adminer.openxcell.dev/
- Select the Database System from System drop down.
- Enter Username, Password and Database Name (Optional)
- Hit Login
Note: Not all the endpoints are accessible from the development servers. e.g If the production database is specifically running in a private subnet then it can't be accessed from anywhere outside. In that case please connect with the team and understand the limitations of the endpoints you are trying to connect.
Related Articles
Difference between phpMyAdmin and MySQL
MySQL is a database server (which comes with a command line client for it) PHPMyAdmin is a (web application) client for MySQL. MySql is server where your commands get executed and returns you data, It manages all about data while PhpMyAdmin is a web ...Installing phpMyAdmin and MySQL via Docker In local
Prerequisite: 1. Basic Understanding of Docker and Container : If you haven't attend any Docker 101 webinars and seminars, ask your TL to arrange one. 2. Docker is installed : Ref : ...What & How : MySQL User
Run below commands to create MySQL user. 1. For local MySQL 1.CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 2.GRANT ALL ON *.* TO 'username'@'%'; 2. For AWS RDS 1. CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 2. GRANT SELECT, INSERT, ...view logs in grafana openxcell
Hello Here, I'll outline every step for viewing the API-Development server's logs. technology is used, such as Java, Node.js, and Next.js. Step 1 : Login GRAFANA : https://grafana.openxcell.dev/login Note : Login with openxcell SSO Step 2 : Go to ...How do I create another master user for my RDS DB instance running MySQL?
1. Begin by getting a list of the permissions currently available to the master user by running the SHOW GRANTS command: mysql> SHOW GRANTS FOR 'master_user'; The command provides output similar to the following (note: "master_user" is the master ...