mysql cli

mysql

### For showing mysql verseio
```
mysql --version

```

### For using mysql cli
```
mysql
```

# Mysql Login as Root USER
```
mysql -u root -p
```


#### If mysql showing error make sure u have set mysql as environment variable : c:\xampp\mysql\bin

### for using mysql as an user
```
mysql -u USER_NAME
```
### for using mysql as an user
```
mysql -u USER_NAME -p
```


## Database Manipulation

### create database
```
create database db_NAME;
```
### create table
``` 
create table table_NAME;
```


``` 
CREATE TABLE example ( id smallint unsigned not null auto_increment, name varchar(20) not null, constraint pk_example primary key (id) );
```


### for showing mysql databases
```
show databases;
```


### for using any database
```
use database_NAME;
```

### for showing tables under database
```
show tables;
```

### for describing any table
```
desc TABLE_NAME;
```

### for selecting and showing columns of a table
```
select host, user, password from user;
```

## For securing database access

1. delete all user where user column value is empty.
2. change the password of root user
  ```
  update user set password= PASSWORD('rakib72542') where user = 'root';
  
  ```
3. when password reseted restart mysql service