MySQL

#1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

I had a struggle getting this to work i’ve tested it and it’s working on lamp server mysql version 5.12 So, steps to success: sudo vim /etc/mysql/conf.d/mysql.cnf Scroll to the bottom of file Copy and paste[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION to the bottom of the file save and exit input mode sudo service mysql restart to restart MySQL. Done!

Authentication plugin ‘caching_sha2_password’ cannot be loaded

You can change the encryption of the user’s password by altering the user with below Alter command : ALTER USER ‘username’@’ip_address’ IDENTIFIED WITH mysql_native_password BY ‘password’; OR We can avoid this error by make it work with old password plugin: First change the authentication plugin in my.cnf file for Linux / my.ini file in Windows: [mysqld] … Read more

How to restart remote MySQL server running on Ubuntu linux?

SSH into the machine. Using the proper credentials and ip address, ssh [email protected]. This should provide you with shell access to the Ubuntu server. Restart the mySQL service. sudo service mysql restart should do the job. If your mySQL service is named something else like mysqld you may have to change the command accordingly or try this: sudo /etc/init.d/mysql restart

What is the definition of cardinality in SQL

They are speaking the same thing and it has to do with tuples (relational algebra) or rows (layman’s term). When it says high-cardinality are possible values of particular attribute (or field) that are unique and therefore the number of rows or tuples are higher: Example: As far as as StudentID the cardinality is high because it is unique. In this it … Read more

Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table

“MySQL retrieves and displays DATETIME values in ‘YYYY-MM-DD HH:MM:SS’ format.” This is from mysql site. You can store only this type, but you can use one of the many time format functions to change it, when you need to display it. Mysql Time and Date functions For example, one of those functions is the DATE_FORMAT, which … Read more

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

MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user

I am facing problem with mysql non root/admin user, I am following the below steps for creating user and its privileges, correct me if i am doing wrong, i am installing mysql on RHEL 5.7 64bit, packages are mentioned below, once i done the rpm install we are creating mysql db using mysql_install_db, then starting the mysql service then using mysql_upgrade also we … Read more

Install mysql-python (Windows)

You’re going to want to add Python to your Path Environment Variable in this way. Go to: My Computer System Properties Advance System Settings Under the “Advanced” tab click the button that says “Environment Variables” Then under System Variables you are going to want to add / change the following variables: PYTHONPATH and Path. Here is a paste … Read more

+ More
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)