### Hints

Various Hints
Tutorials
http://www.mysqltutorial.org
Grant Priviledges
To allow access from any IP address
mysql> GRANT ALL PRIVILEGES ON *.* TO 'YOURUSERNAME'@'%' IDENTIFIED BY 'YOUR USERPASSWORD';
mysql> FLUSH PRIVILEGES;
Example:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'flightsuser'@'%' identified by 'fu';
mysql> FLUSH PRIVILEGES;
Show all Databases
Login as user root, e.g. mysql -uroot -hlocalhost -p
mysql> show databases;
Example Output:
+--------------------+

# Database |

+--------------------+

# information_schema |

# books |

# flights |

# mysql |

# performance_schema |

+--------------------+
5 rows in set (0.01 sec)
Show all Users
Login as user root, e.g. mysql -uroot -hlocalhost -p
mysql> select host, user from mysql.user;
Example Output:
+-----------+------------------+

# host | user |

+-----------+------------------+

# % | booksuser |

# % | flightsuser |

# 127.0.0.1 | root |

# 33 | root |

# ::1 | root |

# localhost | booksuser |

# localhost | debian-sys-maint |

# localhost | flightsuser |

# localhost | root |

+-----------+------------------+

Changed: , Category: MySQL, File: T6C223M1651.htm, ID: 1651