I've installed MySQL on a Google Cloud Virtual Machine (debian buster). What I want to do is to make this accessible publicly (using username / password obviously). As far as I can tell the server is visible from the outside…
I have a docker-compose.yml that builds about 8 containers made up mostly of mysql, postgres, php-nginx and a few other packages that are custom builds. The production version runs on an UBUNTU host, and my development package runs on Mac…
I have a quite unmodified new Laravel project, and I'm trying to get my first model up and running. I used ./vendor/bin/sail up to run the webserver and MySQL with the default settings. I can access the database from DBeaver,…
I installed MySQL server 8.0 in my ubuntu 20.04 EC2 instance and also did the secure installation using $ sudo mysql_secure_installation where I set the password for the root user. I also disabled login into MySQL through anonymous users. I…
I need to get catalogs from database using Laravel query, so I write simply: $catalogs = Catalog::where('shop_id', $shop->id)->latest()->get(['id','title', 'created_at', 'shop_id', 'cover_bg', 'frontpage', 'pdf', 'clicks', 'finished']); In a catalog table I have more than 100 columns - 2 of them are…
I want to run a php project with database on my server for learning purpose. After setting up xampp I pasted the project file[filename: HRMS-FRESH] in htdocs/ folder, Afterwards I made a database( same name as the sql file name…
and forgive me in advance as I somewhat a newbie. Am going to do my best to explain the situation in a way it could be generally understood. Long story short, as the title suggests. I have a website with…
I was working on a project with my client. I mostly do frontend work so I don't really understand what is wrong here. We got a white label license of a prebuilt app that we worked over and redesigned completely…
My SQL query is not working. Below is my code and note that in that table query worked fine and gives output. But in PHP by using mysqli_num_rows(), mysqli_fetch_assoc() and mysqli_fetch_array() all doesn't works for me. My DB connection is…
Well, I have multiple databases in django project. One is default and second istest_dev. i have created docker container. and then everything went well till building the container. after that When I try to call my django app api which…