Get all column names in MySQL of a table comma separated

 For that you can use the following MySQL: 

select group_concat(column_name order by ordinal_position) from information_schema.columns where table_schema = 'vops' and table_name = 'vmdata'

How to check the final SQL query generated by Entity Framework based on the LINQ expression for MySQL database

 If you want to check the final SQL query generated by  Entity Framework based on the LINQ expression for MySQL database  . you can follow the following steps : 

1. Connect to your MySQL command line 

2. run the following command :  SET GLOBAL general_log = 'ON';

3. In next command you need to setup the log file location. Here is the command for that SET GLOBAL general_log_file = 'C://file.log';

4. Execute the method for which you want to check the SQL query. 

5. Once you are done SET GLOBAL general_log = 'OFF'; run this. 

You can now check in your log file the output sql query from Entity Framework . 

Server sent charset unknown to the client.

 After install mysql 8. I'm trying to connect to a MySQL database from php. 

<?php

echo "Hello World!";

?>

</br>

<?php

$link = mysqli_connect('localhost', 'root', 'pass12#####');

if (!$link) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

die('Could not connect: ' . mysqli_error());

}

echo 'Connected successfully';

mysqli_close($link);

?>

</br>

<?php

phpinfo();

?>

</br>

But when I put in username and password I get the error message saying:

Server sent charset unknown to the client. Please, report to the developers

Solution

MySQL 8 changed the default charset to utf8mb4. But some clients don't know this charset. Hence when the server reports its default charset to the client, and the client doesn't know what the server means, it throws this error.

Edit my.cnf, specify the client code, and add the following content.

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

collation-server = utf8_unicode_ci

character-set-server = utf8