Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 2751

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

1 vote
1 answer
97 views

Make MySQL print a timestamp at each time it starts

I am investigating an issue in an environment where MySQL is often restarted, by various actors (backups admins etc). To make analysis saner, I need to know exactly when MySQL is (re)started. … Question: How to make MySQL print a timestamp at each time it starts? For unfortunate real-world reasons I can't get every single actor to reliably keep track of when they restart MySQL. …
Nicolas Raoul's user avatar
3 votes
Accepted

In MySQL Workbench, insert a new column at the "top" of a table?

OK, I have found! It is so easy I am ashamed I didn't find earlier... Plain old drag and drop. Just add the column at the bottom, then move it with your mouse to the position you want.
Nicolas Raoul's user avatar
3 votes
4 answers
16k views

In MySQL Workbench, insert a new column at the "top" of a table?

In MySQL Workbench, adding a new columns after all the others is easy, but I can't find a way to insert a new column where I want. …
Nicolas Raoul's user avatar
1 vote
1 answer
180 views

MySQL 5 on Mac 10.5: "problem connecting to the database"

I have worked with MySQL for years but I am stuck on a seemingly trivial problem. … The following error had occured: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) Please verify the connection parameters and try again. …
Nicolas Raoul's user avatar
2 votes

MySQL 5 on Mac 10.5: "problem connecting to the database"

I have found the problem: Somehow, MySQL decided to create mysql.sock in /private/tmp rather than in /var/mysql. … So, my solution was to create a symlink: cd /var sudo mkdir mysql sudo ln -s /private/tmp/mysql.sock mysql.sock Now everything works fine. …
Nicolas Raoul's user avatar