The ‘MySQL’ Archives
Posted December 14, 2003 by

Determine the version of MySQL server

How do I tell what version of MySQL server that I am running?

Category MySQL

Posted December 14, 2003 by

Connect to a MySQL server using the mysql command

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.

Category MySQL

Posted November 11, 2003 by

MySQL – Daily database dumps, all nicely sorted.

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

Category MySQL

Posted October 12, 2003 by

Change a MySQL user password

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

Category MySQL

Posted October 12, 2003 by

Create a MySQL user account

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.

Category MySQL

Posted October 5, 2003 by

How to Dump Content using Mysqldump

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

Category MySQL

Posted August 30, 2003 by

Change the MySQL Root User Password

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

Category MySQL