Project Assignment 3

You should now have MySQL 5.0 and the GUI Tools installed and usable. Let's test things to make sure the server is ok.

Extra step for Windows users: Use the Control Panel - Admin Tools - Services to verify that mysql is running (look for a service called MySQL).

From your shell prompt:

• mysqlshow -u root -p

• mysqlshow -u root -p mysql

• mysql -u root -p -e "SELECT User, Host FROM user" mysql

• run the mysql command line client
  • via the start menu shortcut or your shell prompt:

    mysql -u root -p

• verify that only one root user account exists

  • show databases;

  • use mysql;

  • show tables;

  • SELECT User, Host FROM user;

  • exit;

Note that you may need to navigate to MySQL's bin directory if it's not in your path.

Paste the output of the SELECT statement into your documentation.