How To Test a New User Account and Password

Q

How To Test a New User Account and Password? - MySQL FAQs - Managing User Accounts and Access Privileges

✍: FYIcenter.com

A

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)

2007-05-10, 4979👍, 0💬

How To Add a New User Account
How To Add a New User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is... 2007-05-10, 5843👍, 0💬

How To Delete a User Account
How To Delete a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >... 2007-05-10, 5296👍, 0💬

What Are the Predefined User Accounts
What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes ... 2007-05-10, 5173👍, 0💬

How To Change the Password for Your Own User Account
How To Change the Password for Your Own User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to c... 2007-05-10, 5065👍, 0💬

How To List All Existing User Accounts
How To List All Existing User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL stores all existing user accounts in a table called "mysql.user". If you want see all user accoutns, you can use the "SELECT" command as shown in the tutorial exercise below: >cd \mysql\bin >mys... 2007-05-10, 5054👍, 0💬

How To Test a New User Account and Password
How To Test a New User Account and Password? - MySQL FAQs - Managing User Accounts and Access Privileges 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 ... 2007-05-10, 4980👍, 0💬

What Is a User Account
What Is a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges A user account is identified by a user name and defines the user's attributes, including the following: Password for connection authentication. User privileges, for examples: Shutdown_priv, Create_priv, Drop_priv, In... 2007-05-10, 4891👍, 0💬

How To Shutdown MySQL Server
How To Shutdown MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to shutdown your MySQL server, you can run the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin shutdown 2007-05-10, 4834👍, 0💬

How To Rename an Existing User Account Name
How To Rename an Existing User Account Name? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this: >cd \mysql\bin >mysql -... 2007-05-10, 4825👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.