MySQL, database, tables, column, select, delete, record MySQL - Page 4 - Tech-Recipes

MySQL tutorials

Connect to a MySQL server using the mysql command

contributed by qmchenry on December 14, 2003 under MySQL

The mysql command provides a text-based interface into the MySQL database server. Once connected, SQL commands can be issued to the server to make queries, create or alter databases or tables, or many other operations.

MySQL – Daily database dumps, all nicely sorted.

contributed by acockrell on November 11, 2003 under MySQL

A nice shell script that can be run as a cron job to produce nice MySQL dumps for backup.

Change a MySQL user password

contributed by qmchenry on October 12, 2003 under MySQL

How do I update a user’s password in my MySQL server?

Create a MySQL user account

contributed by qmchenry on under MySQL

It is a good security policy to allow least privileges. Allowing all access to a system through a single account with all abilities is typically dangerous. Creating MySQL user accounts allows privileges to be granted as appropriate.

How to Dump Content using Mysqldump

contributed by vaiism on October 5, 2003 under MySQL

This command dumps the content of a database in MySQL to a text file. This will prompt for password of account used with ‘-p’

Change the MySQL Root User Password

contributed by qmchenry on August 30, 2003 under MySQL

Simple command for Changing the root user password for MySQL using mysqladmin.