Here is a small newbie problem I found and resolved. The behavior of the GUI is a little confusing so I figure I will share. Running some Java examples, I have MySQL set up on Windows. After making a little progress I ran into a problem with a sample database JDBC connection. I wanted to look at that database connection's admin user info in the Workbench to see what's going on. So I click "Users and Privileges" - the gui pops up a message: "Access denied for user 'root'@'localhost' (using password: YES)" - what? I know the root password, set it myself. There was no opportunity to enter it in the GUI just now, only a rude popup. So I went hunting for some tip on how to update a config file for the GUI to read the root password.

¡Hi!, i have a case with two tables than can have a lot of matches entries and the time of fetching increases a lot. This tables can be Table A: Employees ------------------------- | Name | ID | Account | ------------------------- | Nicole | 01 | 12345 | | Alexis | 02 | 67890 | ------------------------- And Table B: BankAccounts -------------------------- | Name | ID | Account | -------------------------- | Nicole | 01 | 12345 | | Nicole | 01 | 67890 | //duplicates Accounts | Alexis | 02 | 67890 | //duplicates Accounts -------------------------- And i want to do this with a Left Join in a Table that can have more of 450,000 different entries Result Table C Column_A = ¿Exists the account number in other register? Column_B = if(NumberOfMatches > 1) //this means that the account be found in other user AND i want to get the first value of all posibles number of matches |Account exists in other user|Match in User.. ----------------------------------------------------------------------------- | Name | ID | Account | Column_A | NumberOfMatches | Column_B | BadID | --------------------------------------------------------------------|-------| | Nicole | 01 | 12345 | No | 1 | Nicole (OK) | null | | Alexis | 02 | 67890 | Yes | 2 | Nicole (BAD)| 01 | ----------------------------------------------------------------------------- Thanks and regards! Note: sorry for my english, im learning :p

When I try to run Work Bench from command Line: sudo mysql-workbench-community This happens: mkdir: cannot create directory '/run/user/0': Permission denied Warning: Schema “org.gnome.system.locale” has path “/system/locale/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy” has path “/system/proxy/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.http” has path “/system/proxy/http/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.https” has path “/system/proxy/https/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.ftp” has path “/system/proxy/ftp/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.socks” has path “/system/proxy/socks/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. /snap/mysql-workbench-community/9/gnome-platform/usr/lib/x86_64-linux-gnu/libgtk-3-0/gtk-query-immodules-3.0: /snap/mysql-workbench-community/9/gnome-platform/usr/lib/x86_64-linux-gnu/libffi.so.7: no version information available (required by /snap/mysql-workbench-community/9/usr/lib/x86_64-linux-gnu/libwayland-client.so.0) Using /snap/mysql-workbench-community/9/usr/lib/x86_64-linux-gnu/libproj.so. /snap/mysql-workbench-community/9/usr/bin/mysql-workbench-bin: /snap/mysql-workbench-community/9/gnome-platform/usr/lib/x86_64-linux-gnu/libffi.so.7: no version information available (required by /snap/mysql-workbench-community/9/usr/lib/x86_64-linux-gnu/libwayland-client.so.0) Authorization required, but no authorization protocol specified (mysql-workbench-bin:25805): Gtk-WARNING **: 15:02:23.059: cannot open display: :0 mysql --version mysql Ver 8.0.26-0ubuntu0.21.04.3 for Linux on x86_64 ((Ubuntu)) mysql-workbench-community --version enter code here Linux version: Ubuntu LTS 20.4

I am trying to import the .csv below (columns and 3 first records in txt in differenet blockquotes) into MySQL Workbench using the Table Data Import Wizard. I have tried many ways and realized that the issue lies with this particular .csv. I even used the LOAD DATA LOCAL INFILE statement with no success using the terminal but things get complicated dipslaying different errors. > LOAD DATA LOCAL INFILE "C:\Users\user\Documents\Edu_research\SQL\Project_TED\talks_final_effort_new1.csv" INTO TABLE talks FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '/n' IGNORE 1 ROWS; At first I used delimiter ',' and strings enclosed with '"' but everything was messed up, probably because of a column with long text with commas and double quotes etc., and it could not identify the columns. So I changed the delimiter to ';' but the same happened. Then I kept the ';'. I tried for the 1st record and it was imported but for the rest of the records it didn't. I broke it down to 3 records (displayed below) used the settings below and it showed this message again I believe the "enclosed by" setting with '"' is the problematic beacuse there are some """ in the description column. I am not sure if I can deal with it not manually neither using TABLE IMPORT WIZARD or LOAD statement. > talk_id;title;speaker_1;all_speakers;occupations;about_speakers;views;recorded_date;published_date;event;native_lang;available_lang;comments;duration;topics;related_talks;url;description > 1;Averting the climate crisis;Al Gore;{0: 'Al Gore'};{0: ['climate advocate']};{0: 'Nobel Laureate Al Gore focused the world’s attention on the global climate crisis. Now he’s showing us how we’re moving towards real solutions.\r\n'};3523392;2/25/2006;6/27/2006;TED2006;en;"['ar', 'bg', 'cs', 'de', 'el', 'en', 'es', 'fa', 'fr', 'fr-ca', 'gl', 'gu', 'he', 'hi', 'hr', 'hu', 'id', 'it', 'ja', 'ko', 'lt', 'lv', 'mk', 'nl', 'pl', 'pt', 'pt-br', 'ro', 'ru', 'sk', 'sl', 'sq', 'sr', 'sv', 'sw', 'th', 'tl', 'tr', 'uk', 'ur', 'vi', 'zh-cn', 'zh-tw']";272;977;"['alternative energy', 'cars', 'climate change', 'culture', 'environment', 'global issues', 'science', 'sustainability', 'technology']";"{243: 'New thinking on the climate crisis', 547: 'The business logic of sustainability', 2093: 'The state of the climate — and what we might do about it', 54715: 'How we can turn the tide on climate', 29968: 'The most important thing you can do to fight climate change: talk about it', 2339: ""Climate change is happening. Here's how we adapt""}";https://www.ted.com/talks/al_gore_averting_the_climate_crisis/ ;"With the same humor and humanity he exuded in ""An Inconvenient Truth,"" Al Gore spells out 15 ways that individuals can address climate change immediately, from buying a hybrid to inventing a new, hotter brand name for global warming." 92;The best stats you've ever seen;Hans Rosling;{0: 'Hans Rosling'};{0: ['global health expert; data visionary']};"{0: 'In Hans Rosling’s hands, data sings. Global trends in health and economics come to vivid life. And the big picture of global development -- with some surprisingly good news -- snaps into sharp focus.'}";14501685;2/22/2006;6/27/2006;TED2006;en;"['ar', 'az', 'bg', 'bn', 'bs', 'cs', 'da', 'de', 'el', 'en', 'es', 'et', 'fa', 'fi', 'fr', 'he', 'hi', 'hr', 'hu', 'id', 'is', 'it', 'ja', 'kn', 'ko', 'ku', 'lv', 'mk', 'ml', 'mn', 'nl', 'pl', 'pt', 'pt-br', 'ro', 'ru', 'sk', 'sr', 'sv', 'sw', 'ta', 'te', 'th', 'tr', 'uk', 'ur', 'vi', 'zh-cn', 'zh-tw']";628;1190;"['Africa', 'Asia', 'Google', 'demo', 'economics', 'global issues', 'health', 'statistics', 'global development', 'visualizations', 'math']";"{2056: ""Own your body's data"", 2296: 'A visual history of human knowledge', 620: 'Let my dataset change your mindset', 2806: ""Doesn't everyone deserve a chance at a good life?"", 2560: 'How Africa can keep rising', 1418: ""Let's put birth control back on the agenda""}";https://www.ted.com/talks/hans_rosling_the_best_stats_you_ve_ever_seen/ ;"You've never seen data presented like this. With the drama and urgency of a sportscaster, statistics guru Hans Rosling debunks myths about the so-called ""developing world.""" 7;Simplicity sells;David Pogue;{0: 'David Pogue'};{0: ['technology columnist']};"{0: 'David Pogue is the personal technology columnist for the New York Times and a tech correspondent for CBS News. He\'s also one of the world\'s bestselling how-to authors, with titles in the For Dummies series and his own line of ""Missing Manual"" books. '}";1920832;2/24/2006;6/27/2006;TED2006;en;"['ar', 'bg', 'de', 'el', 'en', 'es', 'fa', 'fr', 'he', 'hr', 'hu', 'it', 'ja', 'ko', 'nb', 'nl', 'pl', 'pt', 'pt-br', 'ro', 'ru', 'sr', 'tr', 'vi', 'zh-cn', 'zh-tw']";124;1286;"['computers', 'entertainment', 'interface design', 'media', 'music', 'performance', 'simplicity', 'software', 'technology']";"{1725: '10 top time-saving tech tips', 2274: 'The first secret of design is ... noticing', 172: 'Designing for simplicity', 2664: 'Meet the inventor of the electronic spreadsheet', 2464: 'The mind behind Linux', 1347: 'The secret structure of great talks'}";https://www.ted.com/talks/david_pogue_simplicity_sells/ ;"New York Times columnist David Pogue takes aim at technology’s worst interface-design offenders, and provides encouraging examples of products that get it right. To funny things up, he bursts into song." This .csv is a real trouble. I believe I have searched any possible link on the Internet to figure it out but still no success. What could be the problem here? I The only method i haven't used is via phpmyadmin but I don't think that the issue lies with the method/tool. Appreciate your help Thanks

I am currently trying to get some latitude and longitude data to import into a database using the data import wizard in mysql workbench. the problem is that the floating point values that get imported are modified by mysql workbench, or whatever query it's preforming, so they are useless. Example: 40.8152 turns into 40.0000. I cannot figure out why this is happening. I have the columns set to DECIMAL(6,4), but they still get modified when imported. Anybody have any ideas as to what might be causing this and how i can get these to import correctly? Edit: I have also tried FLOAT, FLOAT(6,4), DOUBLE and DOUBLE(6,4) with the same results. It either removes the trailing decimal values completely or sets them to 0.

I'm not very familiar with sql, so I'm using workbench to create a db. I keep getting this error: Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') REFERENCES project2.REF () ON DELETE CASCADE ON UPDATE CASCADE' at line 6 SQL Code: CREATE TABLE IF NOT EXISTS project2.REF_AUTH ( REF# INT(11) NOT NULL AUTO_INCREMENT, RAUTHOR VARCHAR(45) NOT NULL, PRIMARY KEY (REF#, RAUTHOR), CONSTRAINT REF# FOREIGN KEY () REFERENCES project2.REF () ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARACTER SET = big5 SQL script execution finished: statements: 4 succeeded, 1 failed Any help would be greatly appreciated.

Since some time ago, I've started with MySQL so I don't know Workbench very well. That little red x next to the number of the line that indicates an error does not disappear, even though everything is okay and I fixed what was wrong. A simple example: select * project where name='Anna' and I can execute it but x won't disappear unless I delete everything and type again. This is very annoying and I can't concentrate because of always thinking about what should be wrong. Could somebody tell me what to do to fix this? :(

I need to do a find a replace but rather than find one word to replace with another I have about 16k words, so as an example; table 1 has two words apple,orange - table 2 has the contents of a book, i want to be able to replace all the words apple and orange that exists in table 2 and replace them with ##, is there a query that does this ? my actual table 1 has about 16k words and table 2 has 8 million words. most of the examples on google suggests i type the words to find but that is not possible when i have 16k words I am using mysql workbench and an absolute beginner (from comment) table 1 has 16k names in a column - table 2 has emails and text in columns - i want to be able to censor out all the names in table 2 using the names in table one as a reference

I have a table datedim which has all the dates of a month in it. I have another table attendance that has dates on which attendance were taken. I need to write a query where i can get all the dates from the start till current. For eg. if attendance table has records starting from 3-Apr-2019 to 3-June-2019, i should get all the dates in between them.

I'm working with Arch Linux using MariaDB through LAMPP, whenever I use MySQL workbench and try to connect to my local database I get the following: > Your connection attempt failed for user 'root' to the MySQL server at 127.0.0.1:3306:
The name is not activatable. The reason why I mention that I'm using MariaDB is that I get this error when I test the connection: > Incompatible/nonstandard server version or protocol detected (10.4.32) <== MariaDB's version I can still continue despite the error, and it shows that it successfully connected to the database, however, whenever trying to run a SQL Script, it can't connect to the database. I've tried: using another user, reinstalling MySQL workbench, reinstalling XAMPP. Yet all of these attempts were in vain. Is there a method to solve this *whilst* keeping MariaDB?

I have synchronized a table between a model and a live server database in Workbench, but every time I rerun the "Synchronize With Any Source..." wizard, Workbench detects (falsely) that there is a difference between the model and the server for that table and wants to execute the exact same SQL query. The SQL in this case is the following: ALTER TABLE mydb.user_info CHANGE COLUMN last_update last_update DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP This statement has already been executed in my first run of the Wizard, and I can see that the table user_info is up to date on the live server. Why does it keep detecting it as a difference? Is it a known bug with MySQL Workbench or something...?

I was trying to use table data import wizard to import a csv file that uses utf-8 character set, and then the following error message shows up. >MySQLWorkbench - error message - Unhandled exception: 'ascii' codec can't decode byte Oxe4 in position 9: ordinal not in range (128) I have tried to set the schema's character set to utf-8/utfmb4, but it didn't work. The csv file is converted from Excel, and all its cells have been set to text form. I have to use utf-8 for the needed table for future use. How can I import this csv file? Do I need to change the server and the database's encoding language? If so, how can I do this on Mac?

Why doesn't this MySQL 5.6 stored procedure compile with MySQL Workbench? CREATE PROCEDURE spDataLocationSetActive ( IN driveLetter varchar(1), IN active tinyint(1) ) BEGIN if( Select DriveLetter From DataLocations Where DriveLetter = driveLetter ) then UPDATE DataLocations SET Active = 1 WHERE DriveLetter = driveLetter; end if; END 'DriveLetter', 'varchar(128)', 'NO', 'PRI', '', '' 'Directory', 'varchar(200)', 'NO', '', 'SCR\\DATA\\', '' 'MaxUsage', 'smallint(6)', 'NO', '', '95', '' 'Sequence', 'smallint(6)', 'YES', '', NULL, '' 'ErrorMessage', 'varchar(255)', 'YES', '', NULL, '' 'DriveCapacity', 'bigint(20)', 'YES', '', NULL, '' 'DriveFreeSpace', 'bigint(20)', 'YES', '', NULL, '' 'Active', 'tinyint(1)', 'NO', '', '1', '' Here is the result of Show Create Table DataLocations. Table,"Create Table" DataLocations,"CREATE TABLE DataLocations ( DriveLetter varchar(128) NOT NULL DEFAULT '', Directory varchar(200) NOT NULL DEFAULT 'SCR\\DATA\\', MaxUsage smallint(6) NOT NULL DEFAULT '95', Sequence smallint(6) DEFAULT NULL, ErrorMessage varchar(255) DEFAULT NULL, DriveCapacity bigint(20) DEFAULT NULL, DriveFreeSpace bigint(20) DEFAULT NULL, Active tinyint(1) NOT NULL DEFAULT '1', InactiveCount smallint(6) NOT NULL DEFAULT '0', LastInactiveDateTime datetime NOT NULL DEFAULT '2001-01-01 00:00:00', Enabled tinyint(1) NOT NULL DEFAULT '1', LastEnabledDateTime datetime NOT NULL DEFAULT '2001-01-01 00:00:00', PRIMARY KEY (DriveLetter), KEY IX_DataLocations_DriveLetter_Active_Enabled (DriveLetter,Active,Enabled) ) ENGINE=InnoDB DEFAULT CHARSET=latin1" and here is the insert statement INSERT INTO scdvr.DataLocations (DriveLetter, Directory, MaxUsage, Sequence, ErrorMessage, DriveCapacity, DriveFreeSpace, Active, InactiveCount, LastInactiveDateTime, Enabled, LastEnabledDateTime) VALUES ('/', 'SCDVR/', 85, 1, 15, 80000000000, 1, 0, '2001-01-01 00:00:00', 1, '2001-01-01 00:00:00'); I was wondering how to fix its syntax. Thank you.

I am trying to load data into mysql database form text file. LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS > error code: 1148. The used command is note allowed with this MySQL MySQL version 8.0.19.

I'm running mysql workbench on my local machine, connected to a remote sql server. I am able to apply changes to the database, however, I see this error every time I apply a change I can't seem to find any help online regarding this error, so I can't provide any more details Error: There was an error while applying the SQL script to the database. and in the message log ERROR: Can't write to SQL history file

I have 2 databases on mysql. **ge** and **ge_sc001.** I can access both of these through my asp.net mvc application locally. **Web.config** Later on when i deployed my application on the web server, and tried to access them from a remote machine. I changed **server=localhost** to my machine's external-facing IP address. Now I can access only one **ge**. when i try to access the second it gives me error. > Access denied for user 'root'@'' to database 'ge_sc001' Notice there is no localhost above i.e. 'root'@'localhost' **SHOW GRANTS** 'GRANT ALL PRIVILEGES ON . TO \'root\'@\'localhost\' IDENTIFIED BY PASSWORD \'*xxx\' WITH GRANT OPTION' 'GRANT PROXY ON \'\'@\'\' TO \'root\'@\'localhost\' WITH GRANT OPTION' UPDATE ------- I ran GRANT ALL ON ge_sc001.* TO 'root'@''; Now the error has change to > The provider did not return a ProviderManifestToken string. This is now happening on both of my schemas

I'm trying to migrate the data at my company from Excel to mySQL so I'm very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I'm trying to get through the mySQLTutorial) the error pops up: MySQLWorkbench.exe - No disk There is no disk in drive. Please insert disk in drive \Device\Harddisk\DR2 My setup for the new connection is as follows: Connection name: local Connection method: Standard (TCP/IP) Hostname: 127.0.0.1 Port: 3306 Default schema: "" Anyone have any ideas? I'm completely at a loss here...

Using MySQL Work Bench, When I look at the system variables of a server I am connected to, it shows the SQL_MODE as "no engine substitution" When I open a Workbench Model, and use the "sync with any source" menu item. When it alters the tables, it runs the alter query using the follow sql_mode: SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; Im not sure where it is getting that from, is it safe to override the sql_mode in the connection to be just no engine substitute? Why would it be trying to use a different mode when altering than the server shows it is using? The server itself is running 5.6.47

When trying to connect to a MySQL database in Azure I get the following error: > ERROR 2026: SSL connection error: socket layer receive error At first I thought it was a firewall/security issue but it appears not. The certificates are correct - and I have also tried with SSL disabled on both ends.

I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using. Does anyone know of an easy way to figure this out? If nothing else, the default location mysql/workbench uses for saving the raw data on a windows machine? Thanks in advance! Quintis