While having my daily specialty coffee from Latin America I got this error for one of my docker containers running MySQL. ERROR: ‘Could not set the file size of ./ibtmp1’. Suddenly the container failed to start and I could not understand why! I reviewed the logs for my container: docker logs <my_container_name> Something strange ‘Could […]
Tag Archives: mysql
MySQL how to insert a row into a table
Inserting data into MySQL tables is easy, but I tend to forget little details once in a while. I was having the best espresso coffee and trying to remember this one. Below is how you insert a new row into a MySQL table. Assume you created the following table: And then you want to insert […]
Connect to a remote MySQL database using Linux terminal
This is simple. After you setup a user with proper access rights run the below commands. # mysql -u yourUser -p -h <yourHostname or IP> A little explanation: -u tells mysql what your username -p tells mysql you have a password and will prompt you to enter it after you press enter -h tells mysql […]