#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
You can solve this by finding in your .sql file, and swapping it with
mysql
PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
I found the reason why the connection was not working, it was because the connection was trying to connect to port 8888, when it needed to connect to port 8889. This fixed the problem, although changing the server name to localhost still gives the error. Connection failed: SQLSTATE[HY000] [2002] No such file or directory But … Read more
How do I import an SQL file using the command line in MySQL?
Try: Check MySQL Options. Note 1: It is better to use the full path of the SQL file file.sql. Note 2: Use -R and –triggers to keep the routines and triggers of original database. They are not copied by default. Note 3 You may have to create the (empty) database from MySQL if it doesn’t exist already and the exported SQL don’t contain CREATE DATABASE (exported … Read more
Invalid column count in CSV input on line 1 Error
Fixed! I basically just selected “Import” without even making a table myself. phpMyAdmin created the table for me, with all the right column names, from the original document.
Not unique table/alias
Your query contains columns which could be present with the same name in more than one table you are referencing, hence the not unique error. It’s best if you make the references explicit and/or use table aliases when joining. Try
mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
The query given to mysqli_query() is failing and returning false. Put this after mysqli_query() to see what’s going on. For more information: http://www.php.net/manual/en/mysqli.error.php
Installation of MySQL for Visual Studio 1.2.8 failed
Today I’ve encountered a similar error. In my case I couldn’t uninstall mysql-visualstudio-plugin-1.1.1.msi. Also had MySQL Connector Net 6.7.4 + 6.8.3 installed before (and more stuff which give and gave me many errors to solve manually). Before doing machine.config replacement as described below, first make a backup or rename them, of course. Modified versions of … Read more
Deprecated: mysql_connect()
There are a few solutions to your problem. The way with MySQLi would be like this: To run database queries is also simple and nearly identical with the old way: Turn off all deprecated warnings including them from mysql_*: The Exact file and line location which needs to be replaced is “/System/Startup.php > line: 2 … Read more
MySQL root password change
I found it! I forgot to hash the password when I changed it. I used this query to solve my problem: update user set password=PASSWORD(‘NEW PASSWORD’) where user=’root’; I forgot the PASSWORD(‘NEW PASSWORD’) and just put in the new password in plain text.
ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
Some systems like Ubuntu, MySQL is using the UNIX auth_socket plugin by default. Basically it means that: db_users using it, will be “authenticated” by the system user credentials. You can see if your root user is set up like this by doing the following: As you can see in the query, the root user is using the auth_socket plugin. There are two ways to solve this: … Read more