Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Testing New User Account and Password

By: FYIcenter.com

(Continued from previous topic...)

How To Test a New User Account and Password?

If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords:

>cd \mysql\bin
>mysql -u dev
ERROR 1045 (28000): Access denied for user 'dev'@'localhost'
 (using password: NO)

>mysql -u dev -pTEST
ERROR 1045 (28000): Access denied for user 'dev'@'localhost'
 (using password: YES)

>mysql -u dev -pretneciyf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39 to server version: 5.0.24-community

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test;
Database changed

mysql> SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| articles       |
| links          |
+----------------+
2 rows in set (0.04 sec)

(Continued on next topic...)

  1. What Is a User Account?
  2. What Are the Predefined User Accounts?
  3. How To Add a New User Account?
  4. How To Test a New User Account and Password?
  5. How To Change the Password for Your Own User Account?
  6. How To Change the Password of Another User Account?
  7. How To Delete a User Account?
  8. How To List All Existing User Accounts?
  9. How To Rename an Existing User Account Name?
  10. What Are User Privileges?
  11. How Many Scope Levels Can User Privileges Apply?
  12. How To Grant User Privileges at the Global Level?
  13. How To Grant User Privileges at the Database Level?
  14. How To View User Privileges?
  15. How To Revoke User Privileges?
  16. How To Give a User Read-Only Access to a Database?
  17. Where Are User Privileges Stored on the Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...