Hi guys,
Our processes require that we create a database programatically. I use a bash script to create a mysql database, user and password with LAMP setup. When I use ssh and type SHOW DATABASES; in mysql, I see that the db is created and also the website works without any problems. However, the database is not accessible from AAPanel. I only see the databases created with the UI. Is there a way to see the database created with command line in AAPanel?
The code that i am using inside my bash script:
mysql -u root -p <<EOF
CREATE DATABASE IF NOT EXISTS ${DB_NAME};
GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASS}';
FLUSH PRIVILEGES;
EOF
