mysql-workbench Questions
10
Solved
I've tried to connect to the latest MySQL server 8.0.11 from MySQL workbench, but the error keeps popping up: Cannot connect to MySQL server, authentication plugin: caching_sha2_password: the speci...
Wakeless asked 4/5, 2018 at 7:34
10
Solved
I have been having issues switching to an offline version of the Lahman SQL baseball database. I was using a terminal embed into an EDX course. This command runs fine on the web terminal:
SELECT c...
Emissary asked 24/3, 2016 at 18:3
3
thank you for your time.
I am trying to build a database with with the following instructions
T1-Hotel (hotelNo, hotelName, city)
T2-Room (roomNo, hotelNo, type, price)
T3-Guest (guestNo, guestName...
Shout asked 12/10, 2020 at 17:27
11
Solved
I just installed MySQL Workbench and there are no connections available for my localhost server. When I try to make one, I get an error popup. Has anyone experienced something like this befor...
Neomaneomah asked 6/12, 2013 at 18:55
37
Solved
I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench.
I also noticed that it appears whenever I run long quer...
Meshwork asked 12/5, 2012 at 12:14
27
Could you help me solve this problem ?
When I try to click "query database" under database menu in Mysql workbench. it gives me an error:
Cannot Connect to Database Server
Your connectio...
Raddled asked 23/10, 2011 at 4:3
10
Am following this tutorial
http://thoughtsandideas.wordpress.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/
I am not able to Test DB Connection while creating n...
Delineation asked 10/5, 2013 at 17:55
7
Solved
Can anybody tell whether it possible for exporting only the table structure using MySQL workbench
Preoccupation asked 11/3, 2014 at 5:32
9
Having some trouble creating a mysql connection. The mysql instance is running in system preferences and I have made sure the mysql config file is in the right location(Test settings passed). When ...
Emotionality asked 30/8, 2015 at 9:55
6
I am encountering a problem concerning the export of a database.
First of all, I have to clarify that I am using MySQL Workbench 5.2.47. The procedure that I followed so far is the following:
I...
Stephanus asked 4/6, 2013 at 12:34
15
I am using mysql server inside docker container and able to access inside docker. How to create connection in mysql workbench running on my local(Host Machine).
Mujik asked 20/11, 2015 at 12:59
12
Solved
I´ve got a mysql-server that I´m administrate remotely with MySQL Workbench.
Now I´ve got a new computer and I cant find any solution to move my connections and instances-profiles to my new comput...
Lungworm asked 15/12, 2010 at 14:21
2
Solved
I am taking a data analytics and management course for my graduate program. We started doing simple lines of code today like create a table, select, and use functions. However, every-time I go to e...
Saccharometer asked 18/1, 2023 at 22:5
13
I have a trouble with my MySQL workbench 6.0 (i work on Ubuntu) and when I choose a server instance, instead of the "SCHEMAS" panel it shows the message "No object selected". In...
Zashin asked 24/10, 2014 at 12:30
3
I have a Mac and use parallels to access Windows 11. I am trying to download MySQL, and everything successfully downloaded except for the Workbench. It fails to install every time with the error, &...
Valiant asked 14/3, 2022 at 0:10
7
Solved
I am trying to change the font size of text in the SQL script or zoom in/out.
I couldn't figure out how. Is there a way I can do the same.
Masterful asked 25/10, 2017 at 18:5
3
Solved
I have created the following view in MySQL:
CREATE VIEW MYVIEW AS (
SELECT A.FNAME
, A.LNAME
, B.EMAIL
FROM EMPLOYEE A, EMPEMAIL B
WHERE A.EID = :empId
AND A.EID = B.EID
AND B.EMAILTYP = :emailT...
Futuristic asked 13/11, 2013 at 6:4
16
Solved
Cannot connect to MySQL Workbench on mac. I get the following error: Could not connect, server may not be running. Can't connect to MySQL server on '127.0.0.1' (61)
The help would be appreciated.
...
Shaynashayne asked 13/10, 2014 at 16:37
2
I am using the migration wizard provided by MySQL workbench 6.3 to convert a SQL Server database into a MySQL. I tested the connection between both DBs and they are valid for the migration wizard. ...
Saturday asked 9/12, 2015 at 19:12
4
Solved
I am attempting to write a short SQL query (in MySQL Workbench) that outputs the number of fails in a subject if it has been failed by more than one student.
Here's my attempt:
SELECT CONCAT(area...
Smalls asked 2/10, 2017 at 14:2
1
SQL Workbench immediately crashed after running a select query.
Device: M1 2020 MBP 13"
Note: I am using the MySQL Workbench 8.0.32 version for Mac
https://dev.mysql.com/downloads/workbench/
Overalls asked 16/2, 2023 at 4:0
9
Solved
I have a problem on this error message, when i try this:
INSERT INTO `PROGETTO`.`UFFICIO-INFORMAZIONI` (`ID`, `viale`, `num_civico`,
`data_apertura`, `data_chiusura`, `orario_apertura`, `orario_c...
Popgun asked 31/1, 2013 at 14:35
4
Solved
I am trying to run a script to import data into MySQL. When I tried, this error shown up. I have searched for a workaround but none is helping. I deleted all the related .cnf file in the said path ...
Neves asked 19/1, 2021 at 16:14
7
I am getting an error while running a SQL script to load data. Error is pasted below:
Preparing...
[WinError 32] The process cannot access the file because it is being used by another process: 'C:...
Heyes asked 26/1, 2021 at 20:1
23
Solved
I want to update the column visited to give it the value 1. I tried this command in the SQL editor inside MySQL workbench:
UPDATE tablename SET columnname=1;
But I get an error that says:
You are...
Leapt asked 12/7, 2012 at 8:44
© 2022 - 2024 — McMap. All rights reserved.