MySql command list

Some helpful commands for using MySql from command-line.

MySql command list

Reconnect to the server

\r database_name

Change database

\u database_name

Exit from the client

\q

Help

\h

Set the password

Syntax

mysql> SET PASSWORD FOR username@hostname=PASSWORD('new_password');

Example

mysql> SET PASSWORD FOR root@localhost=PASSWORD('012345');

Notes

tags mysql command, command line mysql, mysql client

Publication details

Category: MySQL

Published by: loryzz on date: 03.02.2008 18:06:47

Last edit by: loryzz on date: 26.06.2008 12:00:49

Statistics

This article has been viewed 725 times.

Send to

Ratings

Currently 0; ?>/ TOTALSTARS
1
2
3
4
5

Comments

0 user comments, 0 still waiting.

Leave a comment

All comments must be approved by site administrator.
Please write comments on topic. Spam will be never approved.

MySQL: Linked articles

SQL: Selezionare righe duplicate published by loryzz in MySQL
Problemi di FLOAT published by loryzz in MySQL
MySQL table rename published by loryzz in MySQL
Password di root dimenticata published by loryzz in MySQL
Selezione condizionale published by loryzz in MySQL

Advertising

Tags