I'm attempting to connect to a MYSQL database remotely. When trouble shooting I notice that the port is closed: nmap -p 3306 34.34.34.34 (substituting for my server ip) returns PORT STATE SERVICE 3306/tcp closed mysql In mysql config found at…
I am trying to run a transaction report but it is taking more than 40sec then timeout by the server. Hope I can get some help to get it optimised. select test_txn.abcid, txndate, txndate2 from test_txn inner join test_abc on…
Hello I have a project table which has a field name in my db which is multi lang so I stored it as json so I can store each lang value the problem is that the arabic lang is being…
when I using jdbc api to rollback sql, it doesnot work. i wonder where is this the problem? here is the codes: connection.setAutocommit(false); statement.execute("create table xxx"); connection.rollback(); table xxx should be rollbacked.
I have a database hosted on cpanel and I am not able to connect to it. I am using 'mysql' package in node js. It throws the timeout error. function create_connect(){ var connection = mysql.createConnection({ host : 'domain name', user…
I am using this if (!isset($_SESSION['login_success'])): header("Location:index.php"); die(); endif; It does work in local host but after i uploaded the site in server, when session expires it stays in the same page and not redirect to index or login page.
(Microsoft Surface Pro 7, Windows 11 Home, Python 3.10.1, MySQL 8.0.33) The goal: Load a netcdf-file with sizes up too about 400MB into the SQL-Database in under 15 minutes, the data in the necdf is given in the form of…
I have two tables - jobs, and jobEntries jobEntries has a jobId that maps to jobs, but wasn't set up as an "official" foreign key relationship so I can't use CASCADE DELETE. For each job, there are many jobEntries. I…
I'm trying to open a SQL template in Python which creates a database with tables and excutes using pymsql. However, I keep getting an error. import pymysql import Settings with open('Settings/databasetemplate.sql', 'r') as sql_file: sql = sql_file.read() conn = pymysql.connect(host='*****',…
when i GOOGLED about IN parameter i got this.. the value of an IN parameter is protected. It means that even if the value of the IN parameter is changed inside the procedure, its original value is retained after the…