Hi I am using below code to connect with Mamp data base "http://localhost:8888/phpMyAdmin/server_databases.php?server=1" but not able to do it getting below error code :- const db = mysql.createConnection({ host: 'localhost', user: 'root', password: 'root', database: 'nodejs.login', }) db.connect((error) =>{ if(error){…
I created .yaml file to create mysql service on kubernetes for my internal application, but it's unreachable. I can reach application and also phpmyadmin to reach database but it's not working properly. I'm stuck with pending status on mysql pod.…
I get an error when I import sql file in phpmyadmin. Here is an error -- -- Indexes for table 'tbl_disposisi' -- ALTER TABLE 'tbl_disposisi' ADD PRIMARY KEY ('disposisi_kd'), ADD KEY 'fk_tbl_disposisi_tbl_berita_idx' ('arsip_kd') #1062 - Duplicate entry '2' for key…
I am trying to make a car booking system using a jquery datepicker. I have the date picker, I have dates in a database(manually inserted in WAMP SERVER phpMyAdmin) that highlight those dates as pre-booked dates (Cursor disabled in css…
The behavior I expect is that a query is first ran on the database to determine if a username or email already exist on there. If they do, skip if((count((array)$result) == 0)) because the result will either be 1 or…
The code below is completely wrong and does not work at all. Im basically trying to look through my tables and compile a list of DeptName and the total student number for a department where a department has more than…
I'm novice in backends but I really want to do this in some automatic way, the product pages I have to make are so many hard to handle when I have to edit codes in the future navigation menu <ul…
This working with mysql (5.7.32) php (8.0.0) and laravel 8. I get lat and lng using leaflet. in fact I did tests saving the number manually in the database and the same error occurs when I look at the database…
I m trying to dockerize a laravel project a small problem with my MySQL Container. I cant connect to the container my DB with root or simple user. I only used docker-compose build && docker-compose up -d docker exec -it…
I'm trying to connect to MySQL via nodeJS app using express for server, ive read the mysql npm documentation in order to begin connection but it seems like i get the error from the callback function i wrote inside createConnection.connect()…