MySQL

How do I access MySQL from the command line? How do I export a MySQL database? Get answers to your MySQL development questions here. We have a wide variety of articles covering everything from how to create a MySQL installation for local testing, renaming a MySQL database, what to do when MySQL runs out of memory, and much more:

• Connecting to MySQL from the command line
• Connecting to MySQL using PHP
• Connecting to MySQL using Python
• Connecting to MySQL using Node.js
• Connecting to MySQL using Microsoft .NET
• Connecting to MySQL using Perl
• Renaming a MySQL database
• Backing up MySQL databases using AutoMySQLBackup
• Installing phpMyAdmin on managed hosting accounts
• MySQL user privileges on shared servers
• Enabling the slow query log in MySQL
• Determining the size of MySQL databases and tables
• Creating and running MySQL stored functions and procedures
• Determining the MySQL version
• Repairing MySQL databases and tables
• Setting up a remote MySQL connection
• Managing MySQL databases, users, and tables from the command line
• Using MySQL client applications
• Understanding MySQL Error 1064
• Using SELECT INTO OUTFILE in MySQL
• Creating a MySQL installation for local testing
• Converting the MySQL time zone
• MySQL server runs out of memory or does not start
• Converting a MySQL database to UTF-8
• Using indexes to improve MySQL query performance
• Resetting the MySQL root password
• Working with MySQL database engines
• Using MySQL triggers
• Restricting MySQL port access
• The information_schema database in MySQL
• Importing and exporting a MySQL database
• Backing up MySQL databases using cron jobs
• Troubleshooting MySQL definer issues
• Using MySQL views