Database Archives - Page 40 of 44

Authentication plugin ‘caching_sha2_password’ cannot be loaded

I am connecting MySQL – 8.0 with MySQL Workbench and getting the below error: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image ...

April 29, 2022
0 Comments

Difference between partition key, composite key and clustering key in Cassandra?

I have been reading articles around the net to understand the differences between the following key types. But it just seems hard for ...

April 29, 2022
0 Comments

MySQL – UPDATE query based on SELECT Query

I need to check (from the same table) if there is an association between two events based on date-time. One set of data ...

April 29, 2022
0 Comments

How do I restore a dump file from mysqldump?

I was given a MySQL database file that I need to restore as a database on my Windows Server 2008 machine. I tried ...

April 29, 2022
0 Comments

MySQL Error #1071 – Specified key was too long; max key length is 767 bytes

When I executed the following command: ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` ); I got this error message: #1071 - ...

April 29, 2022
0 Comments

Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?

What are the differences between PRIMARY, UNIQUE, INDEX and FULLTEXT when creating MySQL tables? How would I use them? 3 s 3

April 29, 2022
0 Comments

MySQL: Grant all privileges on database

I’ve created database, for example ‘mydb’. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH'; GRANT ALL ...

April 28, 2022
0 Comments

How do I see all foreign keys to a table or column?

In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular column? This is ...

April 28, 2022
0 Comments

How to get size of mysql database?

How to get size of a mysql database? Suppose the target database is called “v3”. 9 s 9 Run this query and you’ll ...

April 28, 2022
0 Comments

Create new user in MySQL and give it full access to one database

I want to create a new user in MySQL and give it full access only to one database, say dbTest, that I create ...

April 27, 2022
0 Comments