New answers tagged mysql-workbench
When you run a query in MySQL Workbench you get actually 2 times in the action output window. The headeing also shows what they are for: There's the execution time on the server (which is probably your ~16s) and the, usually much larger, fetch time, to transport the data from the server to the client. With millions of records that can easily take minutes ...
The 16.04 seconds is a timer on the client that measures the amount of time that passed between the call and the execution of the query (if you want to be more specific than that, the wall clock time between calling start_timer() and mysql_end_timer(), something that can lead to hilarious results like this one I got). The reason that you think that it took ...
From here: "varchar fields were set to utf8_bin and needed to be changed to utf8_general_ci"
The error message tells you that the MySQL server is not accepting a connection for user adminM4B1hN at the given host. You need to allow such a connection for that user (e.g. by adding an anyhost user entry (adminM4B1hN@%) for that user. Also, keep in mind how the MySQL server is seen from the remote end of your SSH tunnel. If the tunnel ends on the same ...
Open terminal and edit /etc/mysql/my.cnf sudo nano /etc/mysql/my.cnf Underneath the [mysqld] section.add: lower_case_table_names = 1 Restart mysql sudo /etc/init.d/mysql restart Then check it here: mysqladmin -u root -p variables
Top 50 recent answers are included