Categories
Cache Development MySQL PHP SQL

php7.4 mysql seems not installed

I have just installed php7.4, everything seems ok but when I try to go on my phpmyadmin, I can’t : Note works fine in php7.3 before this installation The error is : mysqli_real_connect(): Unexpected server response while doing caching_sha2 auth: 109 mysqli_real_connect(): (HY000/2006): MySQL server has gone away looking my php mysql library :php7.4-mysql. it’s […]

Categories
Database Development MySQL SQL

connection to a remote mysql database using node

Good mornig to you guys. I want to establish a connection to a remote mysql database using node js. but i am facing this error. I do not know if I wrongly specifies the access path to the db code var mysql = require(‘mysql’); var pool = mysql.createPool({ host: “http://kamerun-it.com/mysql“, connectionLimit : 100, database: “****”, […]

Categories
Development MySQL SQL

MySQL access denied for user ‘root’@’localhost’ when creating a new Phoenix project

I am trying to create a new Phoenix project with MySQL as the database. These are the steps I did $ mix phx.new hello –database mysql $ cd hello $ mix ecto.create This is the error I am getting 19:58:16.576 [error] GenServer #PID<0.2485.0> terminating ** (MyXQL.Error) (1045) (ER_ACCESS_DENIED_ERROR) Access denied for user ‘root’@’localhost’ (using password: […]

Categories
Development MySQL SQL

MySQL: why is a query using a VIEW less efficient compared to a query directly using the view’s underlying JOIN?

I have three tables, bug, bugrule and bugtrace, for which relationships are: bug 1——–N bugrule id = bugid bugrule 0———N bugtrace id = ruleid Because I’m almost always interested in relations between bug <—> bugtrace I have created an appropriate VIEW which is used as part of several queries. Interestingly, queries using this VIEW have […]

Categories
Database Development MySQL SQL

How to connect to database using mysqli?

I’m at the moment setting up an Apache2 Webserver which should connect to a database with the following code: <html> <body> <?php $link = mysqli_connect(“localhost”, mylogindata); if (!$link) { print mysqli_connect_error(); } else { print “success!”; } But when I’m connecting to the server I just get a blank page.

Categories
CMS Development Joomla MySQL SQL

Jooma Article content to load from mysql based on ID in url?

On my old website, built in php i had a link on a page, wich picked an ID based on what line it was. <td width=124><a href=”tp/package.php?ID=<?php echo $row[0];?>”>Package</a></td> When the link was pressed, it brought that ID with it, and helped populate the next page (package.php) with values from mysql based on that ID. […]

Categories
Development MySQL PHP SQL

PHP MySQL How to select 2 specific and 1 common value over 2 tables?

i have here two tables (only the important columns listed) : table1: unique_code(INT), spediteur(VARCHAR also Names), table2: unique_code(INT), versendet(timestamp) I have here a SELECT but that don’t work and if the value is true – that means: just let me into the IF WHEN: spediteur value is Name and versendet = 0000-00-00 00:00:00 and unique_code […]

Categories
Development MySQL SQL

Return DATE when year, week number and weekday given in one mysqli query

I have the following table : ————————————– | Year | Week | Weekday | Date | ————————————– | 2019 | 20 | 3 | | | 2019 | 10 | 4 | | | 2019 | 2 | 1 | | | 2019 | 41 | 2 | | ————————————– I would like the last […]

Categories
Development Linux MySQL SQL Ubuntu

Not entering into mysql server

I have deleted or Drop all users of database (MySql) even root too, after deleted I’m not entering in mysql command prompt in Kali linux. enter image description here

Categories
Development MySQL SQL

Print raw string in MySQL

I have a column which contains special characters. I want to print those characters as they are (escaped). I tried Quote. But that didn’t help me. This is what I want: select col1 from table; “Don’t\ttype\tlike\this\n\nNot acceptable”