w3docs logo
  1. Snippets
    2. ›
  2. MySQL

How-to articles, tricks, and solutions about MYSQL

SQLSTATE[42S22]: Column not found: 1054 Unknown column

It looks like you are encountering an error with the message "SQLSTATE[42S22]: Column not found: 1054 Unknown column".

php MySQL laravel laravel-5

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

This error message typically indicates that the MySQL server is unable to authenticate the user 'root'@'localhost' with the provided password.

php MySQL authentication root

The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

It is true that the MySQL extension is deprecated, and it is recommended to use either MySQLi or PDO instead.

php MySQL deprecated

Using env variable in Spring Boot's application.properties

You can use environment variables in your application.properties file by using the spring.profiles.active property.

java MySQL spring spring-mvc openshift

UTF8 Encoding problem - With good examples

UTF-8 is a character encoding that represents each character in a text document as a unique numerical code.

php MySQL UTF-8 character-encoding

Warning: mysqli_connect(): (HY000/2002): No such file or directory

This error message is indicating that there is a problem connecting to the MySQL server.

php MySQL mysqli

Why shouldn't I use mysql_* functions in PHP?

The mysql_* functions in PHP are deprecated, meaning that they are no longer recommended for use and will likely be removed in a future version of PHP.

php MySQL