i deleted and reinstall mariadb and i get this error: "Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details." when i use systemctl" status mariadb.service" i get this…
MySQL is not using the variables as it should. it is not taking any value from them it is incrementing the auto-increment numbers in the MYSQL table, however the row is not saved. I am not given any errors. I…
In Ubuntu 18.04 server, I use binary file to install zabbix4.0 according to the official website document of zabbix4.0, and I use MySQL 5.7.30 database. After installation, when I configure the front end of zabbix4.0,In the database configuration page, I…
I am trying to retrieve a value from a table stored in Mysql database using python(pycharm). But instead of outputting the stored value it outputs number of rows instead. import pymysql connection = pymysql.connect(host='localhost', user='root', password='passw', database='database1', charset='utf8', port=3306 )…
The server is working on CentOS 8, I'm trying to configure MariaDB by making alterations to /etc/my.cnf but then when I restart DB by doing sudo systemctl restart mariadb, the server does restart but no configuration changes get applied. mysql…
Let's say I have a login form, with 2 fields, email and password, first I want to check if the user email is actually registered or not, so I made a separate file named user_check.php with the PHP code to…
I'm using a PHP script to insert the unique value of an array into the database. Here's the script ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); if (isset($_POST['submit'])) { $df = $_POST['df']; $arr = array(); $file = fopen('files/'.$df.'.csv', 'r'); while (($line =…
I have a MYSQL Table called users. I also have a column called online_status. On my page I want a user to be able to toggle their status as 'Online' or 'Offline' and have this updated in the database when…
I have two sites with separate Wordpress instances. One is in the process of getting WooCommerce, the other has existing users with set groups to access courses. I the future access to the courses is supposed to be sold via…
I have an error when I create a Hikari connection, in a past have using mysql-connector but finally I decided use hikaricp. This is the error: [04:17:49] [Server thread/INFO]: HikariPool-1 - Starting... [04:17:49] [Server thread/INFO]: HikariPool-1 - Driver does not…