6,995 questions
-4
votes
0
answers
37
views
Ошибка с подключением в vs22 к workvench mysql при работе на android local device [closed]
У меня создана база данных в workbench MySql на компьютере https://i.sstatic.net/82XeILhT.png. Я запускаю проект в Visual Studio 2022 с помощью android local device и оно запускается,но при попытке ...
0
votes
0
answers
23
views
Why I am unable to set CURRENT_DATE as DEFAULT VALUE Even in version 9.1.0 [duplicate]
I saw that CURRENT_DATE can be used as default value in MYSQL on versions greater than 8.0.13. But even in 9.1.0 its not working. Why? If it can be used as default value how to set it.
But ...
- 33
0
votes
0
answers
30
views
MYSQL compatiblity issue after installing workbench and server
Connection Warning (Local instance 3306)
Incompatible/nonstandard server version or connection protocol detected (9.2.0).
A connection to this database can be established but some MySQL Workbench ...
- 87
0
votes
0
answers
18
views
Synchronized Model in MySQL Workbench but still seeing "old" green arrows and SQL update scripts
I used Database > Synchronize Model and it completed successfully: I can see the changes in the Model successfully reflected in the database/scripts as expected.
But when I go back to Database > ...
- 4,058
0
votes
1
answer
64
views
fetch 10k records from 250k by searching from multiple indexed columns under 100ms
create database task250;
use task250;
CREATE TABLE Students (
id INT PRIMARY KEY AUTO_INCREMENT,
firstname VARCHAR(50),
lastname VARCHAR(50),
department VARCHAR(50)
);
CREATE TABLE ...
- 11
-2
votes
1
answer
67
views
Forgot MySQL Root Password – How to Reset?(I'm reinstalling the MYSQL and I cant remember current root password) [duplicate]
I installed MySQL, but I forgot the root password. When I try to log in, I get an authentication error. How can I reset the MySQL root password? when I type this mysql -u root,
I got this error ...
0
votes
0
answers
134
views
MySQL Workbench Visual Explain won't work
I'm beginning my journey to learn SQL.
For some reason when I run a query go to the Execution Plan and try to switch to Visual Explain it won't work and stay on the Tabular Explain.
I've downloaded ...
2
votes
1
answer
137
views
Migrating from MySQL 5.7 to 8 causing problems with fractional seconds
I was running a MySQL 5.7 database in AWS RDS and AWS forced me to upgrade it because I was getting charged daily for keeping an old version. So I upgraded it to 8.0.mysql_aurora.3.08.0.
I have also ...
- 2,833
0
votes
0
answers
68
views
Mysql Drop stored procedure on update
Some time ago i create a simple stored procedure:
CREATE DEFINER=`someuser`@`%` PROCEDURE `sp_foundRows`()
READS SQL DATA
SQL SECURITY INVOKER
BEGIN
SELECT FOUND_ROWS() AS count;
END
it ...
- 133
0
votes
1
answer
34
views
MySQL Workbench - Get data rows from model to db
I have made a model (EER / ERD) in MySQL workbench. With Database|Forward Engineering I got my data model into a local MySQL database. This has worked fine; I am seeing all the tables, constraints, ...
- 95.7k
0
votes
0
answers
10
views
Error in query and table is not shown in schemas
FUNCTION classx.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual.
there is not show table in DB.
i was create a DB and also create the table. but ...
-1
votes
1
answer
77
views
MariaDB, Mysql, Mysql Workbench and multiple users
We have a new Dell computer and want to work with mysql databases on it. In the past, we used Mysql workbench, Mysql-server and unique users on each computer, but now we want to give access to ...
0
votes
0
answers
22
views
i want to setup new connection but when i tried to run a script there is error showing access denied
i wanted to setup new connection i did also but when i try to run script it wont run there is error showing access denied
DROP USER 'newuser2'@'localhost';
CREATE USER 'newuser2'@'localhost' ...
0
votes
1
answer
50
views
How do I resolve an issue that prevents an SQL file from running on MySQL Workbench?
Note: I’m a complete beginner to SQL, and while I have coded before in other languages, I am confused with different things like the terms “instance” and "tab" and the concept of connection ...
- 1
0
votes
0
answers
116
views
MySQLWorkbench on Mac: Authentication plugin cannot be loaded [duplicate]
When using MySQL Workbench to connect to any of my DBs, I got the error
Failed to Connect to MySQL at localhost:3306 with user root
Authentication plugin '' cannot be loaded: dlopen(/usr/local/mysql/...
- 131