mysql-workbench Archives

MySQL, Programming

IT Nursery

Is there a naming convention for MySQL?

Here’s how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. foo, foo_bar, etc. I ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

How to get ER model of database from server with Workbench

Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench? 4 ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL Workbench: How to keep the connection alive

Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch of inserts, ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

String concatenation in MySQL

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it doesn’t work : ...

May 27, 2022
0 Comments

Create a new database with MySQL Workbench

Being new to MySQL, I have installed the latest version of the MySQL Workbench (5.2.33). I would like to know how you can ...

May 22, 2022
0 Comments

How do I enlarge an EER Diagram in MySQL Workbench?

I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. ...

May 20, 2022
0 Comments

Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a ...

May 11, 2022
0 Comments

MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect ...

May 7, 2022
0 Comments

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

MySQL error code: 1175 during UPDATE in MySQL Workbench

I’m trying to update the column visited to give it the value 1. I use MySQL workbench, and I’m writing the statement in ...

April 15, 2022
0 Comments