How to log in to a local database
<pre><code>MySQL -u(username) -p(password).
</code></pre>How to log in to a hosted database.
<pre><code>mysql -u(username) -p(password) -h
</code></pre>How to dump a database from a server.
<pre><code>mysql -u(username) -p(password) -h (db name)&gt;file.sql
</code></pre> Change password.
<pre><code> update user set password=PASSWORD(' new password') where User = ' your username';
</code></pre>

How to log in to a local database

```
MySQL -u(username) -p(password).
``` 


How to log in to a hosted database.

```
mysql -u(username)  -p(password) -h
``` 

How to dump a database from a server.

```
mysql -u(username)  -p(password) -h (db name)>file.sql

``` 

 Change password.

```
 update user set password=PASSWORD(' new password') where User = ' your username';

``` 




CodeBeast

CodeBeast

Mysql Database Basics