Frequently Asked Questions

The NearlyFreeSpeech.NET FAQ (*)

MySQL (*)

How do I get a MySQL process?

Ok, I have a MySQL process. How do I create a database?

What is the DSN (hostname) I should use to connect to my MySQL database?

What is the difference between a MySQL process and a MySQL database?

If I lose my MySQL admin user password, can you help me get it back?

How do I access my MySQL database process from the ssh server command line?

How do I access my MySQL database from my own computer?

Where can I find more information on properly creating MySQL users?

What are the default databases present in my MySQL process?

Why do I have to pay for a stopped MySQL process?

When I change my member password, do my MySQL passwords change too?

Why do I get an error "Cannot log in to the MySQL server" when I try to log in to phpMyAdmin?

What does the MySQL Error Can't connect to local MySQL server through socket '.../mysql.sock' (2) mean? (or socket 'please_see_the_faq')

When I try to log in to phpMyAdmin I get the error "the username was not provided." What should I do?

Why shouldn't I use my MySQL admin username from my web site?

What 'Host' value should I use when creating MySQL users?

How can I make automatic backups of MySQL?

How do I enable or disable InnoDB for my MySQL process?

How can I remove my MySQL process?

What username and password do I use to administer my MySQL process?

How do I upgrade MariaDB to a newer version?

Why do newly-created MySQL processes seem so expensive?

What does it mean that my MySQL process is "damaged?"

How do I enable or disable MySQL logs?

For MariaDB 10.x and later, set the following variables in a MySQL admin session, typically either via phpMyAdmin or from the MySQL command line client:

You can enable either or both of the log files, depending on your needs.

After taking these steps, log contents will be in the mysql.general_log and mysql.slow_log tables; no restart is required. Please see the MariaDB documentation for full details.

When you are finished, make sure to disable logging again, and truncate the log files to save space and cost:

For MariaDB 5.x, logging to tables is not supported. If you have an older process, consider upgrading, but in the mean time:

  1. Visit the MySQL panel of our member interface.
  2. Select the name of the relevant process to get to its MySQL Process Information panel.
  3. In the Actions box in the upper right, choose "Edit MySQL Settings."
  4. Enable the desired logs.
  5. Save the settings.
  6. Restart the process.
  7. Perform the activity you wish to log.
  8. Disable the logs.
  9. Request log retrieval using this assistance request.

On 5.x, when we retrieve logs, they will be removed and the process will be restarted.